DBA Data[Home] [Help]

APPS.BEN_ICD_PLAN_DESIGN_SETUP dependencies on PAY_ELEMENT_TYPES_F

Line 36: from pay_element_types_f typ

32: ,typ.effective_end_date
33: ,nvl(typtl.description,typtl.element_name) use_name
34: ,typ.input_currency_code
35: ,typ.processing_type
36: from pay_element_types_f typ
37: ,pay_element_types_f_tl typtl
38: where typ.element_type_id = p_element_type_id
39: and p_effective_date between
40: typ.effective_start_date and typ.effective_end_date

Line 37: ,pay_element_types_f_tl typtl

33: ,nvl(typtl.description,typtl.element_name) use_name
34: ,typ.input_currency_code
35: ,typ.processing_type
36: from pay_element_types_f typ
37: ,pay_element_types_f_tl typtl
38: where typ.element_type_id = p_element_type_id
39: and p_effective_date between
40: typ.effective_start_date and typ.effective_end_date
41: and typ.element_type_id = typtl.element_type_id