APPS.PAY_AU_RECONCILIATION_PKG dependencies on PER_ALL_PEOPLE_F

Line 500: ,p_start_person in per_all_people_f.person_id%type

496: --------------------------------------------------------------------+
497:
498: procedure assignment_action_code
499: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
500: ,p_start_person in per_all_people_f.person_id%type
501: ,p_end_person in per_all_people_f.person_id%type
502: ,p_chunk in number
503: ) is
504:

Line 501: ,p_end_person in per_all_people_f.person_id%type

497:
498: procedure assignment_action_code
499: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
500: ,p_start_person in per_all_people_f.person_id%type
501: ,p_end_person in per_all_people_f.person_id%type
502: ,p_chunk in number
503: ) is
504:
505: --------------------------------------------------------------------+

Line 513: ,c_start_person per_all_people_f.person_id%type

509: --------------------------------------------------------------------+
510:
511: cursor csr_assignment_org_period
512: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
513: ,c_start_person per_all_people_f.person_id%type
514: ,c_end_person per_all_people_f.person_id%type
515: ,c_employee_type per_all_people_f.current_employee_flag%type
516: ,c_business_group_id hr_all_organization_units.organization_id%type
517: ,c_organization_id hr_all_organization_units.organization_id%type

Line 514: ,c_end_person per_all_people_f.person_id%type

510:
511: cursor csr_assignment_org_period
512: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
513: ,c_start_person per_all_people_f.person_id%type
514: ,c_end_person per_all_people_f.person_id%type
515: ,c_employee_type per_all_people_f.current_employee_flag%type
516: ,c_business_group_id hr_all_organization_units.organization_id%type
517: ,c_organization_id hr_all_organization_units.organization_id%type
518: ,c_archive_start_date date

Line 515: ,c_employee_type per_all_people_f.current_employee_flag%type

511: cursor csr_assignment_org_period
512: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
513: ,c_start_person per_all_people_f.person_id%type
514: ,c_end_person per_all_people_f.person_id%type
515: ,c_employee_type per_all_people_f.current_employee_flag%type
516: ,c_business_group_id hr_all_organization_units.organization_id%type
517: ,c_organization_id hr_all_organization_units.organization_id%type
518: ,c_archive_start_date date
519: ,c_archive_end_date date

Line 566: ,c_start_person per_all_people_f.person_id%type

562: --------------------------------------------------------------------+
563:
564: cursor csr_assignment_org_run
565: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
566: ,c_start_person per_all_people_f.person_id%type
567: ,c_end_person per_all_people_f.person_id%type
568: ,c_employee_type per_all_people_f.current_employee_flag%type
569: ,c_business_group_id hr_all_organization_units.organization_id%type
570: ,c_organization_id hr_all_organization_units.organization_id%type

Line 567: ,c_end_person per_all_people_f.person_id%type

563:
564: cursor csr_assignment_org_run
565: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
566: ,c_start_person per_all_people_f.person_id%type
567: ,c_end_person per_all_people_f.person_id%type
568: ,c_employee_type per_all_people_f.current_employee_flag%type
569: ,c_business_group_id hr_all_organization_units.organization_id%type
570: ,c_organization_id hr_all_organization_units.organization_id%type
571: ,c_period_end_date date

Line 568: ,c_employee_type per_all_people_f.current_employee_flag%type

564: cursor csr_assignment_org_run
565: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
566: ,c_start_person per_all_people_f.person_id%type
567: ,c_end_person per_all_people_f.person_id%type
568: ,c_employee_type per_all_people_f.current_employee_flag%type
569: ,c_business_group_id hr_all_organization_units.organization_id%type
570: ,c_organization_id hr_all_organization_units.organization_id%type
571: ,c_period_end_date date
572: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 617: ,c_start_person per_all_people_f.person_id%type

613: relationship*/
614:
615: cursor csr_assignment_legal_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_legal_employer hr_all_organization_units.organization_id%type

Line 618: ,c_end_person per_all_people_f.person_id%type

614:
615: cursor csr_assignment_legal_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_legal_employer hr_all_organization_units.organization_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_legal_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_legal_employer hr_all_organization_units.organization_id%type
622: ,c_archive_start_date date
623: ,c_archive_end_date date

Line 676: ,c_start_person per_all_people_f.person_id%type

672: relationship*/
673:
674: cursor csr_assignment_legal_run
675: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
676: ,c_start_person per_all_people_f.person_id%type
677: ,c_end_person per_all_people_f.person_id%type
678: ,c_employee_type per_all_people_f.current_employee_flag%type
679: ,c_business_group_id hr_all_organization_units.organization_id%type
680: ,c_legal_employer hr_all_organization_units.organization_id%type

Line 677: ,c_end_person per_all_people_f.person_id%type

673:
674: cursor csr_assignment_legal_run
675: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
676: ,c_start_person per_all_people_f.person_id%type
677: ,c_end_person per_all_people_f.person_id%type
678: ,c_employee_type per_all_people_f.current_employee_flag%type
679: ,c_business_group_id hr_all_organization_units.organization_id%type
680: ,c_legal_employer hr_all_organization_units.organization_id%type
681: ,c_period_end_date date

Line 678: ,c_employee_type per_all_people_f.current_employee_flag%type

674: cursor csr_assignment_legal_run
675: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
676: ,c_start_person per_all_people_f.person_id%type
677: ,c_end_person per_all_people_f.person_id%type
678: ,c_employee_type per_all_people_f.current_employee_flag%type
679: ,c_business_group_id hr_all_organization_units.organization_id%type
680: ,c_legal_employer hr_all_organization_units.organization_id%type
681: ,c_period_end_date date
682: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 727: ,c_start_person per_all_people_f.person_id%type

723: --------------------------------------------------------------------+
724:
725: cursor csr_assignment_payroll_period
726: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
727: ,c_start_person per_all_people_f.person_id%type
728: ,c_end_person per_all_people_f.person_id%type
729: ,c_employee_type per_all_people_f.current_employee_flag%type
730: ,c_business_group_id hr_all_organization_units.organization_id%type
731: ,c_payroll_id pay_payroll_actions.payroll_id%type

Line 728: ,c_end_person per_all_people_f.person_id%type

724:
725: cursor csr_assignment_payroll_period
726: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
727: ,c_start_person per_all_people_f.person_id%type
728: ,c_end_person per_all_people_f.person_id%type
729: ,c_employee_type per_all_people_f.current_employee_flag%type
730: ,c_business_group_id hr_all_organization_units.organization_id%type
731: ,c_payroll_id pay_payroll_actions.payroll_id%type
732: ,c_archive_start_date date

Line 729: ,c_employee_type per_all_people_f.current_employee_flag%type

725: cursor csr_assignment_payroll_period
726: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
727: ,c_start_person per_all_people_f.person_id%type
728: ,c_end_person per_all_people_f.person_id%type
729: ,c_employee_type per_all_people_f.current_employee_flag%type
730: ,c_business_group_id hr_all_organization_units.organization_id%type
731: ,c_payroll_id pay_payroll_actions.payroll_id%type
732: ,c_archive_start_date date
733: ,c_archive_end_date date

Line 777: ,c_start_person per_all_people_f.person_id%type

773: --------------------------------------------------------------------+
774:
775: cursor csr_assignment_payroll_run
776: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
777: ,c_start_person per_all_people_f.person_id%type
778: ,c_end_person per_all_people_f.person_id%type
779: ,c_employee_type per_all_people_f.current_employee_flag%type
780: ,c_business_group_id hr_all_organization_units.organization_id%type
781: ,c_payroll_id pay_payroll_actions.payroll_id%type

Line 778: ,c_end_person per_all_people_f.person_id%type

774:
775: cursor csr_assignment_payroll_run
776: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
777: ,c_start_person per_all_people_f.person_id%type
778: ,c_end_person per_all_people_f.person_id%type
779: ,c_employee_type per_all_people_f.current_employee_flag%type
780: ,c_business_group_id hr_all_organization_units.organization_id%type
781: ,c_payroll_id pay_payroll_actions.payroll_id%type
782: ,c_period_end_date date

Line 779: ,c_employee_type per_all_people_f.current_employee_flag%type

775: cursor csr_assignment_payroll_run
776: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
777: ,c_start_person per_all_people_f.person_id%type
778: ,c_end_person per_all_people_f.person_id%type
779: ,c_employee_type per_all_people_f.current_employee_flag%type
780: ,c_business_group_id hr_all_organization_units.organization_id%type
781: ,c_payroll_id pay_payroll_actions.payroll_id%type
782: ,c_period_end_date date
783: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 823: ,c_start_person per_all_people_f.person_id%type

819: --------------------------------------------------------------------+
820:
821: cursor csr_assignment_period
822: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
823: ,c_start_person per_all_people_f.person_id%type
824: ,c_end_person per_all_people_f.person_id%type
825: ,c_employee_type per_all_people_f.current_employee_flag%type
826: ,c_business_group_id hr_all_organization_units.organization_id%type
827: ,c_assignment_id per_all_assignments_f.assignment_id%type

Line 824: ,c_end_person per_all_people_f.person_id%type

820:
821: cursor csr_assignment_period
822: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
823: ,c_start_person per_all_people_f.person_id%type
824: ,c_end_person per_all_people_f.person_id%type
825: ,c_employee_type per_all_people_f.current_employee_flag%type
826: ,c_business_group_id hr_all_organization_units.organization_id%type
827: ,c_assignment_id per_all_assignments_f.assignment_id%type
828: ,c_archive_start_date date

