APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 314: ,p_start_person in per_all_people_f.person_id%type

310: --------------------------------------------------------------------+
311:
312: procedure assignment_action_code
313: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
314: ,p_start_person in per_all_people_f.person_id%type
315: ,p_end_person in per_all_people_f.person_id%type
316: ,p_chunk in number
317: ) is
318:

Line 315: ,p_end_person in per_all_people_f.person_id%type

311:
312: procedure assignment_action_code
313: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
314: ,p_start_person in per_all_people_f.person_id%type
315: ,p_end_person in per_all_people_f.person_id%type
316: ,p_chunk in number
317: ) is
318:
319: --------------------------------------------------------------------+

Line 327: ,c_start_person per_all_people_f.person_id%type

323: --------------------------------------------------------------------+
324:
325: cursor csr_assignment_org_period
326: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
327: ,c_start_person per_all_people_f.person_id%type
328: ,c_end_person per_all_people_f.person_id%type
329: ,c_employee_type per_all_people_f.current_employee_flag%type
330: ,c_business_group_id hr_all_organization_units.organization_id%type
331: ,c_organization_id hr_all_organization_units.organization_id%type

Line 328: ,c_end_person per_all_people_f.person_id%type

324:
325: cursor csr_assignment_org_period
326: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
327: ,c_start_person per_all_people_f.person_id%type
328: ,c_end_person per_all_people_f.person_id%type
329: ,c_employee_type per_all_people_f.current_employee_flag%type
330: ,c_business_group_id hr_all_organization_units.organization_id%type
331: ,c_organization_id hr_all_organization_units.organization_id%type
332: ,c_archive_start_date date

Line 329: ,c_employee_type per_all_people_f.current_employee_flag%type

325: cursor csr_assignment_org_period
326: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
327: ,c_start_person per_all_people_f.person_id%type
328: ,c_end_person per_all_people_f.person_id%type
329: ,c_employee_type per_all_people_f.current_employee_flag%type
330: ,c_business_group_id hr_all_organization_units.organization_id%type
331: ,c_organization_id hr_all_organization_units.organization_id%type
332: ,c_archive_start_date date
333: ,c_archive_end_date date

Line 380: ,c_start_person per_all_people_f.person_id%type

376: --------------------------------------------------------------------+
377:
378: cursor csr_assignment_org_run
379: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
380: ,c_start_person per_all_people_f.person_id%type
381: ,c_end_person per_all_people_f.person_id%type
382: ,c_employee_type per_all_people_f.current_employee_flag%type
383: ,c_business_group_id hr_all_organization_units.organization_id%type
384: ,c_organization_id hr_all_organization_units.organization_id%type

Line 381: ,c_end_person per_all_people_f.person_id%type

377:
378: cursor csr_assignment_org_run
379: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
380: ,c_start_person per_all_people_f.person_id%type
381: ,c_end_person per_all_people_f.person_id%type
382: ,c_employee_type per_all_people_f.current_employee_flag%type
383: ,c_business_group_id hr_all_organization_units.organization_id%type
384: ,c_organization_id hr_all_organization_units.organization_id%type
385: ,c_period_end_date date

Line 382: ,c_employee_type per_all_people_f.current_employee_flag%type

378: cursor csr_assignment_org_run
379: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
380: ,c_start_person per_all_people_f.person_id%type
381: ,c_end_person per_all_people_f.person_id%type
382: ,c_employee_type per_all_people_f.current_employee_flag%type
383: ,c_business_group_id hr_all_organization_units.organization_id%type
384: ,c_organization_id hr_all_organization_units.organization_id%type
385: ,c_period_end_date date
386: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 427: ,c_start_person per_all_people_f.person_id%type

423: --------------------------------------------------------------------+
424:
425: cursor csr_assignment_legal_period
426: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
427: ,c_start_person per_all_people_f.person_id%type
428: ,c_end_person per_all_people_f.person_id%type
429: ,c_employee_type per_all_people_f.current_employee_flag%type
430: ,c_business_group_id hr_all_organization_units.organization_id%type
431: ,c_legal_employer hr_all_organization_units.organization_id%type

Line 428: ,c_end_person per_all_people_f.person_id%type

424:
425: cursor csr_assignment_legal_period
426: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
427: ,c_start_person per_all_people_f.person_id%type
428: ,c_end_person per_all_people_f.person_id%type
429: ,c_employee_type per_all_people_f.current_employee_flag%type
430: ,c_business_group_id hr_all_organization_units.organization_id%type
431: ,c_legal_employer hr_all_organization_units.organization_id%type
432: ,c_archive_start_date date

Line 429: ,c_employee_type per_all_people_f.current_employee_flag%type

425: cursor csr_assignment_legal_period
426: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
427: ,c_start_person per_all_people_f.person_id%type
428: ,c_end_person per_all_people_f.person_id%type
429: ,c_employee_type per_all_people_f.current_employee_flag%type
430: ,c_business_group_id hr_all_organization_units.organization_id%type
431: ,c_legal_employer hr_all_organization_units.organization_id%type
432: ,c_archive_start_date date
433: ,c_archive_end_date date

