eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 90: -- pay_action_information_api.create_action_information

86: -- ,p_report_date IN DATE);
87: --
88: -- Needs to populate the archive as follows:-
89: --
90: -- pay_action_information_api.create_action_information
91: -- (p_action_context_type => 'AAP'
92: -- ,p_action_context_id => p_assignment_action_id
93: -- ,p_action_information_id => l_act_inf_id
94: -- ,p_object_version_number => l_ovn

Line 143: -- ,pay_action_information asg_act

139: -- SELECT asg_act.action_information5 person_id
140: -- ,asg_act.action_information6 tax_municipality
141: -- ,TO_NUMBER(rep_cde.action_information3) amount
142: -- FROM pay_assignment_actions paa
143: -- ,pay_action_information asg_act
144: -- ,pay_action_information rep_cde
145: -- WHERE paa.payroll_action_id = p_payroll_action_id
146: -- AND asg_act.action_context_type = 'AAP'
147: -- AND asg_act.action_context_id = paa.assignment_action_id

Line 144: -- ,pay_action_information rep_cde

140: -- ,asg_act.action_information6 tax_municipality
141: -- ,TO_NUMBER(rep_cde.action_information3) amount
142: -- FROM pay_assignment_actions paa
143: -- ,pay_action_information asg_act
144: -- ,pay_action_information rep_cde
145: -- WHERE paa.payroll_action_id = p_payroll_action_id
146: -- AND asg_act.action_context_type = 'AAP'
147: -- AND asg_act.action_context_id = paa.assignment_action_id
148: -- AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 159: -- pay_action_information_api.create_action_information

155: -- AND rep_cde.action_information2 = p_reporting_code;
156: --
157: -- Needs to populate the archive as follows:-
158: --
159: -- pay_action_information_api.create_action_information
160: -- (p_action_context_type => 'PA'
161: -- ,p_action_context_id => p_payroll_action_id
162: -- ,p_action_information_id => l_act_inf_id
163: -- ,p_object_version_number => l_ovn

Line 374: FROM pay_action_information inf_dtl

370: ,p_legal_employer_id IN VARCHAR2
371: ,p_reporting_code IN VARCHAR2
372: ,p_info_id IN VARCHAR2) IS
373: SELECT inf_dtl.action_information5 prompt
374: FROM pay_action_information inf_dtl
375: WHERE inf_dtl.action_context_type = 'PA'
376: AND inf_dtl.action_context_id = p_payroll_action_id
377: AND inf_dtl.action_information_category = 'EMEA REPORT INFORMATION'
378: AND inf_dtl.action_information1 = 'REP_CODE_INFO_DTLS'

Line 414: FROM pay_action_information inf_dtl

410: ,p_legal_employer_id IN VARCHAR2
411: ,p_reporting_code IN VARCHAR
412: ,p_info_id IN VARCHAR2) IS
413: SELECT inf_dtl.action_information6 datatype
414: FROM pay_action_information inf_dtl
415: WHERE inf_dtl.action_context_type = 'PA'
416: AND inf_dtl.action_context_id = p_payroll_action_id
417: AND inf_dtl.action_information_category = 'EMEA REPORT INFORMATION'
418: AND inf_dtl.action_information1 = 'REP_CODE_INFO_DTLS'

Line 454: FROM pay_action_information inf_dtl

450: ,p_legal_employer_id IN VARCHAR2
451: ,p_reporting_code IN VARCHAR
452: ,p_info_id IN VARCHAR2) IS
453: SELECT inf_dtl.action_information8 xml_orid
454: FROM pay_action_information inf_dtl
455: WHERE inf_dtl.action_context_type = 'PA'
456: AND inf_dtl.action_context_id = p_payroll_action_id
457: AND inf_dtl.action_information_category = 'EMEA REPORT INFORMATION'
458: AND inf_dtl.action_information1 = 'REP_CODE_INFO_DTLS'

Line 492: FROM pay_action_information inf_dtl

488: (p_payroll_action_id IN NUMBER
489: ,p_legal_employer_id IN VARCHAR2
490: ,p_reporting_code IN VARCHAR) IS
491: SELECT inf_dtl.action_information11 description
492: FROM pay_action_information inf_dtl
493: WHERE inf_dtl.action_context_type = 'PA'
494: AND inf_dtl.action_context_id = p_payroll_action_id
495: AND inf_dtl.action_information_category = 'EMEA REPORT INFORMATION'
496: AND inf_dtl.action_information1 = 'REP_CODE_DTLS'

Line 1217: pay_action_information_api.create_action_information

1213: Fnd_file.put_line(FND_FILE.LOG,'Inside Archive');
1214:
1215: -- Archive: EMEA REPORT DETAILS -> PYNOEOYA
1216: --
1217: pay_action_information_api.create_action_information
1218: (p_action_context_type => 'PA'
1219: ,p_action_context_id => p_payroll_action_id
1220: ,p_action_information_id => l_act_inf_id
1221: ,p_object_version_number => l_ovn

Line 1264: pay_action_information_api.create_action_information

1260:
1261: --
1262: -- Archive: EMEA REPORT INFORMATION | LEG_EMP_INFO
1263: --
1264: pay_action_information_api.create_action_information
1265: (p_action_context_type => 'PA'
1266: ,p_action_context_id => p_payroll_action_id
1267: ,p_action_information_id => l_act_inf_id
1268: ,p_object_version_number => l_ovn

Line 1347: pay_action_information_api.create_action_information

1343: --
1344: --
1345: -- Archive: EMEA REPORT INFORMATION | LE_SI_LU_INFO
1346: --
1347: pay_action_information_api.create_action_information
1348: (p_action_context_type => 'PA'
1349: ,p_action_context_id => p_payroll_action_id
1350: ,p_action_information_id => l_act_inf_id
1351: ,p_object_version_number => l_ovn

Line 1427: pay_action_information_api.create_action_information

1423: --
1424: --
1425: -- Archive: EMEA REPORT INFORMATION | LE_SI_LU_TM_INFO
1426: --
1427: pay_action_information_api.create_action_information
1428: (p_action_context_type => 'PA'
1429: ,p_action_context_id => p_payroll_action_id
1430: ,p_action_information_id => l_act_inf_id
1431: ,p_object_version_number => l_ovn

Line 1478: pay_action_information_api.create_action_information

1474: --
1475: --
1476: -- Archive: EMEA REPORT INFORMATION | LE_SI_BALS
1477: --
1478: pay_action_information_api.create_action_information
1479: (p_action_context_type => 'PA'
1480: ,p_action_context_id => p_payroll_action_id
1481: ,p_action_information_id => l_act_inf_id
1482: ,p_object_version_number => l_ovn

Line 1533: pay_action_information_api.create_action_information

1529: END IF;
1530: --
1531: -- Archive: EMEA REPORT INFORMATION | REP_CODE_DTLS
1532: --
1533: pay_action_information_api.create_action_information
1534: (p_action_context_type => 'PA'
1535: ,p_action_context_id => p_payroll_action_id
1536: ,p_action_information_id => l_act_inf_id
1537: ,p_object_version_number => l_ovn

Line 1572: pay_action_information_api.create_action_information

1568: --
1569: --
1570: -- Archive: EMEA REPORT INFORMATION | REP_CODE_INFO_DTLS
1571: --
1572: pay_action_information_api.create_action_information
1573: (p_action_context_type => 'PA'
1574: ,p_action_context_id => p_payroll_action_id
1575: ,p_action_information_id => l_act_inf_id
1576: ,p_object_version_number => l_ovn

Line 1635: ,pay_action_information ai

1631: ,MAX(asg.effective_start_date) effective_start_date --Changes 2007/2008
1632: FROM per_all_assignments_f asg
1633: ,pay_assignment_actions paa
1634: ,pay_payroll_actions ppa
1635: ,pay_action_information ai
1636: ,pay_action_contexts ac1
1637: ,ff_contexts ctx1
1638: ,pay_action_contexts ac2
1639: ,ff_contexts ctx2

Line 1783: pay_action_information_api.create_action_information

1779: --End Changes 2007/2008
1780:
1781: -- Archive: EMEA REPORT INFORMATION | PER_INFO
1782: --
1783: pay_action_information_api.create_action_information
1784: (p_action_context_type => 'PA'
1785: ,p_action_context_id => p_payroll_action_id
1786: ,p_action_information_id => l_act_inf_id
1787: ,p_object_version_number => l_ovn

Line 1823: pay_action_information_api.create_action_information

1819: --
1820: --
1821: -- Archive: EMEA REPORT INFORMATION | ASG_ACT_INFO
1822: --
1823: pay_action_information_api.create_action_information
1824: (p_action_context_type => 'AAP'
1825: ,p_action_context_id => l_assact_id
1826: ,p_action_information_id => l_act_inf_id
1827: ,p_object_version_number => l_ovn

Line 1874: FROM pay_action_information asg_act

1870: ,asg_act.action_information3 local_unit_id
1871: ,asg_act.action_information4 ni_zone
1872: ,asg_act.action_information6 tax_municipality_id
1873: ,asg_act.action_information8 municipality_code
1874: FROM pay_action_information asg_act
1875: ,pay_assignment_actions paa
1876: WHERE asg_act.action_information_category = 'EMEA REPORT INFORMATION'
1877: AND asg_act.action_information1 = 'ASG_ACT_INFO'
1878: AND asg_act.action_context_type = 'AAP'

Line 1887: FROM pay_action_information cde_dtl

1883: (p_payroll_action_id IN NUMBER
1884: ,p_legal_employer_id IN VARCHAR2) IS
1885: SELECT cde_dtl.action_information3 reporting_code
1886: ,TO_NUMBER(cde_dtl.action_information8) defined_balance_id
1887: FROM pay_action_information cde_dtl
1888: WHERE cde_dtl.action_context_type = 'PA'
1889: AND cde_dtl.action_context_id = p_payroll_action_id
1890: AND cde_dtl.action_information_category = 'EMEA REPORT INFORMATION'
1891: AND cde_dtl.action_information1 = 'REP_CODE_DTLS'

Line 1901: FROM pay_action_information inf_dtl

1897: ,p_legal_employer_id IN VARCHAR2
1898: ,p_reporting_code IN VARCHAR2) IS
1899: SELECT inf_dtl.action_information4 info_id
1900: ,TO_NUMBER(inf_dtl.action_information7) defined_balance_id
1901: FROM pay_action_information inf_dtl
1902: WHERE inf_dtl.action_context_type = 'PA'
1903: AND inf_dtl.action_context_id = p_payroll_action_id
1904: AND inf_dtl.action_information_category = 'EMEA REPORT INFORMATION'
1905: AND inf_dtl.action_information1 = 'REP_CODE_INFO_DTLS'

Line 1925: FROM pay_action_information cde_dtl

1921: ,cde_info_dtl.action_information4 info_id
1922: ,rrv.result_value
1923: ,cde_info_dtl.action_information6 dtype
1924: -- ,pivf.uom dtype
1925: FROM pay_action_information cde_dtl
1926: ,pay_action_information cde_info_dtl
1927: ,pay_element_type_extra_info eei
1928: ,pay_assignment_actions paa
1929: ,pay_action_contexts ac1

Line 1926: ,pay_action_information cde_info_dtl

1922: ,rrv.result_value
1923: ,cde_info_dtl.action_information6 dtype
1924: -- ,pivf.uom dtype
1925: FROM pay_action_information cde_dtl
1926: ,pay_action_information cde_info_dtl
1927: ,pay_element_type_extra_info eei
1928: ,pay_assignment_actions paa
1929: ,pay_action_contexts ac1
1930: ,ff_contexts ctx1

Line 2001: FROM pay_action_information cde_dtl

1997: (p_payroll_action_id IN NUMBER
1998: ,p_legal_employer_id IN VARCHAR2) IS
1999: SELECT cde_dtl.action_information3 reporting_code
2000: ,cde_dtl.action_information8 procedure_name
2001: FROM pay_action_information cde_dtl
2002: WHERE cde_dtl.action_context_type = 'PA'
2003: AND cde_dtl.action_context_id = p_payroll_action_id
2004: AND cde_dtl.action_information_category = 'EMEA REPORT INFORMATION'
2005: AND cde_dtl.action_information1 = 'REP_CODE_DTLS'

Line 2279: pay_action_information_api.create_action_information

2275: --
2276: --
2277: -- Archive: EMEA REPORT INFORMATION | ASG_REP_CODE_INFO
2278: --
2279: pay_action_information_api.create_action_information
2280: (p_action_context_type => 'AAP'
2281: ,p_action_context_id => p_assignment_action_id
2282: ,p_action_information_id => l_act_inf_id
2283: ,p_object_version_number => l_ovn

Line 2331: pay_action_information_api.create_action_information

2327: --
2328: -- For the code 613, additional information order is Days
2329: -- Archive: EMEA REPORT INFORMATION | ASG_REP_CODE_INFO | Code 613
2330: --
2331: pay_action_information_api.create_action_information
2332: (p_action_context_type => 'AAP'
2333: ,p_action_context_id => p_assignment_action_id
2334: ,p_action_information_id => l_act_inf_id
2335: ,p_object_version_number => l_ovn

Line 2361: pay_action_information_api.create_action_information

2357: --
2358: --
2359: -- Archive: EMEA REPORT INFORMATION | ASG_REP_CODE_INFO | Code 613, 616
2360: --
2361: pay_action_information_api.create_action_information
2362: (p_action_context_type => 'AAP'
2363: ,p_action_context_id => p_assignment_action_id
2364: ,p_action_information_id => l_act_inf_id
2365: ,p_object_version_number => l_ovn

Line 2478: pay_action_information_api.create_action_information

2474: --
2475: FOR i IN 1 .. l_index_616
2476: LOOP
2477: --
2478: pay_action_information_api.create_action_information
2479: (p_action_context_type => 'AAP'
2480: ,p_action_context_id => p_assignment_action_id
2481: ,p_action_information_id => l_act_inf_id
2482: ,p_object_version_number => l_ovn

Line 2539: pay_action_information_api.create_action_information

2535: --
2536: --
2537: -- Archive: EMEA REPORT INFORMATION | ASG_REP_CODE_INFO
2538: --
2539: pay_action_information_api.create_action_information
2540: (p_action_context_type => 'AAP'
2541: ,p_action_context_id => p_assignment_action_id
2542: ,p_action_information_id => l_act_inf_id
2543: ,p_object_version_number => l_ovn

Line 2591: pay_action_information_api.create_action_information

2587: --
2588: --
2589: -- Archive: EMEA REPORT INFORMATION | ASG_REP_CODE_INFO
2590: --
2591: pay_action_information_api.create_action_information
2592: (p_action_context_type => 'AAP'
2593: ,p_action_context_id => p_assignment_action_id
2594: ,p_action_information_id => l_act_inf_id
2595: ,p_object_version_number => l_ovn

Line 2687: pay_action_information_api.create_action_information

2683: --
2684: --
2685: -- Archive: EMEA REPORT INFORMATION | ASG_REP_CODE_INFO
2686: --
2687: pay_action_information_api.create_action_information
2688: (p_action_context_type => 'AAP'
2689: ,p_action_context_id => p_assignment_action_id
2690: ,p_action_information_id => l_act_inf_id
2691: ,p_object_version_number => l_ovn

Line 2751: ,pay_action_information le_lu

2747: (p_payroll_action_id IN NUMBER) IS
2748: SELECT le_lu.action_information2 legal_employer_id
2749: ,asg_act.action_information5 person_id
2750: FROM pay_assignment_actions paa
2751: ,pay_action_information le_lu
2752: ,pay_action_information asg_act
2753: ,pay_action_information rep_cde
2754: ,pay_action_information cde_dtl
2755: WHERE paa.payroll_action_id = le_lu.action_context_id

Line 2752: ,pay_action_information asg_act

2748: SELECT le_lu.action_information2 legal_employer_id
2749: ,asg_act.action_information5 person_id
2750: FROM pay_assignment_actions paa
2751: ,pay_action_information le_lu
2752: ,pay_action_information asg_act
2753: ,pay_action_information rep_cde
2754: ,pay_action_information cde_dtl
2755: WHERE paa.payroll_action_id = le_lu.action_context_id
2756: AND asg_act.action_context_type = 'AAP'

Line 2753: ,pay_action_information rep_cde

2749: ,asg_act.action_information5 person_id
2750: FROM pay_assignment_actions paa
2751: ,pay_action_information le_lu
2752: ,pay_action_information asg_act
2753: ,pay_action_information rep_cde
2754: ,pay_action_information cde_dtl
2755: WHERE paa.payroll_action_id = le_lu.action_context_id
2756: AND asg_act.action_context_type = 'AAP'
2757: AND asg_act.action_context_id = paa.assignment_action_id

Line 2754: ,pay_action_information cde_dtl

2750: FROM pay_assignment_actions paa
2751: ,pay_action_information le_lu
2752: ,pay_action_information asg_act
2753: ,pay_action_information rep_cde
2754: ,pay_action_information cde_dtl
2755: WHERE paa.payroll_action_id = le_lu.action_context_id
2756: AND asg_act.action_context_type = 'AAP'
2757: AND asg_act.action_context_id = paa.assignment_action_id
2758: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 2788: FROM pay_action_information asg_act

2784: ,p_person_id IN VARCHAR2) IS
2785: SELECT asg_act.action_information_id
2786: ,asg_act.object_version_number
2787: ,paa.assignment_id
2788: FROM pay_action_information asg_act
2789: ,pay_assignment_actions paa
2790: WHERE asg_act.action_information_category = 'EMEA REPORT INFORMATION'
2791: AND asg_act.action_information1 = 'ASG_ACT_INFO'
2792: AND asg_act.action_information2 = p_legal_employer_id

Line 2819: ,pay_action_information asg_act

2815: ,rep_cde.action_information14 cinfo4
2816: ,rep_cde.action_information15 cinfo5
2817: ,rep_cde.action_information16 cinfo6
2818: FROM pay_assignment_actions paa
2819: ,pay_action_information asg_act
2820: ,pay_action_information rep_cde
2821: ,pay_action_information cde_dtl
2822: WHERE paa.payroll_action_id = p_payroll_action_id
2823: AND asg_act.action_context_type = 'AAP'

Line 2820: ,pay_action_information rep_cde

2816: ,rep_cde.action_information15 cinfo5
2817: ,rep_cde.action_information16 cinfo6
2818: FROM pay_assignment_actions paa
2819: ,pay_action_information asg_act
2820: ,pay_action_information rep_cde
2821: ,pay_action_information cde_dtl
2822: WHERE paa.payroll_action_id = p_payroll_action_id
2823: AND asg_act.action_context_type = 'AAP'
2824: AND asg_act.action_context_id = paa.assignment_action_id

Line 2821: ,pay_action_information cde_dtl

2817: ,rep_cde.action_information16 cinfo6
2818: FROM pay_assignment_actions paa
2819: ,pay_action_information asg_act
2820: ,pay_action_information rep_cde
2821: ,pay_action_information cde_dtl
2822: WHERE paa.payroll_action_id = p_payroll_action_id
2823: AND asg_act.action_context_type = 'AAP'
2824: AND asg_act.action_context_id = paa.assignment_action_id
2825: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 2860: ,pay_action_information asg_act

2856: ,rep_cde.action_information14 cinfo4
2857: ,rep_cde.action_information15 cinfo5
2858: ,rep_cde.action_information16 cinfo6
2859: FROM pay_assignment_actions paa
2860: ,pay_action_information asg_act
2861: ,pay_action_information rep_cde
2862: ,pay_action_information cde_dtl
2863: WHERE paa.payroll_action_id = p_payroll_action_id
2864: AND asg_act.action_context_type = 'AAP'

Line 2861: ,pay_action_information rep_cde

2857: ,rep_cde.action_information15 cinfo5
2858: ,rep_cde.action_information16 cinfo6
2859: FROM pay_assignment_actions paa
2860: ,pay_action_information asg_act
2861: ,pay_action_information rep_cde
2862: ,pay_action_information cde_dtl
2863: WHERE paa.payroll_action_id = p_payroll_action_id
2864: AND asg_act.action_context_type = 'AAP'
2865: AND asg_act.action_context_id = paa.assignment_action_id

Line 2862: ,pay_action_information cde_dtl

2858: ,rep_cde.action_information16 cinfo6
2859: FROM pay_assignment_actions paa
2860: ,pay_action_information asg_act
2861: ,pay_action_information rep_cde
2862: ,pay_action_information cde_dtl
2863: WHERE paa.payroll_action_id = p_payroll_action_id
2864: AND asg_act.action_context_type = 'AAP'
2865: AND asg_act.action_context_id = paa.assignment_action_id
2866: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 2896: FROM pay_action_information cde_dtl

2892: (p_payroll_action_id IN NUMBER) IS
2893: SELECT cde_dtl.action_information2 legal_employer_id
2894: ,cde_dtl.action_information3 reporting_code
2895: ,cde_dtl.action_information10 procedure_name
2896: FROM pay_action_information cde_dtl
2897: WHERE cde_dtl.action_context_id = p_payroll_action_id
2898: AND cde_dtl.action_context_type = 'PA'
2899: AND cde_dtl.action_information_category = 'EMEA REPORT INFORMATION'
2900: AND cde_dtl.action_information1 = 'REP_CODE_DTLS'

Line 2964: pay_action_information_api.update_action_information

2960: -- ASG_ACT_INFO archive records to identify that. This will put their reporting code details into the
2961: -- earnings below reporting limit category on the Employer Contribution Summary report.
2962: --
2963: IF l_amount = 0 THEN
2964: pay_action_information_api.update_action_information
2965: (p_action_information_id => l_asg_act_rec.action_information_id
2966: ,p_object_version_number => l_asg_act_rec.object_version_number
2967: ,p_action_information7 => 'Y');
2968: END IF;

Line 2982: pay_action_information_api.create_action_information

2978: --
2979: --
2980: -- Archive: EMEA REPORT INFORMATION | AUDIT_REP_SUMMARY
2981: --
2982: pay_action_information_api.create_action_information
2983: (p_action_context_type => 'PA'
2984: ,p_action_context_id => p_payroll_action_id
2985: ,p_action_information_id => l_act_inf_id
2986: ,p_object_version_number => l_ovn

Line 3014: pay_action_information_api.create_action_information

3010: --
3011: --
3012: -- Archive: EMEA REPORT INFORMATION | AUDIT_REP_SUMMARY
3013: --
3014: pay_action_information_api.create_action_information
3015: (p_action_context_type => 'PA'
3016: ,p_action_context_id => p_payroll_action_id
3017: ,p_action_information_id => l_act_inf_id
3018: ,p_object_version_number => l_ovn

Line 3080: FROM pay_action_information leg_emp

3076: SELECT leg_emp.action_information2 legal_employer_id
3077: ,leg_emp.action_information3 legal_employer_name
3078: ,leg_emp.action_information4 organization_number
3079: ,leg_emp.effective_date effective_date
3080: FROM pay_action_information leg_emp
3081: WHERE leg_emp.action_context_type = 'PA'
3082: AND leg_emp.action_context_id = l_payroll_action_id
3083: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'
3084: AND leg_emp.action_information1 = 'LEG_EMP_INFO'

Line 3100: FROM pay_action_information summ_cde

3096: ,per.action_information5 national_identifier
3097: ,per.action_information6 employed_throughout
3098: ,per.action_information7 seamen
3099: ,per.action_information8 employment_date_days
3100: FROM pay_action_information summ_cde
3101: ,pay_action_information per
3102: WHERE summ_cde.action_context_type = 'PA'
3103: AND summ_cde.action_context_id = l_payroll_action_id
3104: AND summ_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 3101: ,pay_action_information per

3097: ,per.action_information6 employed_throughout
3098: ,per.action_information7 seamen
3099: ,per.action_information8 employment_date_days
3100: FROM pay_action_information summ_cde
3101: ,pay_action_information per
3102: WHERE summ_cde.action_context_type = 'PA'
3103: AND summ_cde.action_context_id = l_payroll_action_id
3104: AND summ_cde.action_information_category = 'EMEA REPORT INFORMATION'
3105: AND summ_cde.action_information1 = 'AUDIT_REP_SUMMARY'

Line 3142: FROM pay_action_information summ_cde

3138: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO3') info3_dtype
3139: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO4') info4_dtype
3140: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO5') info5_dtype
3141: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO6') info6_dtype
3142: FROM pay_action_information summ_cde
3143: WHERE summ_cde.action_context_type = 'PA'
3144: AND summ_cde.action_context_id = l_payroll_action_id
3145: AND summ_cde.action_information_category = 'EMEA REPORT INFORMATION'
3146: AND summ_cde.action_information1 = 'AUDIT_REP_SUMMARY'

Line 3508: FROM pay_action_information le_lu_tm

3504: ,le_lu_tm.action_information8 ni_zone_arc
3505: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
3506: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
3507: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
3508: FROM pay_action_information le_lu_tm
3509: WHERE le_lu_tm.action_context_type = 'PA'
3510: AND le_lu_tm.action_context_id = l_payroll_action_id
3511: AND le_lu_tm.action_information_category = 'EMEA REPORT INFORMATION'
3512: AND le_lu_tm.action_information1 = 'LE_SI_LU_TM_INFO';

Line 3536: FROM pay_action_information le_lu

3532: ,leg_emp.action_information15 to_postoffice
3533: ,leg_emp.action_information16 le_tax_muncipality --2007/2008 Changes
3534: ,leg_emp.action_information17 le_economic_aid -- 2007/2008 Changes
3535: ,leg_emp.effective_date effective_date
3536: FROM pay_action_information le_lu
3537: ,pay_action_information leg_emp
3538: WHERE le_lu.action_context_type = 'PA'
3539: AND le_lu.action_context_id = l_payroll_action_id
3540: AND le_lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 3537: ,pay_action_information leg_emp

3533: ,leg_emp.action_information16 le_tax_muncipality --2007/2008 Changes
3534: ,leg_emp.action_information17 le_economic_aid -- 2007/2008 Changes
3535: ,leg_emp.effective_date effective_date
3536: FROM pay_action_information le_lu
3537: ,pay_action_information leg_emp
3538: WHERE le_lu.action_context_type = 'PA'
3539: AND le_lu.action_context_id = l_payroll_action_id
3540: AND le_lu.action_information_category = 'EMEA REPORT INFORMATION'
3541: AND le_lu.action_information1 = 'LE_SI_LU_INFO'

Line 3573: FROM pay_action_information le_si_bals

3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
3571: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
3572: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
3573: FROM pay_action_information le_si_bals
3574: WHERE le_si_bals.action_context_type = 'PA'
3575: AND le_si_bals.action_context_id = l_payroll_action_id
3576: AND le_si_bals.action_information_category = 'EMEA REPORT INFORMATION'
3577: AND le_si_bals.action_information1 = 'LE_SI_BALS'

Line 3635: ,pay_action_information le_lu

3631: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3632: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
3633: ,0)) sum_totals
3634: FROM pay_assignment_actions paa
3635: ,pay_action_information le_lu
3636: ,pay_action_information asg_act
3637: ,pay_action_information rep_cde
3638: ,pay_action_information cde_dtl
3639: WHERE paa.payroll_action_id = le_lu.action_context_id

Line 3636: ,pay_action_information asg_act

3632: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
3633: ,0)) sum_totals
3634: FROM pay_assignment_actions paa
3635: ,pay_action_information le_lu
3636: ,pay_action_information asg_act
3637: ,pay_action_information rep_cde
3638: ,pay_action_information cde_dtl
3639: WHERE paa.payroll_action_id = le_lu.action_context_id
3640: AND asg_act.action_context_type = 'AAP'

Line 3637: ,pay_action_information rep_cde

3633: ,0)) sum_totals
3634: FROM pay_assignment_actions paa
3635: ,pay_action_information le_lu
3636: ,pay_action_information asg_act
3637: ,pay_action_information rep_cde
3638: ,pay_action_information cde_dtl
3639: WHERE paa.payroll_action_id = le_lu.action_context_id
3640: AND asg_act.action_context_type = 'AAP'
3641: AND asg_act.action_context_id = paa.assignment_action_id

Line 3638: ,pay_action_information cde_dtl

3634: FROM pay_assignment_actions paa
3635: ,pay_action_information le_lu
3636: ,pay_action_information asg_act
3637: ,pay_action_information rep_cde
3638: ,pay_action_information cde_dtl
3639: WHERE paa.payroll_action_id = le_lu.action_context_id
3640: AND asg_act.action_context_type = 'AAP'
3641: AND asg_act.action_context_id = paa.assignment_action_id
3642: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 3678: ,pay_action_information le_lu

3674: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
3675: , 0)) bl_earnings
3676: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
3677: FROM pay_assignment_actions paa
3678: ,pay_action_information le_lu
3679: ,pay_action_information asg_act
3680: ,pay_action_information rep_cde
3681: ,pay_action_information cde_dtl
3682: WHERE paa.payroll_action_id = le_lu.action_context_id

Line 3679: ,pay_action_information asg_act

3675: , 0)) bl_earnings
3676: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
3677: FROM pay_assignment_actions paa
3678: ,pay_action_information le_lu
3679: ,pay_action_information asg_act
3680: ,pay_action_information rep_cde
3681: ,pay_action_information cde_dtl
3682: WHERE paa.payroll_action_id = le_lu.action_context_id
3683: AND asg_act.action_context_type = 'AAP'

Line 3680: ,pay_action_information rep_cde

3676: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
3677: FROM pay_assignment_actions paa
3678: ,pay_action_information le_lu
3679: ,pay_action_information asg_act
3680: ,pay_action_information rep_cde
3681: ,pay_action_information cde_dtl
3682: WHERE paa.payroll_action_id = le_lu.action_context_id
3683: AND asg_act.action_context_type = 'AAP'
3684: AND asg_act.action_context_id = paa.assignment_action_id

Line 3681: ,pay_action_information cde_dtl

3677: FROM pay_assignment_actions paa
3678: ,pay_action_information le_lu
3679: ,pay_action_information asg_act
3680: ,pay_action_information rep_cde
3681: ,pay_action_information cde_dtl
3682: WHERE paa.payroll_action_id = le_lu.action_context_id
3683: AND asg_act.action_context_type = 'AAP'
3684: AND asg_act.action_context_id = paa.assignment_action_id
3685: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 3719: ,pay_action_information le_lu

3715: ,le_lu.action_information3 si_status
3716: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
3717: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3718: FROM pay_assignment_actions paa
3719: ,pay_action_information le_lu
3720: ,pay_action_information asg_act
3721: ,pay_action_information rep_cde
3722: ,pay_action_information cde_dtl
3723: WHERE paa.payroll_action_id = le_lu.action_context_id

Line 3720: ,pay_action_information asg_act

3716: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
3717: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3718: FROM pay_assignment_actions paa
3719: ,pay_action_information le_lu
3720: ,pay_action_information asg_act
3721: ,pay_action_information rep_cde
3722: ,pay_action_information cde_dtl
3723: WHERE paa.payroll_action_id = le_lu.action_context_id
3724: AND asg_act.action_context_type = 'AAP'

Line 3721: ,pay_action_information rep_cde

3717: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3718: FROM pay_assignment_actions paa
3719: ,pay_action_information le_lu
3720: ,pay_action_information asg_act
3721: ,pay_action_information rep_cde
3722: ,pay_action_information cde_dtl
3723: WHERE paa.payroll_action_id = le_lu.action_context_id
3724: AND asg_act.action_context_type = 'AAP'
3725: AND asg_act.action_context_id = paa.assignment_action_id

Line 3722: ,pay_action_information cde_dtl

3718: FROM pay_assignment_actions paa
3719: ,pay_action_information le_lu
3720: ,pay_action_information asg_act
3721: ,pay_action_information rep_cde
3722: ,pay_action_information cde_dtl
3723: WHERE paa.payroll_action_id = le_lu.action_context_id
3724: AND asg_act.action_context_type = 'AAP'
3725: AND asg_act.action_context_id = paa.assignment_action_id
3726: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 4339: FROM pay_action_information le_lu_tm

4335: ,le_lu_tm.action_information8 ni_zone_arc
4336: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
4337: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
4338: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
4339: FROM pay_action_information le_lu_tm
4340: WHERE le_lu_tm.action_context_type = 'PA'
4341: AND le_lu_tm.action_context_id = l_payroll_action_id
4342: AND le_lu_tm.action_information_category = 'EMEA REPORT INFORMATION'
4343: AND le_lu_tm.action_information1 = 'LE_SI_LU_TM_INFO';

Line 4367: FROM pay_action_information le_lu

4363: ,leg_emp.action_information15 to_postoffice
4364: ,leg_emp.action_information16 le_tax_muncipality -- 2007/2008 Changes
4365: ,leg_emp.action_information17 le_economic_aid -- 2007/2008 Changes
4366: ,leg_emp.effective_date effective_date
4367: FROM pay_action_information le_lu
4368: ,pay_action_information leg_emp
4369: WHERE le_lu.action_context_type = 'PA'
4370: AND le_lu.action_context_id = l_payroll_action_id
4371: AND le_lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 4368: ,pay_action_information leg_emp

4364: ,leg_emp.action_information16 le_tax_muncipality -- 2007/2008 Changes
4365: ,leg_emp.action_information17 le_economic_aid -- 2007/2008 Changes
4366: ,leg_emp.effective_date effective_date
4367: FROM pay_action_information le_lu
4368: ,pay_action_information leg_emp
4369: WHERE le_lu.action_context_type = 'PA'
4370: AND le_lu.action_context_id = l_payroll_action_id
4371: AND le_lu.action_information_category = 'EMEA REPORT INFORMATION'
4372: AND le_lu.action_information1 = 'LE_SI_LU_INFO'

Line 4404: FROM pay_action_information le_si_bals

4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4402: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4403: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4404: FROM pay_action_information le_si_bals
4405: WHERE le_si_bals.action_context_type = 'PA'
4406: AND le_si_bals.action_context_id = l_payroll_action_id
4407: AND le_si_bals.action_information_category = 'EMEA REPORT INFORMATION'
4408: AND le_si_bals.action_information1 = 'LE_SI_BALS'

Line 4466: ,pay_action_information le_lu

4462: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4463: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
4464: ,0)) sum_totals
4465: FROM pay_assignment_actions paa
4466: ,pay_action_information le_lu
4467: ,pay_action_information asg_act
4468: ,pay_action_information rep_cde
4469: ,pay_action_information cde_dtl
4470: WHERE paa.payroll_action_id = le_lu.action_context_id

Line 4467: ,pay_action_information asg_act

4463: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
4464: ,0)) sum_totals
4465: FROM pay_assignment_actions paa
4466: ,pay_action_information le_lu
4467: ,pay_action_information asg_act
4468: ,pay_action_information rep_cde
4469: ,pay_action_information cde_dtl
4470: WHERE paa.payroll_action_id = le_lu.action_context_id
4471: AND asg_act.action_context_type = 'AAP'

Line 4468: ,pay_action_information rep_cde

4464: ,0)) sum_totals
4465: FROM pay_assignment_actions paa
4466: ,pay_action_information le_lu
4467: ,pay_action_information asg_act
4468: ,pay_action_information rep_cde
4469: ,pay_action_information cde_dtl
4470: WHERE paa.payroll_action_id = le_lu.action_context_id
4471: AND asg_act.action_context_type = 'AAP'
4472: AND asg_act.action_context_id = paa.assignment_action_id

Line 4469: ,pay_action_information cde_dtl

4465: FROM pay_assignment_actions paa
4466: ,pay_action_information le_lu
4467: ,pay_action_information asg_act
4468: ,pay_action_information rep_cde
4469: ,pay_action_information cde_dtl
4470: WHERE paa.payroll_action_id = le_lu.action_context_id
4471: AND asg_act.action_context_type = 'AAP'
4472: AND asg_act.action_context_id = paa.assignment_action_id
4473: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 4509: ,pay_action_information le_lu

4505: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4506: , 0)) bl_earnings
4507: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4508: FROM pay_assignment_actions paa
4509: ,pay_action_information le_lu
4510: ,pay_action_information asg_act
4511: ,pay_action_information rep_cde
4512: ,pay_action_information cde_dtl
4513: WHERE paa.payroll_action_id = le_lu.action_context_id

Line 4510: ,pay_action_information asg_act

4506: , 0)) bl_earnings
4507: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4508: FROM pay_assignment_actions paa
4509: ,pay_action_information le_lu
4510: ,pay_action_information asg_act
4511: ,pay_action_information rep_cde
4512: ,pay_action_information cde_dtl
4513: WHERE paa.payroll_action_id = le_lu.action_context_id
4514: AND asg_act.action_context_type = 'AAP'

Line 4511: ,pay_action_information rep_cde

4507: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4508: FROM pay_assignment_actions paa
4509: ,pay_action_information le_lu
4510: ,pay_action_information asg_act
4511: ,pay_action_information rep_cde
4512: ,pay_action_information cde_dtl
4513: WHERE paa.payroll_action_id = le_lu.action_context_id
4514: AND asg_act.action_context_type = 'AAP'
4515: AND asg_act.action_context_id = paa.assignment_action_id

Line 4512: ,pay_action_information cde_dtl

4508: FROM pay_assignment_actions paa
4509: ,pay_action_information le_lu
4510: ,pay_action_information asg_act
4511: ,pay_action_information rep_cde
4512: ,pay_action_information cde_dtl
4513: WHERE paa.payroll_action_id = le_lu.action_context_id
4514: AND asg_act.action_context_type = 'AAP'
4515: AND asg_act.action_context_id = paa.assignment_action_id
4516: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 4550: ,pay_action_information le_lu

4546: ,le_lu.action_information3 si_status
4547: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
4548: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
4549: FROM pay_assignment_actions paa
4550: ,pay_action_information le_lu
4551: ,pay_action_information asg_act
4552: ,pay_action_information rep_cde
4553: ,pay_action_information cde_dtl
4554: WHERE paa.payroll_action_id = le_lu.action_context_id

