DBA Data[Home] [Help]

APPS.PJM_COMMITMENT_UTILS dependencies on PER_ALL_PEOPLE_F

Line 350: from PER_ALL_PEOPLE_F

346:
347: BEGIN
348:
349: SELECT full_name into L_Full_Name
350: from PER_ALL_PEOPLE_F
351: where person_id = X_Person_Id
352: AND TRUNC(SYSDATE) BETWEEN NVL(EFFECTIVE_START_DATE, SYSDATE - 1)
353: AND NVL(EFFECTIVE_END_DATE, SYSDATE + 1);
354: