APPS.PO_POXAWDCOTR_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

      select PAPF.FULL_NAME
      into cotr_contact_desc
      FROM PER_ALL_PEOPLE_F PAPF
      WHERE TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
            AND PAPF.PERSON_ID = p_cotr_contact;