APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_PRCS_CAT_STEP

Line 2121: cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,

2117:
2118: c_admcat_rec c_admcat_cur%ROWTYPE;
2119:
2120: CURSOR c_apcs_cur (
2121: cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
2122: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE
2123: )
2124: IS
2125: SELECT

Line 2122: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE

2118: c_admcat_rec c_admcat_cur%ROWTYPE;
2119:
2120: CURSOR c_apcs_cur (
2121: cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
2122: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE
2123: )
2124: IS
2125: SELECT
2126: s_admission_step_type, step_type_restriction_num

Line 2128: igs_ad_prcs_cat_step

2124: IS
2125: SELECT
2126: s_admission_step_type, step_type_restriction_num
2127: FROM
2128: igs_ad_prcs_cat_step
2129: WHERE
2130: admission_cat = cp_admission_cat
2131: AND s_admission_process_type = cp_s_admission_process_type
2132: AND step_group_type <> 'TRACK';