DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on PER_ALL_ASSIGNMENTS_F

Line 473: l_assignment_no PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;

469: l_string2 VARCHAR2(5);
470: l_loop_index1 BINARY_INTEGER;
471: l_loop_index2 BINARY_INTEGER;
472: l_proc VARCHAR2(72);
473: l_assignment_no PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;
474: l_parent_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
475: l_batch_type VARCHAR2(10);
476:
477:

Line 726: FROM per_all_assignments_f

722: IF l_batch_type in ('Warning', 'Error') THEN
723: BEGIN
724: SELECT assignment_number
725: INTO l_assignment_no
726: FROM per_all_assignments_f
727: WHERE person_id = (SELECT for_person_id
728: FROM hxt_timecards_x
729: WHERE id = p_merge_batches(l_loop_index1).tc_id
730: )