APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_SS_APPL_TYP

Line 4721: lv_appl_type igs_ad_ss_appl_typ.admission_application_type%TYPE;

4717: lv_cond_disp_name igs_ad_ss_terms.COND_DISP_NAME%type;
4718: lv_cond_disp_txt igs_ad_ss_terms.COND_DISP_TEXT%type;
4719: lv_incl_flag igs_ad_ss_terms.INCLUDE_FLAG%type;
4720: lv_req_flag igs_ad_ss_appl_comps.required_flag%type;
4721: lv_appl_type igs_ad_ss_appl_typ.admission_application_type%TYPE;
4722:
4723: BEGIN
4724:
4725: lv_rowid := '';

Line 4939: TYPE appl_type IS TABLE OF IGS_AD_SS_APPL_TYP.admission_application_type%TYPE INDEX BY BINARY_INTEGER;

4935: FROM IGS_AD_SS_APPL_COMPS
4936: WHERE Admission_application_type = cp_Admission_application_type
4937: AND Page_name = cp_page_code;
4938:
4939: TYPE appl_type IS TABLE OF IGS_AD_SS_APPL_TYP.admission_application_type%TYPE INDEX BY BINARY_INTEGER;
4940: appl_type_table appl_type;
4941:
4942: TYPE ApplCurType IS REF CURSOR;
4943: ssat_cv ApplCurType;

Line 4959: FROM IGS_AD_SS_APPL_TYP

4955:
4956: IF p_appl_type IS NOT NULL THEN
4957: OPEN ssat_cv FOR
4958: SELECT admission_application_type
4959: FROM IGS_AD_SS_APPL_TYP
4960: WHERE
4961: admission_application_type = p_appl_type
4962: AND admission_cat = p_admission_cat
4963: AND s_admission_process_type = p_s_admission_process_type;

Line 4967: FROM IGS_AD_SS_APPL_TYP

4963: AND s_admission_process_type = p_s_admission_process_type;
4964: ELSE
4965: OPEN ssat_cv FOR
4966: SELECT admission_application_type
4967: FROM IGS_AD_SS_APPL_TYP
4968: WHERE
4969: admission_cat = p_admission_cat
4970: AND s_admission_process_type = p_s_admission_process_type;
4971: END IF;