APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_PE_PRSID_GRP_MEM

Line 563: FROM igs_pe_prsid_grp_mem

559: AND aa.APPLICATION_ID = NVL(p_application_id,aa.APPLICATION_ID);
560:
561: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS
562: SELECT 'X'
563: FROM igs_pe_prsid_grp_mem
564: WHERE person_id = p_person_id
565: AND group_id = p_group_id
566: AND NVL(TRUNC(start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE)
567: AND NVL(TRUNC(end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE);