APPS.PO_FED_FIELD_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 376: (SELECT PHONE_NUMBER FROM PER_PHONES WHERE parent_table = 'PER_ALL_PEOPLE_F' and phone_type = 'W1'

372: l_cnt_concat_s := '';
373: l_cnt_concat_l := '';
374:
375: SELECT PERSON_ID,FIRST_NAME,LAST_NAME,TITLE,FULL_NAME,EMAIL_ADDRESS,
376: (SELECT PHONE_NUMBER FROM PER_PHONES WHERE parent_table = 'PER_ALL_PEOPLE_F' and phone_type = 'W1'
377: and parent_id = person_id and SYSDATE BETWEEN Nvl(date_from,SYSDATE) AND Nvl(date_to,SYSDATE )) WORK_TELEPHONE
378: INTO l_PERSON_ID,l_FIRST_NAME,l_LAST_NAME,l_TITLE,l_FULL_NAME,l_EMAIL_ADDRESS, l_WORK_TELEPHONE
379: FROM PER_ALL_PEOPLE_F
380: WHERE PERSON_ID = contact

Line 379: FROM PER_ALL_PEOPLE_F

375: SELECT PERSON_ID,FIRST_NAME,LAST_NAME,TITLE,FULL_NAME,EMAIL_ADDRESS,
376: (SELECT PHONE_NUMBER FROM PER_PHONES WHERE parent_table = 'PER_ALL_PEOPLE_F' and phone_type = 'W1'
377: and parent_id = person_id and SYSDATE BETWEEN Nvl(date_from,SYSDATE) AND Nvl(date_to,SYSDATE )) WORK_TELEPHONE
378: INTO l_PERSON_ID,l_FIRST_NAME,l_LAST_NAME,l_TITLE,l_FULL_NAME,l_EMAIL_ADDRESS, l_WORK_TELEPHONE
379: FROM PER_ALL_PEOPLE_F
380: WHERE PERSON_ID = contact
381: AND SYSDATE BETWEEN Nvl(EFFECTIVE_START_DATE,SYSDATE) AND Nvl(EFFECTIVE_END_DATE,SYSDATE );
382:
383: