DBA Data[Home] [Help]

APPS.PA_PAXEXADJ_XMLP_PKG dependencies on PER_PEOPLE_F

Line 54: PER_PEOPLE_F

50: SELECT
51: FULL_NAME
52: INTO P_EMPLOYEE_NAME
53: FROM
54: PER_PEOPLE_F
55: WHERE PERSON_ID = C_PERSON_ID
56: AND sysdate between EFFECTIVE_START_DATE
57: AND NVL(EFFECTIVE_END_DATE
58: ,SYSDATE + 1)