ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713951A9E05362FB09050512Y select paa.ASSIGNMENT_ID, paa.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID1, paa.PERSON_ID, paa.JOB_TITLE, paa.ASSIGNMENT_NUMBER, paa.NI_NUMBER, paa.LOCATION_ID, paa.INTERNAL_ADDRESS_LINE, paa. EXPENSE_CHECK_SEND_TO_ADDRESS , paa.SALARY, paa.DATE_EARNED, paa.PAYROLL_ACTION_ID, paa.PAY_BASIS, paa.RUN_ASSIGNMENT_ACTION_ID, paa.RUN_EFFECTIVE_DATE, paa.RUN_PAYROLL_ACTION_ID, paa.TIME_PERIOD_ID, paa.PAYROLL_ID, paa.PAY_ADVICE_DATE, paa.LAST_NAME, paa.INITIALS, Initcap(paa.TITLE) Title , rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER1_dup),27) SEGMENT1C , rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER2_dup),27) SEGMENT2C, rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER3_dup),27) SEGMENT3C, rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER4_dup),27) SEGMENT4C, rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER5_dup),27) SEGMENT5C, rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER6_dup),27) SEGMENT6C, PAY_PAYGBSOE_XMLP_PKG.c_nameformula(Initcap ( paa.TITLE ), paa.INITIALS, paa.LAST_NAME) C_NAME, --&c_output2 C_GET_ADDRESS, --&c_output C_FF, PAY_PAYGBSOE_XMLP_PKG.populate_fields(paa. EXPENSE_CHECK_SEND_TO_ADDRESS , paa.PERSON_ID , rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER1_dup_1),27), rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER1_dup_2),27), rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER1_dup_3),27), rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER1_dup_4),27), rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER1_dup_5),27), rpad(Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER1_dup_6),27) ) C_GET_ADDRESS, PAY_PAYGBSOE_XMLP_PKG.get_ff_data(paa.RUN_EFFECTIVE_DATE,paa.DATE_EARNED,paa.ASSIGNMENT_ID,paa.RUN_ASSIGNMENT_ACTION_ID,paa.PAYROLL_ACTION_ID,:p_bus_grp_id )C_FF, PAY_PAYGBSOE_XMLP_PKG.c_amount_paidformula(:C_PAYMENT_TOTAL, :C_DEDUCTION_TOTAL) C_AMOUNT_PAID, PAY_PAYGBSOE_XMLP_PKG.cf_euro_amountformula(:C_AMOUNT_PAID) CF_EURO_AMOUNT, PAY_PAYGBSOE_XMLP_PKG.segment1() C_SEG_NAME1, PAY_PAYGBSOE_XMLP_PKG.segment2() C_SEG_NAME2, PAY_PAYGBSOE_XMLP_PKG.segment3() C_SEG_NAME3, PAY_PAYGBSOE_XMLP_PKG.segment4() C_SEG_NAME4, PAY_PAYGBSOE_XMLP_PKG.segment5() C_SEG_NAME5, PAY_PAYGBSOE_XMLP_PKG.segment6() C_SEG_NAME6, PAY_PAYGBSOE_XMLP_PKG.C_ADDRESS1_p C_ADDRESS1, PAY_PAYGBSOE_XMLP_PKG.C_ADDRESS2_p C_ADDRESS2, PAY_PAYGBSOE_XMLP_PKG.C_ADDRESS3_p C_ADDRESS3, PAY_PAYGBSOE_XMLP_PKG.C_REGION1_p C_REGION1, PAY_PAYGBSOE_XMLP_PKG.C_REGION2_p C_REGION2, PAY_PAYGBSOE_XMLP_PKG.C_REGION3_p C_REGION3, PAY_PAYGBSOE_XMLP_PKG.C_ACCOUNT_NO_p C_ACCOUNT_NO, PAY_PAYGBSOE_XMLP_PKG.C_TOWN_p C_TOWN, PAY_PAYGBSOE_XMLP_PKG.C_ANNUAL_SALARY_p C_ANNUAL_SALARY, to_char(PAY_PAYGBSOE_XMLP_PKG.C_PAY_DATE_p,'YYYY-MM-DD') C_PAY_DATE, PAY_PAYGBSOE_XMLP_PKG.C_TAX_PERIOD_p C_TAX_PERIOD, PAY_PAYGBSOE_XMLP_PKG.C_TAX_REFERENCE_NO_p C_TAX_REFERENCE_NO, PAY_PAYGBSOE_XMLP_PKG.C_TAX_CODE_p C_TAX_CODE, PAY_PAYGBSOE_XMLP_PKG.C_TAX_BASIS_p C_TAX_BASIS, PAY_PAYGBSOE_XMLP_PKG.C_NI_CATEGORY_p C_NI_CATEGORY, PAY_PAYGBSOE_XMLP_PKG.C_TAX_TEL_NO_p C_TAX_TEL_NO, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R1_TXT_p C_BALANCE_R1_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R1_VAL_p C_BALANCE_R1_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R2_TXT_p C_BALANCE_R2_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R2_VAL_p C_BALANCE_R2_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R3_TXT_p C_BALANCE_R3_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R3_VAL_p C_BALANCE_R3_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R4_TXT_p C_BALANCE_R4_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R4_VAL_p C_BALANCE_R4_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R5_TXT_p C_BALANCE_R5_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R5_VAL_p C_BALANCE_R5_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R6_TXT_p C_BALANCE_R6_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R6_VAL_p C_BALANCE_R6_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R7_TXT_p C_BALANCE_R7_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R7_VAL_p C_BALANCE_R7_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R8_TXT_p C_BALANCE_R8_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R8_VAL_p C_BALANCE_R8_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R9_TXT_p C_BALANCE_R9_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R9_VAL_p C_BALANCE_R9_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R10_TXT_p C_BALANCE_R10_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R10_VAL_p C_BALANCE_R10_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R11_TXT_p C_BALANCE_R11_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R11_VAL_p C_BALANCE_R11_VAL, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R12_TXT_p C_BALANCE_R12_TXT, PAY_PAYGBSOE_XMLP_PKG.C_BALANCE_R12_VAL_p C_BALANCE_R12_VAL, PAY_PAYGBSOE_XMLP_PKG.C_OUTPUT2_p C_OUTPUT2, PAY_PAYGBSOE_XMLP_PKG.C_OUTPUT_p C_OUTPUT from pay_gb_assignment_actions_v paa where PAYROLL_ID=:P_PAYROLL_ID AND time_period_id=:P_TIME_PERIOD_ID AND paa.PAY_ADVICE_DATE = NVL(fnd_date.displaydate_to_date(substr(:P_PAY_ADVICE_DATE,1, length(fnd_date.date_to_displaydate(sysdate)))) ,paa.PAY_ADVICE_DATE) AND paa.ASSIGNMENT_ID = NVL(:P_ASSIGNMENT_ID, paa.ASSIGNMENT_ID) ORDER BY DECODE(EXPENSE_CHECK_SEND_TO_ADDRESS,'H','H','O'), Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER1_dup) , Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER2_dup), Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER3_dup), Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER4_dup), Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER5_dup), Decode(expense_check_send_to_address,'H',Null,&P_SORT_ORDER6_dup), &P_SORT_ORDER7 PAY PAYGBSOE_XML US PAY Pay Advice Imported from BI Publisher Description: GB Pay Advice Report Application: Payroll Source: Pay Advice (XML) Short Name: PAYGBSOE_XML DB package: PAY_PAYGBSOE_XMLP_PKG BI Publisher &c_output &c_output2 &p_sort_order1_dup &p_sort_order1_dup_1 &p_sort_order1_dup_2 &p_sort_order1_dup_3 &p_sort_order1_dup_4 &p_sort_order1_dup_5 &p_sort_order1_dup_6 &p_sort_order2_dup &p_sort_order3_dup &p_sort_order4_dup &p_sort_order5_dup &p_sort_order6_dup &p_sort_order7 :c_2 :c_account_no :c_address1 :c_address2 :c_address3 :c_amount_paid :c_annual_salary :c_balance_r10_txt :c_balance_r10_val :c_balance_r11_txt :c_balance_r11_val :c_balance_r12_txt :c_balance_r12_val :c_balance_r1_txt :c_balance_r1_val :c_balance_r2_txt :c_balance_r2_val :c_balance_r3_txt :c_balance_r3_val :c_balance_r4_txt :c_balance_r4_val :c_balance_r5_txt :c_balance_r5_val :c_balance_r6_txt :c_balance_r6_val :c_balance_r7_txt :c_balance_r7_val :c_balance_r8_txt :c_balance_r8_val :c_balance_r9_txt :c_balance_r9_val :c_date_earned :c_deduction_total :c_formula_id :c_formula_id2 :c_ni_category :c_output :c_output2 :c_output3 :c_pay_date :c_payment_total :c_region1 :c_region2 :c_region3 :c_tax_basis :c_tax_code :c_tax_period :c_tax_reference_no :c_tax_tel_no :c_town :p_assignment_id :p_bus_grp_id :p_conc_request_id :p_pay_advice_date :p_payroll_exists :p_payroll_id :p_session_date :p_sort_order1 :p_sort_order1_dup :p_sort_order1_dup_1 :p_sort_order1_dup_2 :p_sort_order1_dup_3 :p_sort_order1_dup_4 :p_sort_order1_dup_5 :p_sort_order1_dup_6 :p_sort_order2 :p_sort_order2_dup :p_sort_order3 :p_sort_order3_dup :p_sort_order4 :p_sort_order4_dup :p_sort_order5 :p_sort_order5_dup :p_sort_order6 :p_sort_order6_dup :p_sort_order7 :p_time_period_id 1 -20 :p_bus_grp_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Id 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 Payroll Name 3 20 :p_time_period_id LOV Oracle PY_SRS_PAY_PERIOD_ID Y select time_period_id id, period_name value, null description from per_time_periods p,fnd_sessions f where p.payroll_id=:$flex$.py_srs_payroll and p.start_date<=f.effective_date and f.session_id= userenv('sessionid') order by p.start_date desc select p.period_name from per_time_periods p,fnd_sessions f where p.payroll_id = :$flex$.payroll and f.session_id = userenv('sessionid') and f.effective_date between p.start_date and p.end_date Y US Period Payroll Period Name 4 30 :p_pay_advice_date LOV Oracle PY_SRS_PAY_ADVICE_DATE_CHAR Y select fnd_date.date_to_displaydate(nvl(pact.pay_advice_date,ptp.pay_advice_date))||' ('||to_char(pact.request_id)||')' id, fnd_date.date_to_displaydate(nvl(pact.pay_advice_date,ptp.pay_advice_date))||' ('||to_char(pact.request_id)||')' value, null description from pay_payroll_actions pact,per_time_periods ptp where pact.payroll_id=:$flex$.py_srs_payroll and pact.time_period_id=:$flex$.py_srs_pay_period_id and ptp.time_period_id=:$flex$.py_srs_pay_period_id and pact.rowid in (select max(p.rowid) from pay_payroll_actions p where p.time_period_id=ptp.time_period_id group by nvl(p.pay_advice_date,ptp.pay_advice_date)) order by 1 US Pay Advice Date Pay Advice Date 5 40 :p_assignment_id LOV Oracle PY_SRS_PREPAID_ASSIGNMENTS Y Y select assignment_id id, assignment_number value, null description from per_all_assignments_f asg,fnd_sessions ses,per_all_people_f peo where asg.payroll_id=:$flex$.py_srs_payroll and ses.session_id=userenv('sessionid') and ses.effective_date between asg.effective_start_date and asg.effective_end_date and asg.person_id=peo.person_id and ses.effective_date between peo.effective_start_date and peo.effective_end_date and exists (select null from pay_assignment_actions assact, pay_payroll_actions pact,pay_action_interlocks l,pay_assignment_actions assact2,pay_payroll_actions pact2 where pact.payroll_id=:$flex$.py_srs_payroll and pact.time_period_id=:$flex$.py_srs_pay_period_id and pact.action_type in ('R','Q') and pact.payroll_action_id=assact.payroll_action_id and asg.assignment_id=assact.assignment_id and l.locked_action_id=assact.assignment_action_id and l.locking_action_id=assact2.assignment_action_id and pact2.payroll_action_id=assact2.payroll_action_id and pact2.action_type in ('P','U') ) order by asg.assignment_number US Assignment Number Assignment Number 6 50 :p_sort_order1 LOV Oracle PY_PEOPLE_GROUP_SORT Y select application_column_name id, segment_name value, null description from fnd_id_flex_segments where application_id between 801 and 899 and id_flex_code='GRP' and id_flex_num=(select people_group_structure from per_business_groups where business_group_id=fnd_global.per_business_group_id) order by value,description US Sort Order 1 Sort Order 1 7 60 :p_sort_order2 LOV Oracle PY_PEOPLE_GROUP_SORT Y select application_column_name id, segment_name value, null description from fnd_id_flex_segments where application_id between 801 and 899 and id_flex_code='GRP' and id_flex_num=(select people_group_structure from per_business_groups where business_group_id=fnd_global.per_business_group_id) order by value,description US Sort Order 2 Sort Order 2 8 70 :p_sort_order3 LOV Oracle PY_PEOPLE_GROUP_SORT Y select application_column_name id, segment_name value, null description from fnd_id_flex_segments where application_id between 801 and 899 and id_flex_code='GRP' and id_flex_num=(select people_group_structure from per_business_groups where business_group_id=fnd_global.per_business_group_id) order by value,description US Sort Order 3 Sort Order 3 9 80 :p_sort_order4 LOV Oracle PY_PEOPLE_GROUP_SORT Y select application_column_name id, segment_name value, null description from fnd_id_flex_segments where application_id between 801 and 899 and id_flex_code='GRP' and id_flex_num=(select people_group_structure from per_business_groups where business_group_id=fnd_global.per_business_group_id) order by value,description US Sort Order 4 Sort Order 4 10 90 :p_sort_order5 LOV Oracle PY_PEOPLE_GROUP_SORT Y select application_column_name id, segment_name value, null description from fnd_id_flex_segments where application_id between 801 and 899 and id_flex_code='GRP' and id_flex_num=(select people_group_structure from per_business_groups where business_group_id=fnd_global.per_business_group_id) order by value,description US Sort Order 5 Sort Order 5 11 100 :p_sort_order6 LOV Oracle PY_PEOPLE_GROUP_SORT Y select application_column_name id, segment_name value, null description from fnd_id_flex_segments where application_id between 801 and 899 and id_flex_code='GRP' and id_flex_num=(select people_group_structure from per_business_groups where business_group_id=fnd_global.per_business_group_id) order by value,description US Sort Order 6 Sort Order 6 12 110 :p_sort_order7 LOV Oracle PY_SRS_PAY_ADVICE_LAST_SORT Y select h.lookup_code id, h.meaning value, null description from hr_lookups h where h.lookup_type='PY_SRS_PAY_ADVICE_LAST_SORT' order by value,description ASSIGNMENT_NUMBER Y US Sort Order 7 :$flex$.payroll Payroll Period :$flex$.py_srs_pay_period_id Period Assignment Number :$flex$.py_srs_pay_period_id Period Pay Advice Date :$flex$.py_srs_payroll Payroll Assignment Number :$flex$.py_srs_payroll Payroll Pay Advice Date :$flex$.py_srs_payroll Payroll Period