APPS.HXT_BATCH_VAL dependencies on PAY_ELEMENT_LINKS_F

Line 1216: RETURN pay_element_links_f.element_link_id%TYPE

1212: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
1213: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1214: p_effective_date IN DATE
1215: )
1216: RETURN pay_element_links_f.element_link_id%TYPE
1217: IS
1218: l_proc VARCHAR2 (72) ;
1219: l_element_link_id NUMBER;
1220: BEGIN

Line 1231: FROM per_assignments_f asg, pay_element_links_f el

1227: end if;
1228: BEGIN
1229: SELECT el.element_link_id
1230: INTO l_element_link_id
1231: FROM per_assignments_f asg, pay_element_links_f el
1232: WHERE asg.assignment_id = p_assignment_id
1233: AND el.business_group_id
1234: + 0 = asg.business_group_id
1235: + 0

Line 1314: l_element_link_id pay_element_links_f.element_link_id%TYPE;

1310: RETURN BOOLEAN
1311: IS
1312: l_proc VARCHAR2 (72);
1313: l_element_linked BOOLEAN;
1314: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1315: BEGIN
1316: g_debug :=hr_utility.debug_enabled;
1317: if g_debug then
1318: l_proc := g_package