APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_PE_PRSID_GRP_MEM

Line 160: FROM igs_pe_prsid_grp_mem

156: c_appl_inst_rec c_appl_inst%ROWTYPE;
157:
158: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS
159: SELECT 'X'
160: FROM igs_pe_prsid_grp_mem
161: WHERE person_id = p_person_id
162: AND group_id = p_group_id
163: AND NVL(TRUNC(start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE)
164: AND NVL(TRUNC(end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE);