APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 386: ,p_start_person in per_all_people_f.person_id%type

382: --------------------------------------------------------------------+
383:
384: procedure assignment_action_code
385: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
386: ,p_start_person in per_all_people_f.person_id%type
387: ,p_end_person in per_all_people_f.person_id%type
388: ,p_chunk in number
389: ) is
390:

Line 387: ,p_end_person in per_all_people_f.person_id%type

383:
384: procedure assignment_action_code
385: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
386: ,p_start_person in per_all_people_f.person_id%type
387: ,p_end_person in per_all_people_f.person_id%type
388: ,p_chunk in number
389: ) is
390:
391: --------------------------------------------------------------------+

Line 399: ,c_start_person per_all_people_f.person_id%type

395: --------------------------------------------------------------------+
396:
397: cursor csr_assignment_org_period
398: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
399: ,c_start_person per_all_people_f.person_id%type
400: ,c_end_person per_all_people_f.person_id%type
401: ,c_employee_type per_all_people_f.current_employee_flag%type
402: ,c_business_group_id hr_all_organization_units.organization_id%type
403: ,c_organization_id hr_all_organization_units.organization_id%type

Line 400: ,c_end_person per_all_people_f.person_id%type

396:
397: cursor csr_assignment_org_period
398: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
399: ,c_start_person per_all_people_f.person_id%type
400: ,c_end_person per_all_people_f.person_id%type
401: ,c_employee_type per_all_people_f.current_employee_flag%type
402: ,c_business_group_id hr_all_organization_units.organization_id%type
403: ,c_organization_id hr_all_organization_units.organization_id%type
404: ,c_archive_start_date date

Line 401: ,c_employee_type per_all_people_f.current_employee_flag%type

397: cursor csr_assignment_org_period
398: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
399: ,c_start_person per_all_people_f.person_id%type
400: ,c_end_person per_all_people_f.person_id%type
401: ,c_employee_type per_all_people_f.current_employee_flag%type
402: ,c_business_group_id hr_all_organization_units.organization_id%type
403: ,c_organization_id hr_all_organization_units.organization_id%type
404: ,c_archive_start_date date
405: ,c_archive_end_date date

Line 453: ,c_employee_type per_all_people_f.current_employee_flag%type

449: --------------------------------------------------------------------+
450: cursor rg_csr_assignment_org_period
451: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
452: ,c_chunk number
453: ,c_employee_type per_all_people_f.current_employee_flag%type
454: ,c_business_group_id hr_all_organization_units.organization_id%type
455: ,c_organization_id hr_all_organization_units.organization_id%type
456: ,c_archive_start_date date
457: ,c_archive_end_date date

Line 506: ,c_start_person per_all_people_f.person_id%type

502: --------------------------------------------------------------------+
503:
504: cursor csr_assignment_org_run
505: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
506: ,c_start_person per_all_people_f.person_id%type
507: ,c_end_person per_all_people_f.person_id%type
508: ,c_employee_type per_all_people_f.current_employee_flag%type
509: ,c_business_group_id hr_all_organization_units.organization_id%type
510: ,c_organization_id hr_all_organization_units.organization_id%type

Line 507: ,c_end_person per_all_people_f.person_id%type

503:
504: cursor csr_assignment_org_run
505: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
506: ,c_start_person per_all_people_f.person_id%type
507: ,c_end_person per_all_people_f.person_id%type
508: ,c_employee_type per_all_people_f.current_employee_flag%type
509: ,c_business_group_id hr_all_organization_units.organization_id%type
510: ,c_organization_id hr_all_organization_units.organization_id%type
511: ,c_period_end_date date

Line 508: ,c_employee_type per_all_people_f.current_employee_flag%type

504: cursor csr_assignment_org_run
505: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
506: ,c_start_person per_all_people_f.person_id%type
507: ,c_end_person per_all_people_f.person_id%type
508: ,c_employee_type per_all_people_f.current_employee_flag%type
509: ,c_business_group_id hr_all_organization_units.organization_id%type
510: ,c_organization_id hr_all_organization_units.organization_id%type
511: ,c_period_end_date date
512: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 555: ,c_employee_type per_all_people_f.current_employee_flag%type

551: --------------------------------------------------------------------+
552: cursor rg_csr_assignment_org_run
553: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
554: ,c_chunk number
555: ,c_employee_type per_all_people_f.current_employee_flag%type
556: ,c_business_group_id hr_all_organization_units.organization_id%type
557: ,c_organization_id hr_all_organization_units.organization_id%type
558: ,c_period_end_date date
559: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 603: ,c_start_person per_all_people_f.person_id%type

599: --------------------------------------------------------------------+
600:
601: cursor csr_assignment_legal_period
602: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
603: ,c_start_person per_all_people_f.person_id%type
604: ,c_end_person per_all_people_f.person_id%type
605: ,c_employee_type per_all_people_f.current_employee_flag%type
606: ,c_business_group_id hr_all_organization_units.organization_id%type
607: ,c_legal_employer hr_all_organization_units.organization_id%type

Line 604: ,c_end_person per_all_people_f.person_id%type

600:
601: cursor csr_assignment_legal_period
602: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
603: ,c_start_person per_all_people_f.person_id%type
604: ,c_end_person per_all_people_f.person_id%type
605: ,c_employee_type per_all_people_f.current_employee_flag%type
606: ,c_business_group_id hr_all_organization_units.organization_id%type
607: ,c_legal_employer hr_all_organization_units.organization_id%type
608: ,c_archive_start_date date

Line 605: ,c_employee_type per_all_people_f.current_employee_flag%type

601: cursor csr_assignment_legal_period
602: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
603: ,c_start_person per_all_people_f.person_id%type
604: ,c_end_person per_all_people_f.person_id%type
605: ,c_employee_type per_all_people_f.current_employee_flag%type
606: ,c_business_group_id hr_all_organization_units.organization_id%type
607: ,c_legal_employer hr_all_organization_units.organization_id%type
608: ,c_archive_start_date date
609: ,c_archive_end_date date

Line 655: ,c_employee_type per_all_people_f.current_employee_flag%type

651: --------------------------------------------------------------------+
652: cursor rg_csr_assignment_legal_period
653: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
654: ,c_chunk number
655: ,c_employee_type per_all_people_f.current_employee_flag%type
656: ,c_business_group_id hr_all_organization_units.organization_id%type
657: ,c_legal_employer hr_all_organization_units.organization_id%type
658: ,c_archive_start_date date
659: ,c_archive_end_date date

Line 705: ,c_start_person per_all_people_f.person_id%type

701:
702:
703: cursor csr_assignment_legal_run
704: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
705: ,c_start_person per_all_people_f.person_id%type
706: ,c_end_person per_all_people_f.person_id%type
707: ,c_employee_type per_all_people_f.current_employee_flag%type
708: ,c_business_group_id hr_all_organization_units.organization_id%type
709: ,c_legal_employer hr_all_organization_units.organization_id%type

Line 706: ,c_end_person per_all_people_f.person_id%type

702:
703: cursor csr_assignment_legal_run
704: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
705: ,c_start_person per_all_people_f.person_id%type
706: ,c_end_person per_all_people_f.person_id%type
707: ,c_employee_type per_all_people_f.current_employee_flag%type
708: ,c_business_group_id hr_all_organization_units.organization_id%type
709: ,c_legal_employer hr_all_organization_units.organization_id%type
710: ,c_period_end_date date

Line 707: ,c_employee_type per_all_people_f.current_employee_flag%type

703: cursor csr_assignment_legal_run
704: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
705: ,c_start_person per_all_people_f.person_id%type
706: ,c_end_person per_all_people_f.person_id%type
707: ,c_employee_type per_all_people_f.current_employee_flag%type
708: ,c_business_group_id hr_all_organization_units.organization_id%type
709: ,c_legal_employer hr_all_organization_units.organization_id%type
710: ,c_period_end_date date
711: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 752: ,c_employee_type per_all_people_f.current_employee_flag%type

