APPS.HXT_BATCH_PROCESS dependencies on PER_ALL_ASSIGNMENTS_F

Line 67: l_assignment_no PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;

63: l_string2 VARCHAR2(5);
64: l_loop_index1 BINARY_INTEGER;
65: l_loop_index2 BINARY_INTEGER;
66: l_proc VARCHAR2(72);
67: l_assignment_no PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;
68: l_parent_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
69: l_batch_type VARCHAR2(10);
70:
71: BEGIN

Line 279: FROM per_all_assignments_f

275: IF l_batch_type in ('Warning', 'Error') THEN
276: BEGIN
277: SELECT assignment_number
278: INTO l_assignment_no
279: FROM per_all_assignments_f
280: WHERE person_id = (SELECT for_person_id
281: FROM hxt_timecards_x
282: WHERE id = p_merge_batches(l_loop_index1).tc_id
283: )