DBA Data[Home] [Help]

APPS.IGS_AD_IMP_UH_TST_PKG dependencies on IGS_PE_PRSID_GRP_MEM

Line 16: FROM igs_pe_prsid_grp_mem pgm

12:
13:
14: CURSOR c_person_cur(cp_group_id NUMBER) IS
15: SELECT pgm.person_id
16: FROM igs_pe_prsid_grp_mem pgm
17: WHERE pgm.group_id = cp_group_id AND
18: NVL(TRUNC(pgm.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) AND
19: NVL(TRUNC(pgm.end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
20: