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_ASSIGNMENT_ACTIONS

Line 131: select pay_assignment_actions_s.nextval

127: and pa.effective_date between el.effective_start_date
128: and el.effective_end_date ;
129:
130: cursor c_assignment_action_id is
131: select pay_assignment_actions_s.nextval
132: from dual ;
133:
134: begin
135:

Line 205: l_assignment_id pay_assignment_actions.assignment_id%type ;

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.
209:

Line 220: from pay_assignment_actions aa

216: cursor c_action(p_assignment_action_id number) is
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:

Line 229: from pay_assignment_actions aa

225: cursor c_accrual_plans(p_assignment_action_id number) is
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