APPS.IGS_AD_GEN_002 dependencies on IGS_AD_PRCS_CAT_STEP

Line 3694: CURSOR c_apcs ( cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

3690: aa.s_admission_process_type
3691: FROM IGS_AD_APPL aa
3692: WHERE aa.person_id = p_person_id AND
3693: aa.admission_appl_number = p_admission_appl_number;
3694: CURSOR c_apcs ( cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
3695: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE
3696: ) IS
3697: SELECT '1'
3698: FROM IGS_AD_PRCS_CAT_STEP

Line 3695: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE

3691: FROM IGS_AD_APPL aa
3692: WHERE aa.person_id = p_person_id AND
3693: aa.admission_appl_number = p_admission_appl_number;
3694: CURSOR c_apcs ( cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
3695: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE
3696: ) IS
3697: SELECT '1'
3698: FROM IGS_AD_PRCS_CAT_STEP
3699: WHERE admission_cat = cp_admission_cat AND

Line 3698: FROM IGS_AD_PRCS_CAT_STEP

3694: CURSOR c_apcs ( cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
3695: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE
3696: ) IS
3697: SELECT '1'
3698: FROM IGS_AD_PRCS_CAT_STEP
3699: WHERE admission_cat = cp_admission_cat AND
3700: s_admission_process_type = cp_s_admission_process_type AND
3701: s_admission_step_type = 'RECONSIDER' AND
3702: step_group_type <> 'TRACK' ;