APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_APPL_ALL

Line 72: IGS_AD_APPL_ALL APL,

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
76: AND UAC.CHOICE_NO = CP_CHOICE_NO

Line 109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,

105: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
106: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
107: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
108: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
109: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
110: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
111: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
112: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
113: p_point_of_entry igs_uc_app_choices.point_of_entry%TYPE

Line 1501: IGS_AD_APPL_ALL APL,

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
1505: AND UAC.CHOICE_NO = CP_CHOICE_NO

Line 1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,

1534: p_unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
1535: p_us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
1536: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1537: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
1538: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
1539: p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
1540: p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
1541: p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
1542: p_point_of_entry igs_uc_app_choices.point_of_entry%TYPE