APPS.PSB_PSBRPPOS_XMLP_PKG SQL Statements

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

Line: 9

        SELECT
          NAME
        INTO CP_POSITION_SETS
        FROM
          PSB_ACCOUNT_POSITION_SETS
        WHERE ACCOUNT_POSITION_SET_ID = P_ACCOUNT_POSITION_SET_ID;

Line: 21

        SELECT
          DATA_EXTRACT_NAME
        INTO CP_DATA_EXTRACT_NAME
        FROM
          PSB_DATA_EXTRACTS
        WHERE DATA_EXTRACT_ID = P_DATA_EXTRACT_ID;

Line: 33

        SELECT
          DATA_EXTRACT_NAME
        INTO CP_DATA_EXTRACT_NAME
        FROM
          PSB_DATA_EXTRACTS
        WHERE DATA_EXTRACT_ID = P_DATA_EXTRACT_ID;

Line: 39

        SELECT
          NAME
        INTO CP_POSITION_SETS
        FROM
          PSB_ACCOUNT_POSITION_SETS
        WHERE ACCOUNT_POSITION_SET_ID = P_ACCOUNT_POSITION_SET_ID;