DBA Data[Home] [Help]

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;