Line 478: ,c_start_person per_all_people_f.person_id%type

474:
475:
476: cursor csr_assignment_legal_run
477: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
478: ,c_start_person per_all_people_f.person_id%type
479: ,c_end_person per_all_people_f.person_id%type
480: ,c_employee_type per_all_people_f.current_employee_flag%type
481: ,c_business_group_id hr_all_organization_units.organization_id%type
482: ,c_legal_employer hr_all_organization_units.organization_id%type

Line 479: ,c_end_person per_all_people_f.person_id%type

475:
476: cursor csr_assignment_legal_run
477: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
478: ,c_start_person per_all_people_f.person_id%type
479: ,c_end_person per_all_people_f.person_id%type
480: ,c_employee_type per_all_people_f.current_employee_flag%type
481: ,c_business_group_id hr_all_organization_units.organization_id%type
482: ,c_legal_employer hr_all_organization_units.organization_id%type
483: ,c_period_end_date date

Line 480: ,c_employee_type per_all_people_f.current_employee_flag%type

476: cursor csr_assignment_legal_run
477: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
478: ,c_start_person per_all_people_f.person_id%type
479: ,c_end_person per_all_people_f.person_id%type
480: ,c_employee_type per_all_people_f.current_employee_flag%type
481: ,c_business_group_id hr_all_organization_units.organization_id%type
482: ,c_legal_employer hr_all_organization_units.organization_id%type
483: ,c_period_end_date date
484: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 522: ,c_start_person per_all_people_f.person_id%type

518: --------------------------------------------------------------------+
519:
520: cursor csr_assignment_payroll_period
521: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
522: ,c_start_person per_all_people_f.person_id%type
523: ,c_end_person per_all_people_f.person_id%type
524: ,c_employee_type per_all_people_f.current_employee_flag%type
525: ,c_business_group_id hr_all_organization_units.organization_id%type
526: ,c_payroll_id pay_payroll_actions.payroll_id%type

Line 523: ,c_end_person per_all_people_f.person_id%type

519:
520: cursor csr_assignment_payroll_period
521: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
522: ,c_start_person per_all_people_f.person_id%type
523: ,c_end_person per_all_people_f.person_id%type
524: ,c_employee_type per_all_people_f.current_employee_flag%type
525: ,c_business_group_id hr_all_organization_units.organization_id%type
526: ,c_payroll_id pay_payroll_actions.payroll_id%type
527: ,c_archive_start_date date

Line 524: ,c_employee_type per_all_people_f.current_employee_flag%type

520: cursor csr_assignment_payroll_period
521: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
522: ,c_start_person per_all_people_f.person_id%type
523: ,c_end_person per_all_people_f.person_id%type
524: ,c_employee_type per_all_people_f.current_employee_flag%type
525: ,c_business_group_id hr_all_organization_units.organization_id%type
526: ,c_payroll_id pay_payroll_actions.payroll_id%type
527: ,c_archive_start_date date
528: ,c_archive_end_date date

Line 572: ,c_start_person per_all_people_f.person_id%type

568: --------------------------------------------------------------------+
569:
570: cursor csr_assignment_payroll_run
571: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
572: ,c_start_person per_all_people_f.person_id%type
573: ,c_end_person per_all_people_f.person_id%type
574: ,c_employee_type per_all_people_f.current_employee_flag%type
575: ,c_business_group_id hr_all_organization_units.organization_id%type
576: ,c_payroll_id pay_payroll_actions.payroll_id%type

Line 573: ,c_end_person per_all_people_f.person_id%type

569:
570: cursor csr_assignment_payroll_run
571: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
572: ,c_start_person per_all_people_f.person_id%type
573: ,c_end_person per_all_people_f.person_id%type
574: ,c_employee_type per_all_people_f.current_employee_flag%type
575: ,c_business_group_id hr_all_organization_units.organization_id%type
576: ,c_payroll_id pay_payroll_actions.payroll_id%type
577: ,c_period_end_date date

Line 574: ,c_employee_type per_all_people_f.current_employee_flag%type

570: cursor csr_assignment_payroll_run
571: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
572: ,c_start_person per_all_people_f.person_id%type
573: ,c_end_person per_all_people_f.person_id%type
574: ,c_employee_type per_all_people_f.current_employee_flag%type
575: ,c_business_group_id hr_all_organization_units.organization_id%type
576: ,c_payroll_id pay_payroll_actions.payroll_id%type
577: ,c_period_end_date date
578: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 617: ,c_start_person per_all_people_f.person_id%type

613: --------------------------------------------------------------------+
614:
615: cursor csr_assignment_period
616: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
617: ,c_start_person per_all_people_f.person_id%type
618: ,c_end_person per_all_people_f.person_id%type
619: ,c_employee_type per_all_people_f.current_employee_flag%type
620: ,c_business_group_id hr_all_organization_units.organization_id%type
621: ,c_assignment_id per_all_assignments_f.assignment_id%type

Line 618: ,c_end_person per_all_people_f.person_id%type

614:
615: cursor csr_assignment_period
616: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
617: ,c_start_person per_all_people_f.person_id%type
618: ,c_end_person per_all_people_f.person_id%type
619: ,c_employee_type per_all_people_f.current_employee_flag%type
620: ,c_business_group_id hr_all_organization_units.organization_id%type
621: ,c_assignment_id per_all_assignments_f.assignment_id%type
622: ,c_archive_start_date date

Line 619: ,c_employee_type per_all_people_f.current_employee_flag%type

615: cursor csr_assignment_period
616: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
617: ,c_start_person per_all_people_f.person_id%type
618: ,c_end_person per_all_people_f.person_id%type
619: ,c_employee_type per_all_people_f.current_employee_flag%type
620: ,c_business_group_id hr_all_organization_units.organization_id%type
621: ,c_assignment_id per_all_assignments_f.assignment_id%type
622: ,c_archive_start_date date
623: ,c_archive_end_date date

Line 666: ,c_start_person per_all_people_f.person_id%type

662: --------------------------------------------------------------------+
663:
664: cursor csr_assignment_run
665: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
666: ,c_start_person per_all_people_f.person_id%type
667: ,c_end_person per_all_people_f.person_id%type
668: ,c_employee_type per_all_people_f.current_employee_flag%type
669: ,c_business_group_id hr_all_organization_units.organization_id%type
670: ,c_assignment_id per_all_assignments_f.assignment_id%type

Line 667: ,c_end_person per_all_people_f.person_id%type

663:
664: cursor csr_assignment_run
665: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
666: ,c_start_person per_all_people_f.person_id%type
667: ,c_end_person per_all_people_f.person_id%type
668: ,c_employee_type per_all_people_f.current_employee_flag%type
669: ,c_business_group_id hr_all_organization_units.organization_id%type
670: ,c_assignment_id per_all_assignments_f.assignment_id%type
671: ,c_period_end_date date

Line 668: ,c_employee_type per_all_people_f.current_employee_flag%type

664: cursor csr_assignment_run
665: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
666: ,c_start_person per_all_people_f.person_id%type
667: ,c_end_person per_all_people_f.person_id%type
668: ,c_employee_type per_all_people_f.current_employee_flag%type
669: ,c_business_group_id hr_all_organization_units.organization_id%type
670: ,c_assignment_id per_all_assignments_f.assignment_id%type
671: ,c_period_end_date date
672: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 710: ,c_start_person per_all_people_f.person_id%type

706: --------------------------------------------------------------------+
707:
708: cursor csr_assignment_default_period
709: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
710: ,c_start_person per_all_people_f.person_id%type
711: ,c_end_person per_all_people_f.person_id%type
712: ,c_employee_type per_all_people_f.current_employee_flag%type
713: ,c_business_group_id hr_all_organization_units.organization_id%type
714: ,c_archive_start_date date

Line 711: ,c_end_person per_all_people_f.person_id%type

707:
708: cursor csr_assignment_default_period
709: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
710: ,c_start_person per_all_people_f.person_id%type
711: ,c_end_person per_all_people_f.person_id%type
712: ,c_employee_type per_all_people_f.current_employee_flag%type
713: ,c_business_group_id hr_all_organization_units.organization_id%type
714: ,c_archive_start_date date
715: ,c_archive_end_date date

Line 712: ,c_employee_type per_all_people_f.current_employee_flag%type

708: cursor csr_assignment_default_period
709: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
710: ,c_start_person per_all_people_f.person_id%type
711: ,c_end_person per_all_people_f.person_id%type
712: ,c_employee_type per_all_people_f.current_employee_flag%type
713: ,c_business_group_id hr_all_organization_units.organization_id%type
714: ,c_archive_start_date date
715: ,c_archive_end_date date
716: ) is

Line 757: ,c_start_person per_all_people_f.person_id%type

753: --------------------------------------------------------------------+
754:
755: cursor csr_assignment_default_run
756: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
757: ,c_start_person per_all_people_f.person_id%type
758: ,c_end_person per_all_people_f.person_id%type
759: ,c_employee_type per_all_people_f.current_employee_flag%type
760: ,c_business_group_id hr_all_organization_units.organization_id%type
761: ,c_period_end_date date

Line 758: ,c_end_person per_all_people_f.person_id%type

754:
755: cursor csr_assignment_default_run
756: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
757: ,c_start_person per_all_people_f.person_id%type
758: ,c_end_person per_all_people_f.person_id%type
759: ,c_employee_type per_all_people_f.current_employee_flag%type
760: ,c_business_group_id hr_all_organization_units.organization_id%type
761: ,c_period_end_date date
762: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 759: ,c_employee_type per_all_people_f.current_employee_flag%type

755: cursor csr_assignment_default_run
756: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
757: ,c_start_person per_all_people_f.person_id%type
758: ,c_end_person per_all_people_f.person_id%type
759: ,c_employee_type per_all_people_f.current_employee_flag%type
760: ,c_business_group_id hr_all_organization_units.organization_id%type
761: ,c_period_end_date date
762: ,c_pact_id pay_payroll_actions.payroll_action_id%type
763: ) is