APPS.IGS_AD_APPL_PKG dependencies on IGS_AD_PRCS_CAT_STEP

Line 118: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

114: cst_warn CONSTANT VARCHAR2(1) := 'W';
115: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
116:
117: CURSOR c_apcs (
118: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
119: cp_s_admission_process_type
120: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE)
121: IS
122: SELECT s_admission_step_type

Line 120: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE)

116:
117: CURSOR c_apcs (
118: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
119: cp_s_admission_process_type
120: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE)
121: IS
122: SELECT s_admission_step_type
123: FROM IGS_AD_PRCS_CAT_STEP
124: WHERE admission_cat = cp_admission_cat AND

Line 123: FROM IGS_AD_PRCS_CAT_STEP

119: cp_s_admission_process_type
120: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE)
121: IS
122: SELECT s_admission_step_type
123: FROM IGS_AD_PRCS_CAT_STEP
124: WHERE admission_cat = cp_admission_cat AND
125: s_admission_process_type = cp_s_admission_process_type AND
126: step_group_type <> 'TRACK' ;-- 2402377
127: