APPS.IGS_AD_PS_APPL_PKG dependencies on IGS_AD_PRCS_CAT_STEP

Line 102: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

98: v_req_adv_standing_allowed_ind VARCHAR2(1);
99:
100:
101: CURSOR c_apcs (
102: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
103: cp_s_admission_process_type
104: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
105: SELECT s_admission_step_type,
106: step_type_restriction_num

Line 104: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

100:
101: CURSOR c_apcs (
102: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
103: cp_s_admission_process_type
104: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
105: SELECT s_admission_step_type,
106: step_type_restriction_num
107: FROM IGS_AD_PRCS_CAT_STEP
108: WHERE admission_cat = cp_admission_cat AND

Line 107: FROM IGS_AD_PRCS_CAT_STEP

103: cp_s_admission_process_type
104: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
105: SELECT s_admission_step_type,
106: step_type_restriction_num
107: FROM IGS_AD_PRCS_CAT_STEP
108: WHERE admission_cat = cp_admission_cat AND
109: s_admission_process_type = cp_s_admission_process_type AND
110: step_group_type <> 'TRACK'; --2402377
111: cst_error CONSTANT VARCHAR2(1):= 'E';