DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on PAY_ELEMENT_SETS

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 80: instead of pay_element_sets.

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
84: new cursor for R12.

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 311: from pay_element_sets els

307: --
308: --
309: cursor get_element_set is
310: select els.element_set_name
311: from pay_element_sets els
312: where els.element_set_id = p_element_set_id ;
313:
314: -- Bug 6353676
315: -- the translated Element Set Name is available in R12 only.

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