APPS.IGS_EN_GEN_008 dependencies on IGS_PE_PRSID_GRP_MEM

Line 1198: FROM IGS_PE_PRSID_GRP_MEM gm

1194: cst_inactive,
1195: cst_intermit) AND
1196: (p_person_group_id IS NULL OR
1197: EXISTS (SELECT 'x'
1198: FROM IGS_PE_PRSID_GRP_MEM gm
1199: WHERE gm.group_id = p_person_group_id AND
1200: gm.person_id = sca.person_id AND
1201: (gm.end_date IS NULL OR gm.end_date >= trunc(sysdate))AND
1202: (gm.start_date IS NULL OR gm.start_date <= trunc(sysdate)))) AND

Line 1319: FROM IGS_PE_PRSID_GRP_MEM gm

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
1321: gm.person_id = acai.person_id AND
1322: (gm.end_date IS NULL OR gm.end_date >= trunc(sysdate))AND
1323: (gm.start_date IS NULL OR gm.start_date <= trunc(sysdate)) )) AND