DBA Data[Home] [Help]

APPS.IGS_AD_GEN_011 dependencies on IGS_PE_PRSID_GRP_MEM_V

Line 1250: FROM igs_pe_prsid_grp_mem_v

1246: CURSOR cur_person_ids (
1247: cp_person_id_group IN igs_pe_persid_group_all.group_id%TYPE
1248: ) IS
1249: SELECT person_id
1250: FROM igs_pe_prsid_grp_mem_v
1251: WHERE group_id = cp_person_id_group AND
1252: NVL(TRUNC(start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) AND
1253: NVL(TRUNC(end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
1254: BEGIN