APPS.IGS_FI_AD_HOC_WAV dependencies on IGS_PE_PRSID_GRP_MEM
Line 286: FROM igs_pe_prsid_grp_mem
282: l_v_cal_per VARCHAR2(1);
283:
284: CURSOR c_pers_group (cp_person_grp igs_pe_persid_group_v.group_id%TYPE) IS
285: SELECT person_id 286: FROM igs_pe_prsid_grp_mem 287: WHERE group_id = cp_person_grp
288: AND (start_date <= TRUNC(SYSDATE) OR start_date IS NULL)
289: AND (end_date >= TRUNC(SYSDATE) OR end_date IS NULL)
290: ORDER BY 1;