APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_SS_APPL_TYP

Line 71: IGS_AD_SS_APPL_TYP AAT,

67: APLINST.US_VERSION_NUMBER, APL.ACAD_CAL_TYPE, UAC.POINT_OF_ENTRY
68: FROM IGS_UC_APP_CHOICES UAC,
69: IGS_UC_APPLICANTS UA,
70: IGS_UC_DEFAULTS UD,
71: IGS_AD_SS_APPL_TYP AAT,
72: IGS_AD_APPL_ALL APL,
73: IGS_AD_PS_APPL_INST_ALL APLINST,
74: IGS_UC_SYS_CALNDRS USC
75: WHERE UAC.APP_NO = CP_APP_NO

Line 322: FROM igs_ad_ss_appl_typ

318: --Cursor to get the Admission Process Category and Admission Process Type for the
319: --Admission Application Type defined for the System in UCAS Setup.
320: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS
321: SELECT admission_cat, s_admission_process_type
322: FROM igs_ad_ss_appl_typ
323: WHERE admission_application_type = cp_application_type
324: AND closed_ind = 'N';
325:
326: l_apc_det_rec cur_apc_det%ROWTYPE;

Line 1500: IGS_AD_SS_APPL_TYP AAT,

1496: APLINST.US_VERSION_NUMBER, APL.ACAD_CAL_TYPE, UAC.POINT_OF_ENTRY
1497: FROM IGS_UC_APP_CHOICES UAC,
1498: IGS_UC_APPLICANTS UA,
1499: IGS_UC_DEFAULTS UD,
1500: IGS_AD_SS_APPL_TYP AAT,
1501: IGS_AD_APPL_ALL APL,
1502: IGS_AD_PS_APPL_INST_ALL APLINST,
1503: IGS_UC_SYS_CALNDRS USC
1504: WHERE UAC.APP_NO = CP_APP_NO