APPS.IGS_TR_VAL_TRST dependencies on IGS_TR_TYPE

Line 210: l_s_tracking_type igs_tr_type.s_tracking_type%TYPE;

206: Modified the cursor to validate system tracking step type within the tracking type.
207: */
208: gv_other_detail VARCHAR(255);
209: lv_param_values VARCHAR2(1080);
210: l_s_tracking_type igs_tr_type.s_tracking_type%TYPE;
211: l_dummy VARCHAR2(1);
212:
213: CURSOR tracking_type_cur IS
214: SELECT s_tracking_type

Line 215: FROM igs_tr_type

211: l_dummy VARCHAR2(1);
212:
213: CURSOR tracking_type_cur IS
214: SELECT s_tracking_type
215: FROM igs_tr_type
216: WHERE tracking_type = p_tracking_type;
217:
218: CURSOR step_type_cur(cp_s_tracking_type igs_tr_type.s_tracking_type%TYPE) IS
219: SELECT 'X'

Line 218: CURSOR step_type_cur(cp_s_tracking_type igs_tr_type.s_tracking_type%TYPE) IS

214: SELECT s_tracking_type
215: FROM igs_tr_type
216: WHERE tracking_type = p_tracking_type;
217:
218: CURSOR step_type_cur(cp_s_tracking_type igs_tr_type.s_tracking_type%TYPE) IS
219: SELECT 'X'
220: FROM igs_lookup_values
221: WHERE lookup_type = p_s_tracking_step_type AND
222: lookup_code = cp_s_tracking_type;