APPS.IGS_AD_GEN_003 dependencies on IGS_AD_APPL_ALL

Line 802: p_person_id igs_ad_appl_all.person_id%TYPE,

798: END IF;
799: END get_entr_doc_apc;
800:
801: FUNCTION get_core_or_optional_unit (
802: p_person_id igs_ad_appl_all.person_id%TYPE,
803: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE)
804: RETURN VARCHAR2 IS -- (Y, CORE_ONLY, N)
805: /*****************************************************************************************
806: Created By: knag

Line 803: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE)

799: END get_entr_doc_apc;
800:
801: FUNCTION get_core_or_optional_unit (
802: p_person_id igs_ad_appl_all.person_id%TYPE,
803: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE)
804: RETURN VARCHAR2 IS -- (Y, CORE_ONLY, N)
805: /*****************************************************************************************
806: Created By: knag
807: Date Created : 29-OCT-2002

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