APPS.AHL_PRD_MTLTXN_PVT dependencies on PER_PEOPLE_F
Line 202: FROM PER_PEOPLE_F
198: AND ENABLED_FLAG = 1;
199: -- query for converting Employee/Recepient to employee_id
200: CURSOR RECEPIENT_CUR (p_recepient_name VARCHAR2) IS
201: SELECT PERSON_ID 202: FROM PER_PEOPLE_F 203: WHERE FULL_NAME = p_recepient_name
204: AND SYSDATE BETWEEN NVL(EFFECTIVE_START_DATE,SYSDATE) AND
205: NVL(EFFECTIVE_END_DATE,SYSDATE);
206: