ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714C51A9E05362FB09050512Y select assignment_id, assignment_action_id, person_id, full_name, assignment_number, position_title, salary, location_id, location_code, expense_check_send_to_address, legal_employer, payroll_id, payroll_action_id, time_period_id, period_number, to_char(period_start_date,'DD-Mon-YYYY') period_start_date, to_char(period_end_date,'DD-Mon-YYYY') period_end_date, to_char(pay_advice_date,'DD-Mon-YYYY') pay_advice_date, to_char(date_earned,'DD-Mon-YYYY') date_earned, run_assignment_action_id, run_payroll_action_id, PAY_PAYSGSOE_XMLP_PKG.cf_address_line1formula(expense_check_send_to_address, person_id, location_id) CF_ADDRESS_LINE1, PAY_PAYSGSOE_XMLP_PKG.cf_gross_pay_currformula(assignment_action_id, person_id) CF_GROSS_PAY_CURR, PAY_PAYSGSOE_XMLP_PKG.CP_ADDRESS_LINE2_p CP_ADDRESS_LINE2, PAY_PAYSGSOE_XMLP_PKG.CP_ADDRESS_LINE3_p CP_ADDRESS_LINE3, PAY_PAYSGSOE_XMLP_PKG.CP_TOWN_p CP_TOWN, PAY_PAYSGSOE_XMLP_PKG.CP_POST_CODE_p CP_POST_CODE, PAY_PAYSGSOE_XMLP_PKG.CP_COUNTRY_p CP_COUNTRY, PAY_PAYSGSOE_XMLP_PKG.CP_GROSS_PAY_YTD_p CP_GROSS_PAY_YTD, PAY_PAYSGSOE_XMLP_PKG.CP_STAT_DED_CURR_p CP_STAT_DED_CURR, PAY_PAYSGSOE_XMLP_PKG.CP_STAT_DED_YTD_p CP_STAT_DED_YTD, PAY_PAYSGSOE_XMLP_PKG.CP_OTHER_CURR_p CP_OTHER_CURR, PAY_PAYSGSOE_XMLP_PKG.CP_OTHER_YTD_p CP_OTHER_YTD, PAY_PAYSGSOE_XMLP_PKG.CP_NON_PAY_CURR_p CP_NON_PAY_CURR, PAY_PAYSGSOE_XMLP_PKG.CP_NON_PAY_YTD_p CP_NON_PAY_YTD, PAY_PAYSGSOE_XMLP_PKG.CP_NET_PAY_CURR_p CP_NET_PAY_CURR, PAY_PAYSGSOE_XMLP_PKG.CP_NET_PAY_YTD_p CP_NET_PAY_YTD, PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYEE_CPF_CURR_p CP_EMPLOYEE_CPF_CURR, PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYEE_CPF_YTD_p CP_EMPLOYEE_CPF_YTD, PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYER_CPF_CURR_p CP_EMPLOYER_CPF_CURR, PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYER_CPF_YTD_p CP_EMPLOYER_CPF_YTD, PAY_PAYSGSOE_XMLP_PKG.CP_TOTAL_CPF_CURR_p CP_TOTAL_CPF_CURR, PAY_PAYSGSOE_XMLP_PKG.CP_TOTAL_CPF_YTD_p CP_TOTAL_CPF_YTD from pay_sg_asg_payment_runs_v where business_group_id = :p_business_group_id and payroll_id = :p_payroll_id and payroll_action_id = :p_payroll_action_id &cp_where_clause &cp_order_by PAY PAYSGSOE_XML US PAY Pay Advice (Singapore) Imported from BI Publisher Description: Pay Advice (Singapore) Application: Payroll Source: Pay Advice (Singapore) (XML) Short Name: PAYSGSOE_XML DB package: PAY_PAYSGSOE_XMLP_PKG BI Publisher &cp_order_by &cp_where_clause :cp_abs_this_period :cp_address_line2 :cp_address_line3 :cp_country :cp_display_deductions :cp_display_earnings :cp_display_messages :cp_employee_cpf_curr :cp_employee_cpf_ytd :cp_employer_cpf_curr :cp_employer_cpf_ytd :cp_gross_pay_ytd :cp_net_accrual :cp_net_pay_curr :cp_net_pay_ytd :cp_non_pay_curr :cp_non_pay_ytd :cp_order_by :cp_other_curr :cp_other_ytd :cp_post_code :cp_stat_ded_curr :cp_stat_ded_ytd :cp_total_cpf_curr :cp_total_cpf_ytd :cp_town :cp_where_clause :p_assignment_id :p_business_group_id :p_conc_request_id :p_location_id :p_organization_name :p_payroll_action_id :p_payroll_id :p_sort_order_1 :p_sort_order_2 :p_sort_order_3 :p_sort_order_4 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Id 2 10 :p_payroll_id LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name Y US Payroll 3 20 :p_payroll_action_id LOV Oracle PY_SG_SOE_PAYMENT_RUN Y select payroll_action_id id, to_char(nvl(ppa.pay_advice_date,ppa.effective_date),'DD-MON-YYYY') || ' (' || to_char(ppa.payroll_action_id) || decode(ppa.action_type,'U','(Quickpay)',null) || ')' value, null description from pay_payroll_actions ppa where action_type in ('P','U') and action_status='C' and payroll_id=:$flex$.py_srs_payroll order by payroll_action_id Y US Payment Run 4 30 :p_organization_name LOV Oracle PY_SG_SOE_ORG_UNITS Y select substr(name,1,150) id, substr(name,1,150) value, null description from hr_organization_units where business_group_id=fnd_global.per_business_group_id order by value,description US Organization 5 40 :p_location_id LOV Oracle PY_SG_SOE_LOCATION_CODES Y select location_id id, location_code value, description description from hr_locations where location_use='HR' order by value,description US Location 6 50 :p_assignment_id LOV Oracle PY_SG_SOE_ASG_NUMBER Y select assignment_id id, assignment_number value, null description from per_assignments asg,per_people peo where asg.payroll_id=:$flex$.py_srs_payroll and asg.person_id=peo.person_id and exists (select null from pay_assignment_actions pac,pay_payroll_actions ppa where ppa.payroll_id=asg.payroll_id and ppa.payroll_action_id=pac.payroll_action_id and ppa.payroll_action_id=:$flex$.py_sg_soe_payment_run) order by asg.assignment_number US Assignment Number 7 60 :p_sort_order_1 LOV Oracle PY_SG_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='SG_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 1 8 70 :p_sort_order_2 LOV Oracle PY_SG_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='SG_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 2 9 80 :p_sort_order_3 LOV Oracle PY_SG_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='SG_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 3 10 90 :p_sort_order_4 LOV Oracle PY_SG_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='SG_SOE_SORT_BY' and enabled_flag='Y' order by meaning select meaning from HR_LOOKUPS where lookup_type = 'SG_SOE_SORT_BY' and lookup_code = 'ASSIGNMENT_NUMBER' US Sort Order 4