DBA Data[Home] [Help]

APPS.PO_POXAWDCOTR_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 59: FROM PER_ALL_PEOPLE_F PAPF

55: Begin
56: if p_cotr_contact is not null then
57: select PAPF.FULL_NAME
58: into cotr_contact_desc
59: FROM PER_ALL_PEOPLE_F PAPF
60: WHERE TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
61: AND PAPF.PERSON_ID = p_cotr_contact;
62: end if;
63: