DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on PAY_ELEMENT_SETS_TL

Line 79: Cursor get_element_set_name is using pay_element_sets_tl

75: alogue 115.32 26-JUL-2007 Bug 6130796 - check within v_name procedure
76: pay_payroll_actions_pkg.get_char_bindvar('ACTION_TYPE')
77: is same as action_type passed in.
78: mshingan 115.33 21-AUG-2007 Bug 6353676 - Translated element set name is used.
79: Cursor get_element_set_name is using pay_element_sets_tl
80: instead of pay_element_sets.
81: mshingan 115.34 21-AUG-2007 Bug 6353676 - changed declaration of variable l_eltset.
82: mshingan 115.35 22-AUG-2007 Bug 6353676 - Translated element set name functionality
83: is available only in r12 and not in 11i.Hence added

Line 294: l_eltset pay_element_sets_tl.element_set_name%type ;

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;
297:
298: --bug no. 3665606

Line 318: from pay_element_sets_tl pes_tl

314: -- Bug 6353676
315: -- the translated Element Set Name is available in R12 only.
316: cursor get_element_set_r12 is
317: select pes_tl.element_set_name
318: from pay_element_sets_tl pes_tl
319: where pes_tl.element_set_id = p_element_set_id
320: and pes_tl.language = USERENV('LANG');
321: --
322: cursor get_assignment_set is