DBA Data[Home] [Help]

APPS.PQH_PQHUSRCP_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 132: PER_ALL_PEOPLE_F

128: CURSOR MGR_NM_CUR IS
129: SELECT
130: LAST_NAME || ', ' || FIRST_NAME
131: FROM
132: PER_ALL_PEOPLE_F
133: WHERE PERSON_ID = P_MANAGER_ID
134: AND sysdate between EFFECTIVE_START_DATE
135: AND EFFECTIVE_END_DATE;
136: L_MANAGER_NM VARCHAR2(240);