DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_AD_GEN_008

Line 1315: IGS_AD_GEN_008.Admp_Get_Saos(acai.adm_outcome_status) IN ('OFFER','COND-OFFER') AND

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
1317: (p_person_group_id is null OR
1318: EXISTS (SELECT 'x'
1319: FROM IGS_PE_PRSID_GRP_MEM gm

Line 1316: IGS_AD_GEN_008.Admp_Get_Saors(acai.adm_offer_resp_status) NOT IN ('LAPSED','REJECTED')) AND

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
1317: (p_person_group_id is null OR
1318: EXISTS (SELECT 'x'
1319: FROM IGS_PE_PRSID_GRP_MEM gm
1320: WHERE gm.group_id = p_person_group_id AND