DBA Data[Home] [Help]

APPS.BEN_EXT_CHLG dependencies on PAY_ELEMENT_TYPES_F

Line 6022: pay_element_types_f et

6018: --
6019: cursor c_get_element_info (p_input_value_id number) is
6020: select iv.name, et.element_name
6021: from pay_input_values_f iv,
6022: pay_element_types_f et
6023: where iv.input_value_id = p_input_value_id
6024: and iv.element_type_id = et.element_type_id
6025: and p_effective_date between iv.effective_start_date and iv.effective_end_date
6026: and p_effective_date between et.effective_start_date and et.effective_end_date;