APPS.PAY_HK_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 66: PROCEDURE initialization_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE) IS

62: -- It calls the procedure pay_apac_archive.initialization_code that
63: -- actually sets the global variables and populates the global tables.
64: --------------------------------------------------------------------+
65:
66: PROCEDURE initialization_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE) IS
67:
68:
69: BEGIN
70: IF g_debug THEN

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

109: -- work.
110: -- The archive will not pickup already archived prepayments.
111: --------------------------------------------------------------------+
112:
113: PROCEDURE assignment_action_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
114: p_start_person IN per_all_people_f.person_id%TYPE,
115: p_end_person IN per_all_people_f.person_id%TYPE,
116: p_chunk IN NUMBER) IS
117:

Line 622: FROM pay_payroll_actions ppa

618:
619: CURSOR csr_get_mpf_date(p_payroll_action_id NUMBER)
620: IS
621: SELECT pay_core_utils.get_parameter('MPF_DUE_DATE',legislative_parameters)
622: FROM pay_payroll_actions ppa
623: WHERE ppa.payroll_action_id = p_payroll_action_id;
624:
625: CURSOR csr_bank_details(p_curr_pymt_ass_act_id NUMBER, l_personal_payment_method_id NUMBER, l_org_payment_method_id NUMBER) /* Bug No : 2672510 */
626: IS

Line 843: pay_payroll_actions ppa

839: pay_element_types_f pet,
840: pay_element_links_f pel,
841: pay_element_entries_f pee,
842: pay_assignment_actions paa,
843: pay_payroll_actions ppa
844: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
845: AND pel.element_type_id = pet.element_type_id
846: AND pee.element_link_id = pel.element_link_id
847: AND paa.assignment_id = pee.assignment_id

Line 1005: pay_payroll_actions ppa_pre,

1001: pay_assignment_actions paa_pre,
1002: pay_action_interlocks pai_pre,
1003: pay_assignment_actions paa_run,
1004: pay_action_interlocks pai_run,
1005: pay_payroll_actions ppa_pre,
1006: pay_payroll_actions ppa_run,
1007: per_time_periods ptp
1008: where paa_arch_mst.assignment_action_id = p_master_aa_id
1009: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 1006: pay_payroll_actions ppa_run,

1002: pay_action_interlocks pai_pre,
1003: pay_assignment_actions paa_run,
1004: pay_action_interlocks pai_run,
1005: pay_payroll_actions ppa_pre,
1006: pay_payroll_actions ppa_run,
1007: per_time_periods ptp
1008: where paa_arch_mst.assignment_action_id = p_master_aa_id
1009: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
1010: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id

Line 1037: FROM pay_payroll_actions ppa,

1033:
1034: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
1035: IS
1036: SELECT pps.actual_termination_date
1037: FROM pay_payroll_actions ppa,
1038: pay_assignment_actions paa,
1039: per_time_periods ptp,
1040: per_all_assignments_f paf,
1041: per_periods_of_service pps