APPS.IGS_AS_GEN_007 dependencies on IGS_TR_STEP_V

Line 64: v_tsdv_action_dt igs_tr_step_v.action_dt%TYPE;

60: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
61: v_tracking_id igs_tr_item.tracking_id%TYPE;
62: v_tri_start_dt igs_tr_item.start_dt%TYPE;
63: v_tri_business_days_ind igs_tr_item.business_days_ind%TYPE;
64: v_tsdv_action_dt igs_tr_step_v.action_dt%TYPE;
65: v_target_days NUMBER (3);
66: v_other_detail VARCHAR2 (255);
67: cst_enrolled CONSTANT VARCHAR2 (10) := 'ENROLLED';
68:

Line 189: FROM igs_tr_step_v

185: WHERE tracking_id = cp_tracking_id;
186: --
187: CURSOR c_tsdv (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
188: SELECT MAX (action_dt)
189: FROM igs_tr_step_v
190: WHERE tracking_id = cp_tracking_id;
191: --
192: CURSOR c_tri_upd (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
193: SELECT ROWID,