APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 186: from pay_assignment_actions

182: l_dummy number ;
183: --
184: cursor c1 is
185: select 1
186: from pay_assignment_actions
187: where payroll_action_id = p_payroll_action_id
188: and action_status in ('E','M','U');
189: --
190: cursor c2 is

Line 334: (aac PAY_ASSIGNMENT_ACTIONS_N50,

330: where ppa.payroll_action_id = p_payroll_action_id;
331: --
332: cursor get_person_name is
333: select /*+ INDEX
334: (aac PAY_ASSIGNMENT_ACTIONS_N50,
335: peo PER_PEOPLE_F_PK,
336: asg PER_ASSIGNMENTS_F_PK)
337: USE_NL(aac, peo, asg) */
338: peo.full_name

Line 341: from pay_assignment_actions aac,

337: USE_NL(aac, peo, asg) */
338: peo.full_name
339: ,pac.element_type_id --bug no. 3665606
340: ,pac.legislative_parameters --bug no. 3665606
341: from pay_assignment_actions aac,
342: pay_payroll_actions pac,
343: per_all_people_f peo,
344: per_all_assignments_f asg
345: where pac.payroll_action_id = p_payroll_action_id

Line 361: pay_assignment_actions aac,

357: INDEX(rrs PAY_RUN_RESULTS_N50)
358: USE_NL(rrs)*/
359: tl.element_name
360: from pay_payroll_actions pac,
361: pay_assignment_actions aac,
362: pay_run_results rrs,
363: pay_element_types_f ety,
364: pay_element_types_f_tl tl
365: where pac.payroll_action_id = p_payroll_action_id