APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_SS_APPL_TYP

Line 1214: FROM igs_ad_ss_appl_typ

1210: --Cursor to get the Admission Process Category and Admission Process Type for the
1211: --Admission Application Type defined for the System in UCAS Setup.
1212: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS
1213: SELECT admission_cat, s_admission_process_type
1214: FROM igs_ad_ss_appl_typ
1215: WHERE admission_application_type = cp_application_type
1216: AND closed_ind = 'N';
1217:
1218: l_apc_det_rec cur_apc_det%ROWTYPE;

Line 2702: CURSOR cur_prcs_cat_step (cp_admission_cat igs_ad_ss_appl_typ.admission_cat%TYPE,

2698:
2699: l_sys_entry_cal_det_rec cur_sys_entry_cal_det%ROWTYPE;
2700:
2701: --Cursor to check whether APC defined for the System includes the step "Reconsideration" or not.
2702: CURSOR cur_prcs_cat_step (cp_admission_cat igs_ad_ss_appl_typ.admission_cat%TYPE,
2703: cp_s_admission_process_type igs_ad_ss_appl_typ.s_admission_process_type%TYPE ) IS
2704: SELECT 'X'
2705: FROM igs_ad_prcs_cat_step
2706: WHERE admission_cat = cp_admission_cat

Line 2703: cp_s_admission_process_type igs_ad_ss_appl_typ.s_admission_process_type%TYPE ) IS

2699: l_sys_entry_cal_det_rec cur_sys_entry_cal_det%ROWTYPE;
2700:
2701: --Cursor to check whether APC defined for the System includes the step "Reconsideration" or not.
2702: CURSOR cur_prcs_cat_step (cp_admission_cat igs_ad_ss_appl_typ.admission_cat%TYPE,
2703: cp_s_admission_process_type igs_ad_ss_appl_typ.s_admission_process_type%TYPE ) IS
2704: SELECT 'X'
2705: FROM igs_ad_prcs_cat_step
2706: WHERE admission_cat = cp_admission_cat
2707: AND s_admission_process_type = cp_s_admission_process_type

Line 2716: FROM igs_ad_ss_appl_typ

2712: --Cursor to get the Admission Process Category and Admission Process Type for the
2713: --Admission Application Type defined for the System in UCAS Setup.
2714: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS
2715: SELECT admission_cat, s_admission_process_type
2716: FROM igs_ad_ss_appl_typ
2717: WHERE admission_application_type = cp_application_type
2718: AND closed_ind = 'N';
2719:
2720: l_apc_det_rec cur_apc_det%ROWTYPE;