Line 825: ,c_employee_type per_all_people_f.current_employee_flag%type

821: cursor csr_assignment_period
822: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
823: ,c_start_person per_all_people_f.person_id%type
824: ,c_end_person per_all_people_f.person_id%type
825: ,c_employee_type per_all_people_f.current_employee_flag%type
826: ,c_business_group_id hr_all_organization_units.organization_id%type
827: ,c_assignment_id per_all_assignments_f.assignment_id%type
828: ,c_archive_start_date date
829: ,c_archive_end_date date

Line 872: ,c_start_person per_all_people_f.person_id%type

868: --------------------------------------------------------------------+
869:
870: cursor csr_assignment_run
871: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
872: ,c_start_person per_all_people_f.person_id%type
873: ,c_end_person per_all_people_f.person_id%type
874: ,c_employee_type per_all_people_f.current_employee_flag%type
875: ,c_business_group_id hr_all_organization_units.organization_id%type
876: ,c_assignment_id per_all_assignments_f.assignment_id%type

Line 873: ,c_end_person per_all_people_f.person_id%type

869:
870: cursor csr_assignment_run
871: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
872: ,c_start_person per_all_people_f.person_id%type
873: ,c_end_person per_all_people_f.person_id%type
874: ,c_employee_type per_all_people_f.current_employee_flag%type
875: ,c_business_group_id hr_all_organization_units.organization_id%type
876: ,c_assignment_id per_all_assignments_f.assignment_id%type
877: ,c_period_end_date date

Line 874: ,c_employee_type per_all_people_f.current_employee_flag%type

870: cursor csr_assignment_run
871: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
872: ,c_start_person per_all_people_f.person_id%type
873: ,c_end_person per_all_people_f.person_id%type
874: ,c_employee_type per_all_people_f.current_employee_flag%type
875: ,c_business_group_id hr_all_organization_units.organization_id%type
876: ,c_assignment_id per_all_assignments_f.assignment_id%type
877: ,c_period_end_date date
878: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 917: ,c_start_person per_all_people_f.person_id%type

913: --------------------------------------------------------------------+
914:
915: cursor csr_assignment_default_period
916: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
917: ,c_start_person per_all_people_f.person_id%type
918: ,c_end_person per_all_people_f.person_id%type
919: ,c_employee_type per_all_people_f.current_employee_flag%type
920: ,c_business_group_id hr_all_organization_units.organization_id%type
921: ,c_archive_start_date date

Line 918: ,c_end_person per_all_people_f.person_id%type

914:
915: cursor csr_assignment_default_period
916: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
917: ,c_start_person per_all_people_f.person_id%type
918: ,c_end_person per_all_people_f.person_id%type
919: ,c_employee_type per_all_people_f.current_employee_flag%type
920: ,c_business_group_id hr_all_organization_units.organization_id%type
921: ,c_archive_start_date date
922: ,c_archive_end_date date

Line 919: ,c_employee_type per_all_people_f.current_employee_flag%type

915: cursor csr_assignment_default_period
916: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
917: ,c_start_person per_all_people_f.person_id%type
918: ,c_end_person per_all_people_f.person_id%type
919: ,c_employee_type per_all_people_f.current_employee_flag%type
920: ,c_business_group_id hr_all_organization_units.organization_id%type
921: ,c_archive_start_date date
922: ,c_archive_end_date date
923: ) is

Line 964: ,c_start_person per_all_people_f.person_id%type

960: --------------------------------------------------------------------+
961:
962: cursor csr_assignment_default_run
963: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
964: ,c_start_person per_all_people_f.person_id%type
965: ,c_end_person per_all_people_f.person_id%type
966: ,c_employee_type per_all_people_f.current_employee_flag%type
967: ,c_business_group_id hr_all_organization_units.organization_id%type
968: ,c_period_end_date date

Line 965: ,c_end_person per_all_people_f.person_id%type

961:
962: cursor csr_assignment_default_run
963: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
964: ,c_start_person per_all_people_f.person_id%type
965: ,c_end_person per_all_people_f.person_id%type
966: ,c_employee_type per_all_people_f.current_employee_flag%type
967: ,c_business_group_id hr_all_organization_units.organization_id%type
968: ,c_period_end_date date
969: ,c_pact_id pay_payroll_actions.payroll_action_id%type

Line 966: ,c_employee_type per_all_people_f.current_employee_flag%type

962: cursor csr_assignment_default_run
963: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
964: ,c_start_person per_all_people_f.person_id%type
965: ,c_end_person per_all_people_f.person_id%type
966: ,c_employee_type per_all_people_f.current_employee_flag%type
967: ,c_business_group_id hr_all_organization_units.organization_id%type
968: ,c_period_end_date date
969: ,c_pact_id pay_payroll_actions.payroll_action_id%type
970: ) is