APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PAY_PAYROLL_ACTIONS

Line 251: , pay_payroll_actions ppa

247: SELECT MAX(paa.assignment_action_id)
248: FROM pay_assignment_actions paa
249: , per_assignments_f paf
250: , pay_payrolls_f ppf
251: , pay_payroll_actions ppa
252: , per_time_periods ptp
253: WHERE paf.assignment_id = p_assignment_id
254: AND ppa.action_type in ('R','Q')
255: AND p_effective_date BETWEEN paf.effective_start_date

Line 2112: , pay_payroll_actions cur_ppa

2108: , pay_input_values_f input
2109: , pay_run_result_values result
2110: , pay_assignment_actions paa
2111: , pay_assignment_actions cur_paa
2112: , pay_payroll_actions cur_ppa
2113: , pay_element_entries_f entry
2114: , per_time_periods ptp
2115: where runs.element_type_id = p_element_type_id
2116: and input.element_type_id = runs.element_type_id

Line 2270: FROM pay_payroll_actions ppa

2266: CURSOR get_period_assg_act_id(c_time_period_id IN NUMBER)
2267: IS
2268: --
2269: SELECT max(paa.assignment_action_id)
2270: FROM pay_payroll_actions ppa
2271: ,pay_assignment_actions paa
2272: WHERE ppa.payroll_id = p_payroll_id
2273: AND ppa.time_period_id = c_time_period_id
2274: AND ppa.action_type IN ('R','Q')

Line 2545: ,pay_payroll_actions ppa

2541: IS
2542: --
2543: SELECT ptp.start_date
2544: FROM per_time_periods ptp
2545: ,pay_payroll_actions ppa
2546: WHERE ppa.payroll_action_id = p_payroll_action_id
2547: AND ppa.time_period_id = ptp.time_period_id;
2548: --
2549: l_eff_date DATE;