APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_PRSID_GRP_MEM

Line 83: FROM igs_pe_prsid_grp_mem pgm

79: apai.person_id = nvl(p_person_id,apai.person_id) AND
80: -- known person id group
81: (p_person_id_group IS NOT NULL AND
82: apai.person_id IN (SELECT person_id
83: FROM igs_pe_prsid_grp_mem pgm
84: WHERE pgm.group_id = NVL(p_person_id_group,pgm.group_id) AND
85: NVL(TRUNC(pgm.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) AND
86: NVL(TRUNC(pgm.end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE))
87: or

Line 132: FROM igs_pe_prsid_grp_mem pgm

128: apai.person_id = nvl(p_person_id,apai.person_id) AND
129: -- known person id group
130: (p_person_id_group IS NOT NULL AND
131: apai.person_id IN (SELECT person_id
132: FROM igs_pe_prsid_grp_mem pgm
133: WHERE pgm.group_id = NVL(p_person_id_group,pgm.group_id) AND
134: NVL(TRUNC(pgm.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) AND
135: NVL(TRUNC(pgm.end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE))
136: or