APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

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

14: -- This common 'pay_apac_payslip_archive.range_code' procedure takes
15: -- care of the actual archival of EIT's data
16: ********************************************************************************/
17:
18: PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
19: ,sqlstr OUT NOCOPY VARCHAR2)
20: IS
21: BEGIN
22:

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

49: -- balance and elements values into global tables, because as it is multi-threaded
50: -- procedure(actual archival of EIT's data is not done from this procedure)
51: ********************************************************************************/
52:
53: PROCEDURE initialization_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE)
54: IS
55:
56: -- cursor to get the archival effective_date
57:

Line 61: FROM pay_payroll_actions ppa

57:
58: CURSOR csr_archive_effective_date(p_payroll_action_id NUMBER)
59: IS
60: SELECT ppa.effective_date
61: FROM pay_payroll_actions ppa
62: WHERE ppa.payroll_action_id = p_payroll_action_id;
63:
64: BEGIN
65:

Line 229: ,pay_payroll_actions ppa

225: ,hoi.org_information13 leave_taken_dim
226: ,pac.assignment_id
227: FROM pay_accrual_plans pap
228: ,pay_assignment_actions pac
229: ,pay_payroll_actions ppa
230: ,hr_organization_information hoi
231: ,pay_element_links_f pel
232: ,pay_element_entries_f pee
233: ,pay_element_types_f pet

Line 718: pay_payroll_actions ppa_pre,

714: pay_assignment_actions paa_pre,
715: pay_action_interlocks pai_pre,
716: pay_assignment_actions paa_run,
717: pay_action_interlocks pai_run,
718: pay_payroll_actions ppa_pre,
719: pay_payroll_actions ppa_run,
720: per_time_periods ptp
721: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
722: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 719: pay_payroll_actions ppa_run,

715: pay_action_interlocks pai_pre,
716: pay_assignment_actions paa_run,
717: pay_action_interlocks pai_run,
718: pay_payroll_actions ppa_pre,
719: pay_payroll_actions ppa_run,
720: per_time_periods ptp
721: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
722: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
723: AND paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id

Line 752: ,pay_payroll_actions ppa

748: SELECT ptp.end_date end_date,
749: ptp.regular_payment_date regular_payment_date,
750: ptp.time_period_id time_period_id
751: FROM per_time_periods ptp
752: ,pay_payroll_actions ppa
753: WHERE ptp.payroll_id = ppa.payroll_id
754: AND ppa.payroll_action_id = ( SELECT payroll_action_id
755: FROM pay_assignment_actions
756: WHERE assignment_action_id =p_assignment_action_id)

Line 767: pay_payroll_actions ppa

763: FROM per_all_assignments_f paf,
764: per_periods_of_service pps,
765: pay_assignment_actions paa,
766: per_time_periods ptp,
767: pay_payroll_actions ppa
768: WHERE paa.assignment_action_id = p_assignment_action_id
769: AND ptp.payroll_id = ppa.payroll_id
770: AND paf.assignment_id = paa.assignment_id
771: AND ppa.payroll_action_id = paa.payroll_action_id