APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on IGS_AD_PRCS_CAT_STEP

Line 220: CURSOR c_apcs (cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,

216: -- Who When What
217: -- rboddu 11/17/2003 Added p_prpsd_commencement_date and related validations. Bug:3181590
218: ---------------------------------------------------------------------------------------------------------------------------------------
219:
220: CURSOR c_apcs (cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
221: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE) IS
222: SELECT s_admission_step_type,
223: step_type_restriction_num
224: FROM igs_ad_prcs_cat_step

Line 221: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE) IS

217: -- rboddu 11/17/2003 Added p_prpsd_commencement_date and related validations. Bug:3181590
218: ---------------------------------------------------------------------------------------------------------------------------------------
219:
220: CURSOR c_apcs (cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
221: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE) IS
222: SELECT s_admission_step_type,
223: step_type_restriction_num
224: FROM igs_ad_prcs_cat_step
225: WHERE admission_cat = cp_admission_cat AND

Line 224: FROM igs_ad_prcs_cat_step

220: CURSOR c_apcs (cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
221: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE) IS
222: SELECT s_admission_step_type,
223: step_type_restriction_num
224: FROM igs_ad_prcs_cat_step
225: WHERE admission_cat = cp_admission_cat AND
226: s_admission_process_type = cp_s_admission_process_type AND
227: step_group_type <> 'TRACK' ;
228: