APPS.PAY_NZ_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: -- It calls pay_apac_payslip_archive.range_code that archives the EIT
16: -- definition and payroll level data (Messages, employer address details etc)
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 61: PROCEDURE initialization_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE) IS

57: -- It calls the procedure pay_apac_archive.initialization_code that
58: -- actually sets the global variables and populates the global tables.
59: --------------------------------------------------------------------+
60:
61: PROCEDURE initialization_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE) IS
62:
63:
64: BEGIN
65:

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

99: -- work for NZ.
100: -- The archive will not pickup already archived prepayments.
101: --------------------------------------------------------------------+
102:
103: PROCEDURE assignment_action_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
104: p_start_person IN per_all_people_f.person_id%TYPE,
105: p_end_person IN per_all_people_f.person_id%TYPE,
106: p_chunk IN NUMBER) IS
107:

Line 656: pay_payroll_actions ppa

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

Line 898: ,pay_payroll_actions ppa_pre

894: ,pay_assignment_actions paa_pre
895: ,pay_action_interlocks pai_pre
896: ,pay_assignment_actions paa_run
897: ,pay_action_interlocks pai_run
898: ,pay_payroll_actions ppa_pre
899: ,pay_payroll_actions ppa_run
900: ,per_time_periods ptp
901: ,per_business_groups pbg
902: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id

Line 899: ,pay_payroll_actions ppa_run

895: ,pay_action_interlocks pai_pre
896: ,pay_assignment_actions paa_run
897: ,pay_action_interlocks pai_run
898: ,pay_payroll_actions ppa_pre
899: ,pay_payroll_actions ppa_run
900: ,per_time_periods ptp
901: ,per_business_groups pbg
902: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
903: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 936: FROM pay_payroll_actions ppa,

932:
933: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
934: IS
935: SELECT pps.actual_termination_date
936: FROM pay_payroll_actions ppa,
937: pay_assignment_actions paa,
938: per_time_periods ptp,
939: per_all_assignments_f paf,
940: per_periods_of_service pps