Line 4551: ,pay_action_information asg_act

4547: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
4548: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
4549: FROM pay_assignment_actions paa
4550: ,pay_action_information le_lu
4551: ,pay_action_information asg_act
4552: ,pay_action_information rep_cde
4553: ,pay_action_information cde_dtl
4554: WHERE paa.payroll_action_id = le_lu.action_context_id
4555: AND asg_act.action_context_type = 'AAP'

Line 4552: ,pay_action_information rep_cde

4548: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
4549: FROM pay_assignment_actions paa
4550: ,pay_action_information le_lu
4551: ,pay_action_information asg_act
4552: ,pay_action_information rep_cde
4553: ,pay_action_information cde_dtl
4554: WHERE paa.payroll_action_id = le_lu.action_context_id
4555: AND asg_act.action_context_type = 'AAP'
4556: AND asg_act.action_context_id = paa.assignment_action_id

Line 4553: ,pay_action_information cde_dtl

4549: FROM pay_assignment_actions paa
4550: ,pay_action_information le_lu
4551: ,pay_action_information asg_act
4552: ,pay_action_information rep_cde
4553: ,pay_action_information cde_dtl
4554: WHERE paa.payroll_action_id = le_lu.action_context_id
4555: AND asg_act.action_context_type = 'AAP'
4556: AND asg_act.action_context_id = paa.assignment_action_id
4557: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 5053: FROM pay_action_information leg_emp

5049: ,leg_emp.action_information8 add_post_code
5050: ,leg_emp.action_information9 add_post_office
5051: ,leg_emp.action_information16 le_tax_municipality
5052: ,leg_emp.effective_date effective_date
5053: FROM pay_action_information leg_emp
5054: WHERE leg_emp.action_context_type = 'PA'
5055: AND leg_emp.action_context_id = l_payroll_action_id
5056: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'
5057: AND leg_emp.action_information1 = 'LEG_EMP_INFO'

Line 5077: FROM pay_action_information summ_cde

5073: ,per.action_information10 add_line_2
5074: ,per.action_information11 add_line_3
5075: ,per.action_information12 add_post_code
5076: ,per.action_information13 add_post_office
5077: FROM pay_action_information summ_cde
5078: ,pay_action_information per
5079: WHERE summ_cde.action_context_type = 'PA'
5080: AND summ_cde.action_context_id = l_payroll_action_id
5081: AND summ_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5078: ,pay_action_information per

5074: ,per.action_information11 add_line_3
5075: ,per.action_information12 add_post_code
5076: ,per.action_information13 add_post_office
5077: FROM pay_action_information summ_cde
5078: ,pay_action_information per
5079: WHERE summ_cde.action_context_type = 'PA'
5080: AND summ_cde.action_context_id = l_payroll_action_id
5081: AND summ_cde.action_information_category = 'EMEA REPORT INFORMATION'
5082: AND summ_cde.action_information1 = 'AUDIT_REP_SUMMARY'

Line 5098: FROM pay_action_information rep_cde

5094: ,l_person_id IN NUMBER) IS
5095: SELECT rep_cde.action_information3 code
5096: ,SUM(fnd_number.canonical_to_number(aud_smr.action_information5)) amount
5097: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, p_legal_employer_id, rep_cde.action_information3, 'INFO1') info1_dtype
5098: FROM pay_action_information rep_cde
5099: ,pay_action_information aud_smr
5100: WHERE rep_cde.action_context_type = 'PA'
5101: AND rep_cde.action_context_id = l_payroll_action_id
5102: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5099: ,pay_action_information aud_smr

5095: SELECT rep_cde.action_information3 code
5096: ,SUM(fnd_number.canonical_to_number(aud_smr.action_information5)) amount
5097: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, p_legal_employer_id, rep_cde.action_information3, 'INFO1') info1_dtype
5098: FROM pay_action_information rep_cde
5099: ,pay_action_information aud_smr
5100: WHERE rep_cde.action_context_type = 'PA'
5101: AND rep_cde.action_context_id = l_payroll_action_id
5102: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5103: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5121: FROM pay_action_information rep_cde

5117: ,p_legal_employer_id IN VARCHAR2
5118: ,l_person_id IN NUMBER
5119: ,l_eoy_code IN VARCHAR2) IS
5120: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1
5121: FROM pay_action_information rep_cde
5122: ,pay_action_information aud_smr
5123: WHERE rep_cde.action_context_type = 'PA'
5124: AND rep_cde.action_context_id = l_payroll_action_id
5125: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5122: ,pay_action_information aud_smr

5118: ,l_person_id IN NUMBER
5119: ,l_eoy_code IN VARCHAR2) IS
5120: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1
5121: FROM pay_action_information rep_cde
5122: ,pay_action_information aud_smr
5123: WHERE rep_cde.action_context_type = 'PA'
5124: AND rep_cde.action_context_id = l_payroll_action_id
5125: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5126: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5144: FROM pay_action_information rep_cde

5140: ,p_legal_employer_id IN VARCHAR2
5141: ,l_person_id IN NUMBER
5142: ,l_eoy_code IN VARCHAR2) IS
5143: SELECT decode(count(distinct(aud_smr.action_information6)),1,max(aud_smr.action_information6),'') info1
5144: FROM pay_action_information rep_cde
5145: ,pay_action_information aud_smr
5146: WHERE rep_cde.action_context_type = 'PA'
5147: AND rep_cde.action_context_id = l_payroll_action_id
5148: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5145: ,pay_action_information aud_smr

5141: ,l_person_id IN NUMBER
5142: ,l_eoy_code IN VARCHAR2) IS
5143: SELECT decode(count(distinct(aud_smr.action_information6)),1,max(aud_smr.action_information6),'') info1
5144: FROM pay_action_information rep_cde
5145: ,pay_action_information aud_smr
5146: WHERE rep_cde.action_context_type = 'PA'
5147: AND rep_cde.action_context_id = l_payroll_action_id
5148: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5149: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5192: FROM pay_action_information summ_cde

5188: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO3') info3_orid -- changes 2007-08
5189: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO4') info4_orid -- changes 2007-08
5190: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO5') info5_orid -- changes 2007-08
5191: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO6') info6_orid -- changes 2007-08
5192: FROM pay_action_information summ_cde
5193: ,pay_action_information rep_cde
5194: WHERE rep_cde.action_context_type = 'PA'
5195: AND rep_cde.action_context_id = l_payroll_action_id
5196: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5193: ,pay_action_information rep_cde

5189: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO4') info4_orid -- changes 2007-08
5190: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO5') info5_orid -- changes 2007-08
5191: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO6') info6_orid -- changes 2007-08
5192: FROM pay_action_information summ_cde
5193: ,pay_action_information rep_cde
5194: WHERE rep_cde.action_context_type = 'PA'
5195: AND rep_cde.action_context_id = l_payroll_action_id
5196: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5197: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5214: FROM pay_action_information rep_cde

5210: CURSOR csr_FIX_CODE_DESC
5211: (l_payroll_action_id IN NUMBER) IS
5212: SELECT DISTINCT rep_cde.action_information3 code
5213: ,rep_cde.action_information11 description
5214: FROM pay_action_information rep_cde
5215: WHERE rep_cde.action_context_type = 'PA'
5216: AND rep_cde.action_context_id = l_payroll_action_id
5217: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5218: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5708: FROM pay_action_information leg_emp

5704: ,leg_emp.action_information8 add_post_code
5705: ,leg_emp.action_information9 add_post_office
5706: ,leg_emp.action_information16 le_tax_municipality
5707: ,leg_emp.effective_date effective_date
5708: FROM pay_action_information leg_emp
5709: WHERE leg_emp.action_context_type = 'PA'
5710: AND leg_emp.action_context_id = l_payroll_action_id
5711: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'
5712: AND leg_emp.action_information1 = 'LEG_EMP_INFO'

Line 5734: FROM pay_action_information summ_cde

5730: ,per.action_information12 add_post_code
5731: ,per.action_information13 add_post_office
5732: ,per.action_information14 employment_start_date --Changes 2007/2008
5733: ,per.action_information15 employment_end_date --Changes 2007/2008
5734: FROM pay_action_information summ_cde
5735: ,pay_action_information per
5736: WHERE summ_cde.action_context_type = 'PA'
5737: AND summ_cde.action_context_id = l_payroll_action_id
5738: AND summ_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5735: ,pay_action_information per

5731: ,per.action_information13 add_post_office
5732: ,per.action_information14 employment_start_date --Changes 2007/2008
5733: ,per.action_information15 employment_end_date --Changes 2007/2008
5734: FROM pay_action_information summ_cde
5735: ,pay_action_information per
5736: WHERE summ_cde.action_context_type = 'PA'
5737: AND summ_cde.action_context_id = l_payroll_action_id
5738: AND summ_cde.action_information_category = 'EMEA REPORT INFORMATION'
5739: AND summ_cde.action_information1 = 'AUDIT_REP_SUMMARY'

Line 5755: FROM pay_action_information rep_cde

5751: ,l_person_id IN NUMBER) IS
5752: SELECT rep_cde.action_information3 code
5753: ,SUM(fnd_number.canonical_to_number(aud_smr.action_information5)) amount
5754: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, p_legal_employer_id, rep_cde.action_information3, 'INFO1') info1_dtype
5755: FROM pay_action_information rep_cde
5756: ,pay_action_information aud_smr
5757: WHERE rep_cde.action_context_type = 'PA'
5758: AND rep_cde.action_context_id = l_payroll_action_id
5759: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5756: ,pay_action_information aud_smr

5752: SELECT rep_cde.action_information3 code
5753: ,SUM(fnd_number.canonical_to_number(aud_smr.action_information5)) amount
5754: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, p_legal_employer_id, rep_cde.action_information3, 'INFO1') info1_dtype
5755: FROM pay_action_information rep_cde
5756: ,pay_action_information aud_smr
5757: WHERE rep_cde.action_context_type = 'PA'
5758: AND rep_cde.action_context_id = l_payroll_action_id
5759: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5760: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5778: FROM pay_action_information rep_cde

5774: ,p_legal_employer_id IN VARCHAR2
5775: ,l_person_id IN NUMBER
5776: ,l_eoy_code IN VARCHAR2) IS
5777: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1
5778: FROM pay_action_information rep_cde
5779: ,pay_action_information aud_smr
5780: WHERE rep_cde.action_context_type = 'PA'
5781: AND rep_cde.action_context_id = l_payroll_action_id
5782: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5779: ,pay_action_information aud_smr

5775: ,l_person_id IN NUMBER
5776: ,l_eoy_code IN VARCHAR2) IS
5777: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1
5778: FROM pay_action_information rep_cde
5779: ,pay_action_information aud_smr
5780: WHERE rep_cde.action_context_type = 'PA'
5781: AND rep_cde.action_context_id = l_payroll_action_id
5782: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5783: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5801: FROM pay_action_information rep_cde

5797: ,p_legal_employer_id IN VARCHAR2
5798: ,l_person_id IN NUMBER
5799: ,l_eoy_code IN VARCHAR2) IS
5800: SELECT decode(count(distinct(aud_smr.action_information6)),1,max(aud_smr.action_information6),'') info1
5801: FROM pay_action_information rep_cde
5802: ,pay_action_information aud_smr
5803: WHERE rep_cde.action_context_type = 'PA'
5804: AND rep_cde.action_context_id = l_payroll_action_id
5805: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5802: ,pay_action_information aud_smr

5798: ,l_person_id IN NUMBER
5799: ,l_eoy_code IN VARCHAR2) IS
5800: SELECT decode(count(distinct(aud_smr.action_information6)),1,max(aud_smr.action_information6),'') info1
5801: FROM pay_action_information rep_cde
5802: ,pay_action_information aud_smr
5803: WHERE rep_cde.action_context_type = 'PA'
5804: AND rep_cde.action_context_id = l_payroll_action_id
5805: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5806: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5849: FROM pay_action_information summ_cde

5845: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO3') info3_orid -- changes 2007-08
5846: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO4') info4_orid -- changes 2007-08
5847: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO5') info5_orid -- changes 2007-08
5848: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO6') info6_orid -- changes 2007-08
5849: FROM pay_action_information summ_cde
5850: ,pay_action_information rep_cde
5851: WHERE rep_cde.action_context_type = 'PA'
5852: AND rep_cde.action_context_id = l_payroll_action_id
5853: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'

Line 5850: ,pay_action_information rep_cde

5846: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO4') info4_orid -- changes 2007-08
5847: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO5') info5_orid -- changes 2007-08
5848: ,pay_no_eoy_archive.get_xml_orid(l_payroll_action_id, summ_cde.action_information2, summ_cde.action_information4, 'INFO6') info6_orid -- changes 2007-08
5849: FROM pay_action_information summ_cde
5850: ,pay_action_information rep_cde
5851: WHERE rep_cde.action_context_type = 'PA'
5852: AND rep_cde.action_context_id = l_payroll_action_id
5853: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5854: AND rep_cde.action_information1 = 'REP_CODE_DTLS'

Line 5871: FROM pay_action_information rep_cde

5867: CURSOR csr_FIX_CODE_DESC
5868: (l_payroll_action_id IN NUMBER) IS
5869: SELECT DISTINCT rep_cde.action_information3 code
5870: ,rep_cde.action_information11 description
5871: FROM pay_action_information rep_cde
5872: WHERE rep_cde.action_context_type = 'PA'
5873: AND rep_cde.action_context_id = l_payroll_action_id
5874: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
5875: AND rep_cde.action_information1 = 'REP_CODE_DTLS'