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 623: FROM pay_payroll_actions ppa

619:
620: CURSOR csr_get_mpf_date(p_payroll_action_id NUMBER)
621: IS
622: SELECT pay_core_utils.get_parameter('MPF_DUE_DATE',legislative_parameters)
623: FROM pay_payroll_actions ppa
624: WHERE ppa.payroll_action_id = p_payroll_action_id;
625:
626: 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 */
627: IS

Line 844: pay_payroll_actions ppa

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

Line 1006: pay_payroll_actions ppa_pre,

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

Line 1007: pay_payroll_actions ppa_run,

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

Line 1038: FROM pay_payroll_actions ppa,

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