APPS.PAY_AU_RECONCILIATION_PKG dependencies on PER_ALL_PEOPLE_F

Line 614: ,p_start_person in per_all_people_f.person_id%type

610: --------------------------------------------------------------------+
611:
612: procedure assignment_action_code
613: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
614: ,p_start_person in per_all_people_f.person_id%type
615: ,p_end_person in per_all_people_f.person_id%type
616: ,p_chunk in number
617: ) is
618:

Line 615: ,p_end_person in per_all_people_f.person_id%type

611:
612: procedure assignment_action_code
613: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
614: ,p_start_person in per_all_people_f.person_id%type
615: ,p_end_person in per_all_people_f.person_id%type
616: ,p_chunk in number
617: ) is
618:
619: --------------------------------------------------------------------+

Line 627: ,c_start_person per_all_people_f.person_id%type

623: --------------------------------------------------------------------+
624:
625: cursor csr_assignment_org_period
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

Line 628: ,c_end_person per_all_people_f.person_id%type

624:
625: cursor csr_assignment_org_period
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

Line 629: ,c_employee_type per_all_people_f.current_employee_flag%type

625: cursor csr_assignment_org_period
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

Line 681: ,c_employee_type per_all_people_f.current_employee_flag%type

677: --------------------------------------------------------------------+
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

Line 734: ,c_start_person per_all_people_f.person_id%type

730: --------------------------------------------------------------------+
731:
732: cursor csr_assignment_org_run
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

Line 735: ,c_end_person per_all_people_f.person_id%type

731:
732: cursor csr_assignment_org_run
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

Line 736: ,c_employee_type per_all_people_f.current_employee_flag%type

732: cursor csr_assignment_org_run
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

Line 784: ,c_employee_type per_all_people_f.current_employee_flag%type

780: --------------------------------------------------------------------+
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

Line 836: ,c_start_person per_all_people_f.person_id%type

832: relationship*/
833:
834: cursor csr_assignment_legal_period
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

Line 837: ,c_end_person per_all_people_f.person_id%type

833:
834: cursor csr_assignment_legal_period
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

Line 838: ,c_employee_type per_all_people_f.current_employee_flag%type

834: cursor csr_assignment_legal_period
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

Line 895: ,c_employee_type per_all_people_f.current_employee_flag%type

891:
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

Line 956: ,c_start_person per_all_people_f.person_id%type

952: relationship*/
953:
954: cursor csr_assignment_legal_run
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

Line 957: ,c_end_person per_all_people_f.person_id%type

953:
954: cursor csr_assignment_legal_run
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

Line 958: ,c_employee_type per_all_people_f.current_employee_flag%type

954: cursor csr_assignment_legal_run
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

Line 1009: ,c_employee_type per_all_people_f.current_employee_flag%type

1005: --------------------------------------------------------------------+
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

Line 1061: ,c_start_person per_all_people_f.person_id%type

1057: --------------------------------------------------------------------+
1058:
1059: cursor csr_assignment_payroll_period
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

Line 1062: ,c_end_person per_all_people_f.person_id%type

1058:
1059: cursor csr_assignment_payroll_period
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

Line 1063: ,c_employee_type per_all_people_f.current_employee_flag%type

1059: cursor csr_assignment_payroll_period
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

Line 1115: ,c_employee_type per_all_people_f.current_employee_flag%type

1111:
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

Line 1168: ,c_start_person per_all_people_f.person_id%type

1164: --------------------------------------------------------------------+
1165:
1166: cursor csr_assignment_payroll_run
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

Line 1169: ,c_end_person per_all_people_f.person_id%type

1165:
1166: cursor csr_assignment_payroll_run
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

Line 1170: ,c_employee_type per_all_people_f.current_employee_flag%type

1166: cursor csr_assignment_payroll_run
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

Line 1215: ,c_employee_type per_all_people_f.current_employee_flag%type

1211: --------------------------------------------------------------------+
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

Line 1262: ,c_start_person per_all_people_f.person_id%type

1258: --------------------------------------------------------------------+
1259:
1260: cursor csr_assignment_period
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

Line 1263: ,c_end_person per_all_people_f.person_id%type

1259:
1260: cursor csr_assignment_period
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

Line 1264: ,c_employee_type per_all_people_f.current_employee_flag%type

1260: cursor csr_assignment_period
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

Line 1313: ,c_employee_type per_all_people_f.current_employee_flag%type

1309: --------------------------------------------------------------------+
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

Line 1364: ,c_start_person per_all_people_f.person_id%type

1360: --------------------------------------------------------------------+
1361:
1362: cursor csr_assignment_run
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

Line 1365: ,c_end_person per_all_people_f.person_id%type

1361:
1362: cursor csr_assignment_run
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

Line 1366: ,c_employee_type per_all_people_f.current_employee_flag%type

1362: cursor csr_assignment_run
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

Line 1411: ,c_employee_type per_all_people_f.current_employee_flag%type

1407: --------------------------------------------------------------------+
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

Line 1458: ,c_start_person per_all_people_f.person_id%type

1454: --------------------------------------------------------------------+
1455:
1456: cursor csr_assignment_default_period
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

Line 1459: ,c_end_person per_all_people_f.person_id%type

1455:
1456: cursor csr_assignment_default_period
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

Line 1460: ,c_employee_type per_all_people_f.current_employee_flag%type

1456: cursor csr_assignment_default_period
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

Line 1507: ,c_employee_type per_all_people_f.current_employee_flag%type

1503: --------------------------------------------------------------------+
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

Line 1556: ,c_start_person per_all_people_f.person_id%type

1552: --------------------------------------------------------------------+
1553:
1554: cursor csr_assignment_default_run
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

Line 1557: ,c_end_person per_all_people_f.person_id%type

1553:
1554: cursor csr_assignment_default_run
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

Line 1558: ,c_employee_type per_all_people_f.current_employee_flag%type

1554: cursor csr_assignment_default_run
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

Line 1602: ,c_employee_type per_all_people_f.current_employee_flag%type

1598: --------------------------------------------------------------------+
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