APPS.IGS_EN_TIMESLOTS dependencies on IGS_PE_PERSID_GROUP

Line 285: igs_pe_persid_group pg

281:
282: CURSOR cur_person_grp (p_person_id NUMBER , p_group_cd VARCHAR2 ) IS
283: SELECT pgm.person_id
284: FROM igs_pe_prsid_grp_mem pgm,
285: igs_pe_persid_group pg
286: WHERE pgm.person_id = p_person_id AND
287: pgm.group_id = pg.group_id AND
288: pg.group_cd = p_group_cd
289: AND nvl( pgm.START_DATE,SYSDATE)<= SYSDATE