DBA Data[Home] [Help]

APPS.GMS_SECURITY dependencies on GMS_PERSONNEL

Line 252: FROM gms_personnel

248: INTO dummy
249: FROM dual
250: WHERE EXISTS (
251: SELECT NULL
252: FROM gms_personnel
253: WHERE award_id = X_award_id
254: AND person_id = X_person_id
255: AND TRUNC(sysdate) BETWEEN start_date_active
256: AND NVL(end_date_active, sysdate) );