APPS.HR_PAY_INTERFACE_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 881: pay_element_links_f pl

877: IF (dummy = 0) THEN
878: SELECT pt.attribute1
879: INTO l_attrib1
880: FROM pay_element_types_f pt,
881: pay_element_links_f pl
882: WHERE
883: pl.element_link_id = g_ele_link_id AND
884: pt.element_type_id = pl.element_type_id AND
885: pt.effective_start_date = (SELECT max(pt2.effective_start_date)

Line 894: FROM pay_element_links_f pt2

890: AND
891: (pt2.element_type_id =
892: pt.element_type_id)) AND
893: pl.effective_start_date = (SELECT max(pt2.effective_start_date)
894: FROM pay_element_links_f pt2
895: WHERE
896: (pt2.effective_start_date <=
897: TRUNC(sysdate))
898: AND