APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_AD_OFR_RESP_STAT

Line 133: igs_ad_ofr_resp_stat aous,

129: acai.*
130: FROM
131: igs_ad_appl aa,
132: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
133: igs_ad_ofr_resp_stat aous,
134: igs_ad_ofrdfrmt_stat aods
135: WHERE
136: aa.person_id = acai.person_id
137: AND aa.admission_appl_number = acai.admission_appl_number

Line 1569: FROM igs_ad_ofr_resp_stat

1565: AND apai.sequence_number = p_sequence_number;
1566:
1567: CURSOR cur_adm_offer_resp_status IS
1568: SELECT adm_offer_resp_status
1569: FROM igs_ad_ofr_resp_stat
1570: WHERE s_adm_offer_resp_status ='ACCEPTED'
1571: AND system_default_ind ='Y';
1572:
1573: -----End cursor Declarations------------------------------------------------------------------