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_LEAVE_LIABILITY dependencies on PAY_PAYROLL_ACTIONS

Line 45: ',pay_payroll_actions pa ' ||

41: -- required by the PAR process
42:
43: l_sql := 'select distinct p.person_id ' ||
44: 'from per_people_f p ' ||
45: ',pay_payroll_actions pa ' ||
46: ',per_assignments_f a ' ||
47: ',pay_element_entries_f ee ' ||
48: ',pay_element_links_f el ' ||
49: ',pay_accrual_plans ap ' ||

Line 102: from pay_payroll_actions pa

98: cursor c_assignments (p_payroll_action_id number
99: ,p_start_person_id number
100: ,p_end_person_id number) is
101: select distinct a.assignment_id
102: from pay_payroll_actions pa
103: , per_assignments_f a
104: , pay_element_entries_f ee
105: , pay_element_links_f el
106: , pay_accrual_plans ap

Line 193: l_business_group_id pay_payroll_actions.business_group_id%type ;

189:
190: l_procedure_name varchar2(61) := 'pay_nz_leave_liability.archive_code' ;
191: l_process_id pay_au_processes.process_id%type ;
192: l_gcc_parameters_store pay_au_generic_code_caller.t_variable_store_tab ;
193: l_business_group_id pay_payroll_actions.business_group_id%type ;
194: l_assignment_id pay_assignment_actions.assignment_id%type ;
195: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
196: l_counter integer := 1 ;
197:

Line 195: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;

191: l_process_id pay_au_processes.process_id%type ;
192: l_gcc_parameters_store pay_au_generic_code_caller.t_variable_store_tab ;
193: l_business_group_id pay_payroll_actions.business_group_id%type ;
194: l_assignment_id pay_assignment_actions.assignment_id%type ;
195: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
196: l_counter integer := 1 ;
197:
198: cursor c_process(p_short_name varchar2) is
199: select p.process_id

Line 209: , pay_payroll_actions pa

205: select pa.business_group_id
206: , pa.payroll_action_id
207: , aa.assignment_id
208: from pay_assignment_actions aa
209: , pay_payroll_actions pa
210: where aa.assignment_action_id = p_assignment_action_id
211: and pa.payroll_action_id = aa.payroll_action_id ;
212:
213: cursor c_accrual_plans(p_assignment_action_id number) is

Line 217: , pay_payroll_actions pa

213: cursor c_accrual_plans(p_assignment_action_id number) is
214: select ap.accrual_plan_id
215: , a.payroll_id
216: from pay_assignment_actions aa
217: , pay_payroll_actions pa
218: , per_assignments_f a
219: , pay_element_entries_f ee
220: , pay_element_links_f el
221: , pay_accrual_plans ap