APPS.AHL_PRD_MTLTXN_PVT dependencies on PER_PEOPLE_F

Line 213: FROM PER_PEOPLE_F

209: AND ENABLED_FLAG = 1;
210: -- query for converting Employee/Recepient to employee_id
211: CURSOR RECEPIENT_CUR (p_recepient_name VARCHAR2) IS
212: SELECT PERSON_ID
213: FROM PER_PEOPLE_F
214: WHERE FULL_NAME = p_recepient_name
215: AND SYSDATE BETWEEN NVL(EFFECTIVE_START_DATE,SYSDATE) AND
216: NVL(EFFECTIVE_END_DATE,SYSDATE);
217: