DBA Data[Home] [Help]

APPS.PAY_ITERATE dependencies on PAY_ELEMENT_TYPES_F

Line 3113: from pay_element_types_f pet

3109: -- Get the element_type_id
3110: --
3111: select pet.element_type_id
3112: into l_in_et_id
3113: from pay_element_types_f pet
3114: where UPPER(pet.element_name) = p_element_name
3115: and p_effective_start_date between pet.effective_start_date
3116: and pet.effective_end_date
3117: and ((p_et_bg_name is not null