748:
749: cursor rg_csr_assignment_legal_run
750: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
751: , c_chunk number
752: ,c_employee_type per_all_people_f.current_employee_flag%type
753: ,c_business_group_id hr_all_organization_units.organization_id%type
754: ,c_legal_employer hr_all_organization_units.organization_id%type
755: ,c_period_end_date date
756: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 797: ,c_start_person per_all_people_f.person_id%type

793: --------------------------------------------------------------------+
794:
795: cursor csr_assignment_payroll_period
796: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
797: ,c_start_person per_all_people_f.person_id%type
798: ,c_end_person per_all_people_f.person_id%type
799: ,c_employee_type per_all_people_f.current_employee_flag%type
800: ,c_business_group_id hr_all_organization_units.organization_id%type
801: ,c_payroll_id pay_payroll_actions.payroll_id%type

Line 798: ,c_end_person per_all_people_f.person_id%type

794:
795: cursor csr_assignment_payroll_period
796: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
797: ,c_start_person per_all_people_f.person_id%type
798: ,c_end_person per_all_people_f.person_id%type
799: ,c_employee_type per_all_people_f.current_employee_flag%type
800: ,c_business_group_id hr_all_organization_units.organization_id%type
801: ,c_payroll_id pay_payroll_actions.payroll_id%type
802: ,c_archive_start_date date

Line 799: ,c_employee_type per_all_people_f.current_employee_flag%type

795: cursor csr_assignment_payroll_period
796: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
797: ,c_start_person per_all_people_f.person_id%type
798: ,c_end_person per_all_people_f.person_id%type
799: ,c_employee_type per_all_people_f.current_employee_flag%type
800: ,c_business_group_id hr_all_organization_units.organization_id%type
801: ,c_payroll_id pay_payroll_actions.payroll_id%type
802: ,c_archive_start_date date
803: ,c_archive_end_date date

Line 851: ,c_employee_type per_all_people_f.current_employee_flag%type

847:
848: cursor rg_assignment_payroll_period
849: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
850: ,c_chunk NUMBER
851: ,c_employee_type per_all_people_f.current_employee_flag%type
852: ,c_business_group_id hr_all_organization_units.organization_id%type
853: ,c_payroll_id pay_payroll_actions.payroll_id%type
854: ,c_archive_start_date date
855: ,c_archive_end_date date

Line 902: ,c_start_person per_all_people_f.person_id%type

898: --------------------------------------------------------------------+
899:
900: cursor csr_assignment_payroll_run
901: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
902: ,c_start_person per_all_people_f.person_id%type
903: ,c_end_person per_all_people_f.person_id%type
904: ,c_employee_type per_all_people_f.current_employee_flag%type
905: ,c_business_group_id hr_all_organization_units.organization_id%type
906: ,c_payroll_id pay_payroll_actions.payroll_id%type

Line 903: ,c_end_person per_all_people_f.person_id%type

899:
900: cursor csr_assignment_payroll_run
901: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
902: ,c_start_person per_all_people_f.person_id%type
903: ,c_end_person per_all_people_f.person_id%type
904: ,c_employee_type per_all_people_f.current_employee_flag%type
905: ,c_business_group_id hr_all_organization_units.organization_id%type
906: ,c_payroll_id pay_payroll_actions.payroll_id%type
907: ,c_period_end_date date

Line 904: ,c_employee_type per_all_people_f.current_employee_flag%type

900: cursor csr_assignment_payroll_run
901: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
902: ,c_start_person per_all_people_f.person_id%type
903: ,c_end_person per_all_people_f.person_id%type
904: ,c_employee_type per_all_people_f.current_employee_flag%type
905: ,c_business_group_id hr_all_organization_units.organization_id%type
906: ,c_payroll_id pay_payroll_actions.payroll_id%type
907: ,c_period_end_date date
908: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 950: ,c_employee_type per_all_people_f.current_employee_flag%type

