DBA Data[Home] [Help]

APPS.HR_US_FF_UDFS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 3239: pay_element_classifications ECL

3235:
3236: SELECT ECL.classification_name
3237: INTO v_ele_class_name
3238: FROM pay_element_types_f ELT,
3239: pay_element_classifications ECL
3240: WHERE ECL.classification_id = ELT.classification_id
3241: AND ELT.business_group_id + 0 = p_bg_id
3242: AND p_date_earned BETWEEN ELT.effective_start_date
3243: AND ELT.effective_end_date

Line 3336: pay_element_classifications ECL

3332: INTO sepcheck_flag
3333: FROM pay_element_entries_f ELE,
3334: pay_element_links_f ELL,
3335: pay_element_types_f ELT,
3336: pay_element_classifications ECL
3337: WHERE ELE.assignment_id = p_ass_id
3338: AND p_date_earned BETWEEN ELE.effective_start_date
3339: and ELE.effective_end_date
3340: AND ELE.element_link_id = ELL.element_link_id