APPS.HXC_HXCRTERR_XMLP_PKG SQL Statements

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

Line: 6

      SELECT
        PPF.LAST_NAME,
        NVL(PPF.EMPLOYEE_NUMBER
           ,PPF.NPW_NUMBER) EMPLOYEE_NUMBER
      FROM
        PER_PEOPLE_F PPF
      WHERE PPF.PERSON_ID = CP_PERSON_ID
        AND CP_EFFECTIVE_DATE between PPF.EFFECTIVE_START_DATE
        AND PPF.EFFECTIVE_END_DATE;

Line: 29

      SELECT
        HRP.NAME
      FROM
        HXC_RETRIEVAL_PROCESSES HRP
      WHERE HRP.RETRIEVAL_PROCESS_ID = CP_RETRIEVAL_PROCESS_ID;

Line: 35

      SELECT
        RP.RETRIEVAL_PROCESS_ID
      FROM
        HXC_RETRIEVAL_PROCESSES RP
      WHERE NAME = 'BEE Retrieval Process';