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_AU_RECONCILIATION_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 11: g_business_group_id hr_all_organization_units.organization_id%type;

7: /* Bug 4036052
8: Initalize variables for Archive model -- Start */
9:
10: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
11: g_business_group_id hr_all_organization_units.organization_id%type;
12: g_prev_assignment_id number;
13: g_def_bal_populted varchar2(1);
14:
15: g_end_date date;

Line 630: ,c_business_group_id hr_all_organization_units.organization_id%type

626: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
627: ,c_start_person per_all_people_f.person_id%type
628: ,c_end_person per_all_people_f.person_id%type
629: ,c_employee_type per_all_people_f.current_employee_flag%type
630: ,c_business_group_id hr_all_organization_units.organization_id%type
631: ,c_organization_id hr_all_organization_units.organization_id%type
632: ,c_archive_start_date date
633: ,c_archive_end_date date
634: ) is

Line 631: ,c_organization_id hr_all_organization_units.organization_id%type

627: ,c_start_person per_all_people_f.person_id%type
628: ,c_end_person per_all_people_f.person_id%type
629: ,c_employee_type per_all_people_f.current_employee_flag%type
630: ,c_business_group_id hr_all_organization_units.organization_id%type
631: ,c_organization_id hr_all_organization_units.organization_id%type
632: ,c_archive_start_date date
633: ,c_archive_end_date date
634: ) is
635: select paa.assignment_action_id,

Line 682: ,c_business_group_id hr_all_organization_units.organization_id%type

678: cursor rg_csr_assignment_org_period
679: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
680: ,c_chunk NUMBER
681: ,c_employee_type per_all_people_f.current_employee_flag%type
682: ,c_business_group_id hr_all_organization_units.organization_id%type
683: ,c_organization_id hr_all_organization_units.organization_id%type
684: ,c_archive_start_date date
685: ,c_archive_end_date date
686: ) is

Line 683: ,c_organization_id hr_all_organization_units.organization_id%type

679: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
680: ,c_chunk NUMBER
681: ,c_employee_type per_all_people_f.current_employee_flag%type
682: ,c_business_group_id hr_all_organization_units.organization_id%type
683: ,c_organization_id hr_all_organization_units.organization_id%type
684: ,c_archive_start_date date
685: ,c_archive_end_date date
686: ) is
687: select paa.assignment_action_id,

Line 737: ,c_business_group_id hr_all_organization_units.organization_id%type

733: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
734: ,c_start_person per_all_people_f.person_id%type
735: ,c_end_person per_all_people_f.person_id%type
736: ,c_employee_type per_all_people_f.current_employee_flag%type
737: ,c_business_group_id hr_all_organization_units.organization_id%type
738: ,c_organization_id hr_all_organization_units.organization_id%type
739: ,c_period_end_date date
740: ,c_pact_id pay_payroll_actions.payroll_action_id%type
741: ) is

Line 738: ,c_organization_id hr_all_organization_units.organization_id%type

734: ,c_start_person per_all_people_f.person_id%type
735: ,c_end_person per_all_people_f.person_id%type
736: ,c_employee_type per_all_people_f.current_employee_flag%type
737: ,c_business_group_id hr_all_organization_units.organization_id%type
738: ,c_organization_id hr_all_organization_units.organization_id%type
739: ,c_period_end_date date
740: ,c_pact_id pay_payroll_actions.payroll_action_id%type
741: ) is
742: select paa.assignment_action_id,

Line 785: ,c_business_group_id hr_all_organization_units.organization_id%type

781: cursor rg_csr_assignment_org_run
782: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
783: ,c_chunk NUMBER
784: ,c_employee_type per_all_people_f.current_employee_flag%type
785: ,c_business_group_id hr_all_organization_units.organization_id%type
786: ,c_organization_id hr_all_organization_units.organization_id%type
787: ,c_period_end_date date
788: ,c_pact_id pay_payroll_actions.payroll_action_id%type
789: ) is

Line 786: ,c_organization_id hr_all_organization_units.organization_id%type

782: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
783: ,c_chunk NUMBER
784: ,c_employee_type per_all_people_f.current_employee_flag%type
785: ,c_business_group_id hr_all_organization_units.organization_id%type
786: ,c_organization_id hr_all_organization_units.organization_id%type
787: ,c_period_end_date date
788: ,c_pact_id pay_payroll_actions.payroll_action_id%type
789: ) is
790: select paa.assignment_action_id,

Line 839: ,c_business_group_id hr_all_organization_units.organization_id%type

835: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
836: ,c_start_person per_all_people_f.person_id%type
837: ,c_end_person per_all_people_f.person_id%type
838: ,c_employee_type per_all_people_f.current_employee_flag%type
839: ,c_business_group_id hr_all_organization_units.organization_id%type
840: ,c_legal_employer hr_all_organization_units.organization_id%type
841: ,c_archive_start_date date
842: ,c_archive_end_date date
843: ) is

Line 840: ,c_legal_employer hr_all_organization_units.organization_id%type

836: ,c_start_person per_all_people_f.person_id%type
837: ,c_end_person per_all_people_f.person_id%type
838: ,c_employee_type per_all_people_f.current_employee_flag%type
839: ,c_business_group_id hr_all_organization_units.organization_id%type
840: ,c_legal_employer hr_all_organization_units.organization_id%type
841: ,c_archive_start_date date
842: ,c_archive_end_date date
843: ) is
844: select paa.assignment_action_id,

Line 896: ,c_business_group_id hr_all_organization_units.organization_id%type

892: cursor rg_csr_assignment_legal_period
893: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
894: ,c_chunk NUMBER
895: ,c_employee_type per_all_people_f.current_employee_flag%type
896: ,c_business_group_id hr_all_organization_units.organization_id%type
897: ,c_legal_employer hr_all_organization_units.organization_id%type
898: ,c_archive_start_date date
899: ,c_archive_end_date date
900: ) is

Line 897: ,c_legal_employer hr_all_organization_units.organization_id%type

893: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
894: ,c_chunk NUMBER
895: ,c_employee_type per_all_people_f.current_employee_flag%type
896: ,c_business_group_id hr_all_organization_units.organization_id%type
897: ,c_legal_employer hr_all_organization_units.organization_id%type
898: ,c_archive_start_date date
899: ,c_archive_end_date date
900: ) is
901: select /*+ LEADING (ppa ppr pap paaf pps) INDEX(paaf PER_ASSIGNMENTS_F_N12) */

Line 959: ,c_business_group_id hr_all_organization_units.organization_id%type

955: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
956: ,c_start_person per_all_people_f.person_id%type
957: ,c_end_person per_all_people_f.person_id%type
958: ,c_employee_type per_all_people_f.current_employee_flag%type
959: ,c_business_group_id hr_all_organization_units.organization_id%type
960: ,c_legal_employer hr_all_organization_units.organization_id%type
961: ,c_period_end_date date
962: ,c_pact_id pay_payroll_actions.payroll_action_id%type
963: ) is

Line 960: ,c_legal_employer hr_all_organization_units.organization_id%type

956: ,c_start_person per_all_people_f.person_id%type
957: ,c_end_person per_all_people_f.person_id%type
958: ,c_employee_type per_all_people_f.current_employee_flag%type
959: ,c_business_group_id hr_all_organization_units.organization_id%type
960: ,c_legal_employer hr_all_organization_units.organization_id%type
961: ,c_period_end_date date
962: ,c_pact_id pay_payroll_actions.payroll_action_id%type
963: ) is
964: select paa.assignment_action_id,

Line 1010: ,c_business_group_id hr_all_organization_units.organization_id%type

1006: cursor rg_csr_assignment_legal_run
1007: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1008: ,c_chunk NUMBER
1009: ,c_employee_type per_all_people_f.current_employee_flag%type
1010: ,c_business_group_id hr_all_organization_units.organization_id%type
1011: ,c_legal_employer hr_all_organization_units.organization_id%type
1012: ,c_period_end_date date
1013: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1014: ) is

Line 1011: ,c_legal_employer hr_all_organization_units.organization_id%type

1007: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1008: ,c_chunk NUMBER
1009: ,c_employee_type per_all_people_f.current_employee_flag%type
1010: ,c_business_group_id hr_all_organization_units.organization_id%type
1011: ,c_legal_employer hr_all_organization_units.organization_id%type
1012: ,c_period_end_date date
1013: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1014: ) is
1015: select paa.assignment_action_id,

Line 1064: ,c_business_group_id hr_all_organization_units.organization_id%type

1060: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1061: ,c_start_person per_all_people_f.person_id%type
1062: ,c_end_person per_all_people_f.person_id%type
1063: ,c_employee_type per_all_people_f.current_employee_flag%type
1064: ,c_business_group_id hr_all_organization_units.organization_id%type
1065: ,c_payroll_id pay_payroll_actions.payroll_id%type
1066: ,c_archive_start_date date
1067: ,c_archive_end_date date
1068: ) is

Line 1116: ,c_business_group_id hr_all_organization_units.organization_id%type

1112: cursor rg_assignment_payroll_period
1113: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1114: , c_chunk NUMBER
1115: ,c_employee_type per_all_people_f.current_employee_flag%type
1116: ,c_business_group_id hr_all_organization_units.organization_id%type
1117: ,c_payroll_id pay_payroll_actions.payroll_id%type
1118: ,c_archive_start_date date
1119: ,c_archive_end_date date
1120: ) is

Line 1171: ,c_business_group_id hr_all_organization_units.organization_id%type

1167: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1168: ,c_start_person per_all_people_f.person_id%type
1169: ,c_end_person per_all_people_f.person_id%type
1170: ,c_employee_type per_all_people_f.current_employee_flag%type
1171: ,c_business_group_id hr_all_organization_units.organization_id%type
1172: ,c_payroll_id pay_payroll_actions.payroll_id%type
1173: ,c_period_end_date date
1174: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1175: ) is

Line 1216: ,c_business_group_id hr_all_organization_units.organization_id%type

1212: cursor rg_csr_assignment_payroll_run
1213: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1214: , c_chunk number
1215: ,c_employee_type per_all_people_f.current_employee_flag%type
1216: ,c_business_group_id hr_all_organization_units.organization_id%type
1217: ,c_payroll_id pay_payroll_actions.payroll_id%type
1218: ,c_period_end_date date
1219: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1220: ) is

Line 1265: ,c_business_group_id hr_all_organization_units.organization_id%type

1261: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1262: ,c_start_person per_all_people_f.person_id%type
1263: ,c_end_person per_all_people_f.person_id%type
1264: ,c_employee_type per_all_people_f.current_employee_flag%type
1265: ,c_business_group_id hr_all_organization_units.organization_id%type
1266: ,c_assignment_id per_all_assignments_f.assignment_id%type
1267: ,c_archive_start_date date
1268: ,c_archive_end_date date
1269: ) is

Line 1314: ,c_business_group_id hr_all_organization_units.organization_id%type

1310: cursor rg_csr_assignment_period
1311: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1312: ,c_chunk number
1313: ,c_employee_type per_all_people_f.current_employee_flag%type
1314: ,c_business_group_id hr_all_organization_units.organization_id%type
1315: ,c_assignment_id per_all_assignments_f.assignment_id%type
1316: ,c_archive_start_date date
1317: ,c_archive_end_date date
1318: ) is

Line 1367: ,c_business_group_id hr_all_organization_units.organization_id%type

1363: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1364: ,c_start_person per_all_people_f.person_id%type
1365: ,c_end_person per_all_people_f.person_id%type
1366: ,c_employee_type per_all_people_f.current_employee_flag%type
1367: ,c_business_group_id hr_all_organization_units.organization_id%type
1368: ,c_assignment_id per_all_assignments_f.assignment_id%type
1369: ,c_period_end_date date
1370: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1371: ) is

Line 1412: ,c_business_group_id hr_all_organization_units.organization_id%type

1408: cursor rg_csr_assignment_run
1409: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1410: , c_chunk number
1411: ,c_employee_type per_all_people_f.current_employee_flag%type
1412: ,c_business_group_id hr_all_organization_units.organization_id%type
1413: ,c_assignment_id per_all_assignments_f.assignment_id%type
1414: ,c_period_end_date date
1415: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1416: ) is

Line 1461: ,c_business_group_id hr_all_organization_units.organization_id%type

1457: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1458: ,c_start_person per_all_people_f.person_id%type
1459: ,c_end_person per_all_people_f.person_id%type
1460: ,c_employee_type per_all_people_f.current_employee_flag%type
1461: ,c_business_group_id hr_all_organization_units.organization_id%type
1462: ,c_archive_start_date date
1463: ,c_archive_end_date date
1464: ) is
1465: select paa.assignment_action_id,

Line 1508: ,c_business_group_id hr_all_organization_units.organization_id%type

1504: cursor rg_assignment_default_period
1505: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1506: , c_chunk NUMBER
1507: ,c_employee_type per_all_people_f.current_employee_flag%type
1508: ,c_business_group_id hr_all_organization_units.organization_id%type
1509: ,c_archive_start_date date
1510: ,c_archive_end_date date
1511: ) is
1512: select paa.assignment_action_id,

Line 1559: ,c_business_group_id hr_all_organization_units.organization_id%type

1555: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1556: ,c_start_person per_all_people_f.person_id%type
1557: ,c_end_person per_all_people_f.person_id%type
1558: ,c_employee_type per_all_people_f.current_employee_flag%type
1559: ,c_business_group_id hr_all_organization_units.organization_id%type
1560: ,c_period_end_date date
1561: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1562: ) is
1563: select paa.assignment_action_id,

Line 1603: ,c_business_group_id hr_all_organization_units.organization_id%type

1599: cursor rg_csr_assignment_default_run
1600: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1601: , c_chunk number
1602: ,c_employee_type per_all_people_f.current_employee_flag%type
1603: ,c_business_group_id hr_all_organization_units.organization_id%type
1604: ,c_period_end_date date
1605: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1606: ) is
1607: select paa.assignment_action_id,

Line 3022: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,

3018: Cursor c_employee_details - Added join with table per_grades_tl to fetch and archive the grade name.
3019: Outer Join introduced between per_grades_tl and per_assignments_f based on grade_id.
3020: */
3021:
3022: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,
3023: c_assignment_id number,c_end_date date, c_start_date date) /*Bug#3662449 c_start_date parameter added*/
3024: is
3025: select pap.full_name,
3026: paa.assignment_number,

Line 3037: hr_all_organization_units hou, /Bug 4132525/

3033: hou1.NAME Legal_Employer /*Bug 4132525*/
3034: from per_people_f pap,
3035: per_assignments_f paa,
3036: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
3037: hr_all_organization_units hou, /*Bug 4132525*/
3038: hr_all_organization_units hou1 /*Bug 4132525*/
3039: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688800*/
3040: where pap.person_id = paa.person_id
3041: and paa.assignment_id = c_assignment_id

Line 3038: hr_all_organization_units hou1 /Bug 4132525/

3034: from per_people_f pap,
3035: per_assignments_f paa,
3036: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
3037: hr_all_organization_units hou, /*Bug 4132525*/
3038: hr_all_organization_units hou1 /*Bug 4132525*/
3039: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688800*/
3040: where pap.person_id = paa.person_id
3041: and paa.assignment_id = c_assignment_id
3042: and paa.business_group_id = c_business_group_id