APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 19: PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

15: -- Major changes were made to the procedure as part of
16: -- fix for bug 3580587
17: --------------------------------------------------------------------+
18:
19: PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
20: p_sql OUT NOCOPY VARCHAR2) IS
21:
22:
23: BEGIN

Line 52: PROCEDURE initialization_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE) IS

48: -- It calls the procedure pay_apac_archive.initialization_code that
49: -- actually sets the global variables and populates the global tables.
50: --------------------------------------------------------------------+
51:
52: PROCEDURE initialization_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE) IS
53:
54:
55: BEGIN
56: hr_utility.set_location('Start of initialization_code',1);

Line 95: PROCEDURE assignment_action_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

91: -- Major changes were made to the procedure as part of
92: -- fix for bug 3580587
93: --------------------------------------------------------------------+
94:
95: PROCEDURE assignment_action_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
96: p_start_person IN per_all_people_f.person_id%TYPE,
97: p_end_person IN per_all_people_f.person_id%TYPE,
98: p_chunk IN NUMBER) IS
99: BEGIN

Line 655: pay_payroll_actions ppa

651: pay_element_types_f pet,
652: pay_element_links_f pel,
653: pay_element_entries_f pee,
654: pay_assignment_actions paa,
655: pay_payroll_actions ppa
656: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
657: AND pel.element_type_id = pet.element_type_id
658: AND pee.element_link_id = pel.element_link_id
659: AND paa.assignment_id = pee.assignment_id

Line 806: pay_payroll_actions ppa_pre,

802: pay_assignment_actions paa_pre,
803: pay_action_interlocks pai_pre,
804: pay_assignment_actions paa_run,
805: pay_action_interlocks pai_run,
806: pay_payroll_actions ppa_pre,
807: pay_payroll_actions ppa_run,
808: per_time_periods ptp
809: where paa_arch_mst.assignment_action_id = p_master_aa_id
810: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 807: pay_payroll_actions ppa_run,

803: pay_action_interlocks pai_pre,
804: pay_assignment_actions paa_run,
805: pay_action_interlocks pai_run,
806: pay_payroll_actions ppa_pre,
807: pay_payroll_actions ppa_run,
808: per_time_periods ptp
809: where paa_arch_mst.assignment_action_id = p_master_aa_id
810: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
811: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id

Line 838: FROM pay_payroll_actions ppa,

834:
835: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
836: IS
837: SELECT pps.actual_termination_date
838: FROM pay_payroll_actions ppa,
839: pay_assignment_actions paa,
840: per_time_periods ptp,
841: per_all_assignments_f paf,
842: per_periods_of_service pps