eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 248: FROM pay_assignment_actions paa

244: (p_assignment_id NUMBER
245: ,p_effective_date DATE
246: ) IS
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

Line 2110: , pay_assignment_actions paa

2106: select to_number(result.result_value)
2107: from pay_run_results runs
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

Line 2111: , pay_assignment_actions cur_paa

2107: from pay_run_results runs
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

Line 2271: ,pay_assignment_actions paa

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')
2275: AND ppa.action_status = 'C'