APPS.IGS_AD_GEN_003 dependencies on IGS_AD_PRCS_CAT_STEP_ALL

Line 817: FROM igs_ad_prcs_cat_step_all apcs, igs_ad_appl_all appl

813: *****************************************************************************************/
814: -- will fetch first CORE_OPTIONAL then CORE if both present
815: CURSOR c_get_core_or_optional_unit IS
816: SELECT apcs.s_admission_step_type
817: FROM igs_ad_prcs_cat_step_all apcs, igs_ad_appl_all appl
818: WHERE appl.person_id = p_person_id
819: AND appl.admission_appl_number = p_admission_appl_number
820: AND apcs.admission_cat = appl.admission_cat
821: AND apcs.s_admission_process_type = appl.s_admission_process_type

Line 826: l_s_admission_step_type igs_ad_prcs_cat_step_all.s_admission_step_type%TYPE;

822: AND apcs.step_group_type = 'UNIT-VAL'
823: AND apcs.s_admission_step_type IN ('CORE','CORE_OPTIONAL')
824: ORDER BY apcs.s_admission_step_type desc;
825:
826: l_s_admission_step_type igs_ad_prcs_cat_step_all.s_admission_step_type%TYPE;
827: BEGIN
828: IF p_person_id IS NOT NULL AND p_admission_appl_number IS NOT NULL THEN
829: OPEN c_get_core_or_optional_unit;
830: FETCH c_get_core_or_optional_unit INTO l_s_admission_step_type;