DBA Data[Home] [Help]

APPS.HR_CA_FF_UDFS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 2897: pay_element_classifications ECL

2893:
2894: SELECT ECL.classification_name
2895: INTO v_ele_class_name
2896: FROM pay_element_types_f ELT,
2897: pay_element_classifications ECL
2898: WHERE ECL.classification_id = ELT.classification_id
2899: AND ELT.business_group_id + 0 = p_bg_id
2900: AND p_date_earned
2901: BETWEEN ELT.effective_start_date

Line 2991: pay_element_classifications ECL

2987: INTO sepcheck_flag
2988: FROM pay_element_entries_f ELE,
2989: pay_element_links_f ELL,
2990: pay_element_types_f ELT,
2991: pay_element_classifications ECL
2992: WHERE ELE.assignment_id = p_ass_id
2993: AND p_date_earned BETWEEN
2994: ELE.effective_start_date and ELE.effective_end_date
2995: AND ELE.element_link_id = ELL.element_link_id