DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 292: l_element_name pay_element_types_f_tl.element_name%type;

288: p_assignment_set_id in number,
289: p_effective_date in date,
290: p_force in boolean ) return varchar2 is
291: l_status varchar2(2000) ;
292: l_element_name pay_element_types_f_tl.element_name%type;
293: l_asset hr_assignment_sets.assignment_set_name%type ;
294: l_eltset pay_element_sets_tl.element_set_name%type ;
295: l_dummy number ;
296: l_report_type pay_payroll_actions.report_type%type;

Line 363: pay_element_types_f ety,

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
366: and aac.payroll_action_id = pac.payroll_action_id
367: and aac.assignment_action_id = rrs.assignment_action_id

Line 364: pay_element_types_f_tl tl

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
366: and aac.payroll_action_id = pac.payroll_action_id
367: and aac.assignment_action_id = rrs.assignment_action_id
368: and rrs.element_type_id = ety.element_type_id