DBA Data[Home] [Help]

APPS.HR_US_FF_UDFS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 3248: pay_element_classifications ECL

3244:
3245: SELECT ECL.classification_name
3246: INTO v_ele_class_name
3247: FROM pay_element_types_f ELT,
3248: pay_element_classifications ECL
3249: WHERE ECL.classification_id = ELT.classification_id
3250: AND ELT.business_group_id + 0 = p_bg_id
3251: AND p_date_earned BETWEEN ELT.effective_start_date
3252: AND ELT.effective_end_date

Line 3345: pay_element_classifications ECL

3341: INTO sepcheck_flag
3342: FROM pay_element_entries_f ELE,
3343: pay_element_links_f ELL,
3344: pay_element_types_f ELT,
3345: pay_element_classifications ECL
3346: WHERE ELE.assignment_id = p_ass_id
3347: AND p_date_earned BETWEEN ELE.effective_start_date
3348: and ELE.effective_end_date
3349: AND ELE.element_link_id = ELL.element_link_id