APPS.PAY_PROCESSING_RULE_DATA_PUMP dependencies on PAY_ELEMENT_TYPES_F

Line 33: l_element_type_id pay_element_types_f.element_type_id%type;

29: ,p_effective_date in date
30: )
31: return number is
32: --
33: l_element_type_id pay_element_types_f.element_type_id%type;
34: --
35: Begin
36:
37:

Line 40: from pay_element_types_f et,

36:
37:
38: select et.element_type_id
39: into l_element_type_id
40: from pay_element_types_f et,
41: pay_element_types_f_tl et_tl
42: where et_tl.element_type_id = et.element_type_id
43: and et_tl.element_name = p_element_name
44: and p_effective_date between et.effective_start_date and

Line 41: pay_element_types_f_tl et_tl

37:
38: select et.element_type_id
39: into l_element_type_id
40: from pay_element_types_f et,
41: pay_element_types_f_tl et_tl
42: where et_tl.element_type_id = et.element_type_id
43: and et_tl.element_name = p_element_name
44: and p_effective_date between et.effective_start_date and
45: et.effective_end_date