DBA Data[Home] [Help]

APPS.BEN_EXT_CHLG dependencies on PAY_ELEMENT_TYPES_F

Line 6118: pay_element_types_f et

6114: --
6115: cursor c_get_element_info (p_input_value_id number) is
6116: select iv.name, et.element_name
6117: from pay_input_values_f iv,
6118: pay_element_types_f et
6119: where iv.input_value_id = p_input_value_id
6120: and iv.element_type_id = et.element_type_id
6121: and p_effective_date between iv.effective_start_date and iv.effective_end_date
6122: and p_effective_date between et.effective_start_date and et.effective_end_date;