DBA Data[Home] [Help]

APPS.PAY_US_CTGY_FEEDS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 216: FROM pay_element_types_f et,

212: --
213: SELECT et.business_group_id, et.effective_start_date,
214: UPPER(ec.classification_name), et.element_information1
215: INTO l_bg_id, l_ele_date, l_ele_classn, l_ele_catgry
216: FROM pay_element_types_f et,
217: pay_element_classifications ec
218: WHERE et.element_type_id = p_element_type_id
219: AND p_date between et.effective_start_date
220: and et.effective_end_date