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

Line 46: ',pay_payroll_actions pa ' ||

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

Line 106: from pay_payroll_actions pa

102: cursor c_assignments (p_payroll_action_id number
103: ,p_start_person_id number
104: ,p_end_person_id number) is
105: select distinct a.assignment_id
106: from pay_payroll_actions pa
107: , per_assignments_f a
108: , pay_element_entries_f ee
109: , pay_element_links_f el
110: , pay_accrual_plans ap

Line 204: l_business_group_id pay_payroll_actions.business_group_id%type ;

200:
201: l_procedure_name varchar2(61) ;
202: l_process_id pay_au_processes.process_id%type ;
203: l_gcc_parameters_store pay_au_generic_code_caller.t_variable_store_tab ;
204: l_business_group_id pay_payroll_actions.business_group_id%type ;
205: l_assignment_id pay_assignment_actions.assignment_id%type ;
206: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
207: l_counter integer := 1 ;
208: l_accrual_category varchar2(15); --temporary variable to check the accrual category.

Line 206: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;

202: l_process_id pay_au_processes.process_id%type ;
203: l_gcc_parameters_store pay_au_generic_code_caller.t_variable_store_tab ;
204: l_business_group_id pay_payroll_actions.business_group_id%type ;
205: l_assignment_id pay_assignment_actions.assignment_id%type ;
206: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
207: l_counter integer := 1 ;
208: l_accrual_category varchar2(15); --temporary variable to check the accrual category.
209:
210: cursor c_process(p_short_name varchar2) is

Line 221: , pay_payroll_actions pa

217: select pa.business_group_id
218: , pa.payroll_action_id
219: , aa.assignment_id
220: from pay_assignment_actions aa
221: , pay_payroll_actions pa
222: where aa.assignment_action_id = p_assignment_action_id
223: and pa.payroll_action_id = aa.payroll_action_id ;
224:
225: cursor c_accrual_plans(p_assignment_action_id number) is

Line 230: , pay_payroll_actions pa

226: select ap.accrual_plan_id
227: , ap.accrual_category
228: , a.payroll_id
229: from pay_assignment_actions aa
230: , pay_payroll_actions pa
231: , per_assignments_f a
232: , pay_element_entries_f ee
233: , pay_element_links_f el
234: , pay_accrual_plans ap