DBA Data[Home] [Help]

APPS.PQH_PQHUSEPR_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 130: PER_ALL_PEOPLE_F

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