DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_AD_OFR_RESP_STAT

Line 1312: IGS_AD_OFR_RESP_STAT rs

1308: ( NVL(acai.adm_cal_type,aa.adm_cal_type) = p_adm_cal_type AND
1309: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) = p_adm_sequence_number) ) AND
1310: EXISTS( SELECT 'X'
1311: FROM IGS_AD_OU_STAT os,
1312: IGS_AD_OFR_RESP_STAT rs
1313: WHERE os.adm_outcome_status = acai.adm_outcome_status AND
1314: rs.adm_offer_resp_status = acai.adm_offer_resp_status AND
1315: IGS_AD_GEN_008.Admp_Get_Saos(acai.adm_outcome_status) IN ('OFFER','COND-OFFER') AND
1316: IGS_AD_GEN_008.Admp_Get_Saors(acai.adm_offer_resp_status) NOT IN ('LAPSED','REJECTED')) AND