DBA Data[Home] [Help]

APPS.PAY_FRR_DATA_PUMP dependencies on PAY_ELEMENT_TYPES_F

Line 15: l_element_type_id pay_element_types_f.element_type_id%type;

11: ,p_language_code in varchar2
12: )
13: return number is
14: --
15: l_element_type_id pay_element_types_f.element_type_id%type;
16: --
17: Begin
18: select et.element_type_id
19: into l_element_type_id

Line 20: from pay_element_types_f et,

16: --
17: Begin
18: select et.element_type_id
19: into l_element_type_id
20: from pay_element_types_f et,
21: pay_element_types_f_tl et_tl
22: where et_tl.element_name = p_element_name
23: and (et.business_group_id + 0 = p_business_group_id
24: or (et.business_group_id is null

Line 21: pay_element_types_f_tl et_tl

17: Begin
18: select et.element_type_id
19: into l_element_type_id
20: from pay_element_types_f et,
21: pay_element_types_f_tl et_tl
22: where et_tl.element_name = p_element_name
23: and (et.business_group_id + 0 = p_business_group_id
24: or (et.business_group_id is null
25: and et.legislation_code = hr_api.return_legislation_code(p_business_group_id)

Line 150: l_element_type_id pay_element_types_f.element_type_id%type;

146: ,p_language_code in varchar2
147: )
148: return number is
149: --
150: l_element_type_id pay_element_types_f.element_type_id%type;
151: --
152: Begin
153: l_element_type_id := get_source_element_type_id
154: (p_element_name