946:
947: cursor rg_csr_assignment_payroll_run
948: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
949: , c_chunk NUMBER
950: ,c_employee_type per_all_people_f.current_employee_flag%type
951: ,c_business_group_id hr_all_organization_units.organization_id%type
952: ,c_payroll_id pay_payroll_actions.payroll_id%type
953: ,c_period_end_date date
954: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 996: ,c_start_person per_all_people_f.person_id%type

992: --------------------------------------------------------------------+
993:
994: cursor csr_assignment_period
995: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
996: ,c_start_person per_all_people_f.person_id%type
997: ,c_end_person per_all_people_f.person_id%type
998: ,c_employee_type per_all_people_f.current_employee_flag%type
999: ,c_business_group_id hr_all_organization_units.organization_id%type
1000: ,c_assignment_id per_all_assignments_f.assignment_id%type

Line 997: ,c_end_person per_all_people_f.person_id%type

993:
994: cursor csr_assignment_period
995: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
996: ,c_start_person per_all_people_f.person_id%type
997: ,c_end_person per_all_people_f.person_id%type
998: ,c_employee_type per_all_people_f.current_employee_flag%type
999: ,c_business_group_id hr_all_organization_units.organization_id%type
1000: ,c_assignment_id per_all_assignments_f.assignment_id%type
1001: ,c_archive_start_date date

Line 998: ,c_employee_type per_all_people_f.current_employee_flag%type

994: cursor csr_assignment_period
995: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
996: ,c_start_person per_all_people_f.person_id%type
997: ,c_end_person per_all_people_f.person_id%type
998: ,c_employee_type per_all_people_f.current_employee_flag%type
999: ,c_business_group_id hr_all_organization_units.organization_id%type
1000: ,c_assignment_id per_all_assignments_f.assignment_id%type
1001: ,c_archive_start_date date
1002: ,c_archive_end_date date

Line 1047: ,c_employee_type per_all_people_f.current_employee_flag%type

1043: --------------------------------------------------------------------+
1044: cursor rg_csr_assignment_period
1045: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1046: ,c_chunk NUMBER
1047: ,c_employee_type per_all_people_f.current_employee_flag%type
1048: ,c_business_group_id hr_all_organization_units.organization_id%type
1049: ,c_assignment_id per_all_assignments_f.assignment_id%type
1050: ,c_archive_start_date date
1051: ,c_archive_end_date date

Line 1096: ,c_start_person per_all_people_f.person_id%type

1092: --------------------------------------------------------------------+
1093:
1094: cursor csr_assignment_run
1095: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1096: ,c_start_person per_all_people_f.person_id%type
1097: ,c_end_person per_all_people_f.person_id%type
1098: ,c_employee_type per_all_people_f.current_employee_flag%type
1099: ,c_business_group_id hr_all_organization_units.organization_id%type
1100: ,c_assignment_id per_all_assignments_f.assignment_id%type

Line 1097: ,c_end_person per_all_people_f.person_id%type

1093:
1094: cursor csr_assignment_run
1095: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1096: ,c_start_person per_all_people_f.person_id%type
1097: ,c_end_person per_all_people_f.person_id%type
1098: ,c_employee_type per_all_people_f.current_employee_flag%type
1099: ,c_business_group_id hr_all_organization_units.organization_id%type
1100: ,c_assignment_id per_all_assignments_f.assignment_id%type
1101: ,c_period_end_date date

Line 1098: ,c_employee_type per_all_people_f.current_employee_flag%type

1094: cursor csr_assignment_run
1095: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1096: ,c_start_person per_all_people_f.person_id%type
1097: ,c_end_person per_all_people_f.person_id%type
1098: ,c_employee_type per_all_people_f.current_employee_flag%type
1099: ,c_business_group_id hr_all_organization_units.organization_id%type
1100: ,c_assignment_id per_all_assignments_f.assignment_id%type
1101: ,c_period_end_date date
1102: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 1142: ,c_employee_type per_all_people_f.current_employee_flag%type

1138: --------------------------------------------------------------------+
1139: cursor rg_csr_assignment_run
1140: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1141: , c_chunk NUMBER
1142: ,c_employee_type per_all_people_f.current_employee_flag%type
1143: ,c_business_group_id hr_all_organization_units.organization_id%type
1144: ,c_assignment_id per_all_assignments_f.assignment_id%type
1145: ,c_period_end_date date
1146: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 1187: ,c_start_person per_all_people_f.person_id%type

1183: --------------------------------------------------------------------+
1184:
1185: cursor csr_assignment_default_period
1186: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1187: ,c_start_person per_all_people_f.person_id%type
1188: ,c_end_person per_all_people_f.person_id%type
1189: ,c_employee_type per_all_people_f.current_employee_flag%type
1190: ,c_business_group_id hr_all_organization_units.organization_id%type
1191: ,c_archive_start_date date

Line 1188: ,c_end_person per_all_people_f.person_id%type

1184:
1185: cursor csr_assignment_default_period
1186: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1187: ,c_start_person per_all_people_f.person_id%type
1188: ,c_end_person per_all_people_f.person_id%type
1189: ,c_employee_type per_all_people_f.current_employee_flag%type
1190: ,c_business_group_id hr_all_organization_units.organization_id%type
1191: ,c_archive_start_date date
1192: ,c_archive_end_date date

Line 1189: ,c_employee_type per_all_people_f.current_employee_flag%type

1185: cursor csr_assignment_default_period
1186: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1187: ,c_start_person per_all_people_f.person_id%type
1188: ,c_end_person per_all_people_f.person_id%type
1189: ,c_employee_type per_all_people_f.current_employee_flag%type
1190: ,c_business_group_id hr_all_organization_units.organization_id%type
1191: ,c_archive_start_date date
1192: ,c_archive_end_date date
1193: ) is

Line 1236: ,c_employee_type per_all_people_f.current_employee_flag%type

1232: --------------------------------------------------------------------+
1233: cursor rg_assignment_default_period
1234: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1235: ,c_chunk NUMBER
1236: ,c_employee_type per_all_people_f.current_employee_flag%type
1237: ,c_business_group_id hr_all_organization_units.organization_id%type
1238: ,c_archive_start_date date
1239: ,c_archive_end_date date
1240: ) is

Line 1283: ,c_start_person per_all_people_f.person_id%type

1279: --------------------------------------------------------------------+
1280:
1281: cursor csr_assignment_default_run
1282: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1283: ,c_start_person per_all_people_f.person_id%type
1284: ,c_end_person per_all_people_f.person_id%type
1285: ,c_employee_type per_all_people_f.current_employee_flag%type
1286: ,c_business_group_id hr_all_organization_units.organization_id%type
1287: ,c_period_end_date date

Line 1284: ,c_end_person per_all_people_f.person_id%type

1280:
1281: cursor csr_assignment_default_run
1282: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1283: ,c_start_person per_all_people_f.person_id%type
1284: ,c_end_person per_all_people_f.person_id%type
1285: ,c_employee_type per_all_people_f.current_employee_flag%type
1286: ,c_business_group_id hr_all_organization_units.organization_id%type
1287: ,c_period_end_date date
1288: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 1285: ,c_employee_type per_all_people_f.current_employee_flag%type

1281: cursor csr_assignment_default_run
1282: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1283: ,c_start_person per_all_people_f.person_id%type
1284: ,c_end_person per_all_people_f.person_id%type
1285: ,c_employee_type per_all_people_f.current_employee_flag%type
1286: ,c_business_group_id hr_all_organization_units.organization_id%type
1287: ,c_period_end_date date
1288: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1289: ) is

Line 1328: ,c_employee_type per_all_people_f.current_employee_flag%type

1324: --------------------------------------------------------------------+
1325: cursor rg_csr_assignment_default_run
1326: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1327: , c_chunk NUMBER
1328: ,c_employee_type per_all_people_f.current_employee_flag%type
1329: ,c_business_group_id hr_all_organization_units.organization_id%type
1330: ,c_period_end_date date
1331: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1332: ) is