DBA Data[Home] [Help]

APPS.PQP_FEDHR_USPAY_INT_UTILS dependencies on PAY_ELEMENT_LINKS_F

Line 523: pay_element_links_f eli

519: CURSOR cur_ele_link_in_biz(p_ele_name VARCHAR2, p_business_group_id IN NUMBER)
520: IS
521: SELECT DISTINCT eli.element_link_id link_id
522: FROM pay_element_types_f elt,
523: pay_element_links_f eli
524: WHERE elt.element_type_id = eli.element_type_id
525: AND UPPER(elt.element_name) = UPPER(p_ele_name)
526: AND eli.business_group_id = p_business_group_id
527: AND elt.business_group_id = p_business_group_id;

Line 535: pay_element_links_f eli

531: p_business_group_id IN NUMBER)
532: IS
533: SELECT DISTINCT eli.element_link_id link_id
534: FROM pay_element_types_f elt,
535: pay_element_links_f eli
536: WHERE elt.element_type_id = eli.element_type_id
537: AND UPPER(elt.element_name) = UPPER(p_ele_name)
538: AND elt.business_group_id IS NULL
539: AND elt.legislation_code = p_legislation_code