APPS.IGS_TR_VAL_TRST dependencies on IGS_TR_ITEM

Line 23: v_sequence_ind igs_tr_item.sequence_ind%TYPE;

19: BEGIN
20:
21: DECLARE
22:
23: v_sequence_ind igs_tr_item.sequence_ind%TYPE;
24: v_completion_ind NUMBER;
25: -- added for tracking dld in nov 2001 release (bug 1837257)
26: l_override_offset_clc_ind igs_tr_item_all.override_offset_clc_ind%TYPE ;
27: -- modified this cursor to select override_offset_clc_ind which is added

Line 26: l_override_offset_clc_ind igs_tr_item_all.override_offset_clc_ind%TYPE ;

22:
23: v_sequence_ind igs_tr_item.sequence_ind%TYPE;
24: v_completion_ind NUMBER;
25: -- added for tracking dld in nov 2001 release (bug 1837257)
26: l_override_offset_clc_ind igs_tr_item_all.override_offset_clc_ind%TYPE ;
27: -- modified this cursor to select override_offset_clc_ind which is added
28: -- in the tracking dld of nov2001 release
29: CURSOR c_tracking_item( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
30: SELECT sequence_ind , override_offset_clc_ind

Line 29: CURSOR c_tracking_item( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

25: -- added for tracking dld in nov 2001 release (bug 1837257)
26: l_override_offset_clc_ind igs_tr_item_all.override_offset_clc_ind%TYPE ;
27: -- modified this cursor to select override_offset_clc_ind which is added
28: -- in the tracking dld of nov2001 release
29: CURSOR c_tracking_item( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
30: SELECT sequence_ind , override_offset_clc_ind
31: FROM igs_tr_item
32: WHERE tracking_id = cp_tracking_id;
33:

Line 31: FROM igs_tr_item

27: -- modified this cursor to select override_offset_clc_ind which is added
28: -- in the tracking dld of nov2001 release
29: CURSOR c_tracking_item( cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
30: SELECT sequence_ind , override_offset_clc_ind
31: FROM igs_tr_item
32: WHERE tracking_id = cp_tracking_id;
33:
34: -- modified this cursor during tracking dld nov 2001 (bug 1837257)
35: --to include logic for step_group_id