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 661: pay_payroll_actions ppa

657: pay_element_types_f pet,
658: pay_element_links_f pel,
659: pay_element_entries_f pee,
660: pay_assignment_actions paa,
661: pay_payroll_actions ppa
662: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
663: AND pel.element_type_id = pet.element_type_id
664: AND pee.element_link_id = pel.element_link_id
665: AND paa.assignment_id = pee.assignment_id

Line 812: pay_payroll_actions ppa_pre,

808: pay_assignment_actions paa_pre,
809: pay_action_interlocks pai_pre,
810: pay_assignment_actions paa_run,
811: pay_action_interlocks pai_run,
812: pay_payroll_actions ppa_pre,
813: pay_payroll_actions ppa_run,
814: per_time_periods ptp
815: where paa_arch_mst.assignment_action_id = p_master_aa_id
816: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 813: pay_payroll_actions ppa_run,

809: pay_action_interlocks pai_pre,
810: pay_assignment_actions paa_run,
811: pay_action_interlocks pai_run,
812: pay_payroll_actions ppa_pre,
813: pay_payroll_actions ppa_run,
814: per_time_periods ptp
815: where paa_arch_mst.assignment_action_id = p_master_aa_id
816: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
817: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id

Line 844: FROM pay_payroll_actions ppa,

840:
841: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
842: IS
843: SELECT pps.actual_termination_date
844: FROM pay_payroll_actions ppa,
845: pay_assignment_actions paa,
846: per_time_periods ptp,
847: per_all_assignments_f paf,
848: per_periods_of_service pps