DBA Data[Home] [Help]

APPS.HR_CA_FF_UDFS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 2934: pay_element_classifications ECL

2930:
2931: SELECT ECL.classification_name
2932: INTO v_ele_class_name
2933: FROM pay_element_types_f ELT,
2934: pay_element_classifications ECL
2935: WHERE ECL.classification_id = ELT.classification_id
2936: AND ELT.business_group_id + 0 = p_bg_id
2937: AND p_date_earned
2938: BETWEEN ELT.effective_start_date

Line 3028: pay_element_classifications ECL

3024: INTO sepcheck_flag
3025: FROM pay_element_entries_f ELE,
3026: pay_element_links_f ELL,
3027: pay_element_types_f ELT,
3028: pay_element_classifications ECL
3029: WHERE ELE.assignment_id = p_ass_id
3030: AND p_date_earned BETWEEN
3031: ELE.effective_start_date and ELE.effective_end_date
3032: AND ELE.element_link_id = ELL.element_link_id