DBA Data[Home] [Help]

APPS.PSB_PSBBGASR_XMLP_PKG SQL Statements

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

Line: 13

      SELECT
        NAME
      INTO CP_SET_OF_BOOKS_NAME
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
Line: 24

        SELECT
          NAME
        INTO CP_BUDGET_GROUP_NAME
        FROM
          PSB_BUDGET_GROUPS
        WHERE BUDGET_GROUP_ID = P_BUDGET_GROUP_ID;
Line: 32

    SELECT
      MEANING
    INTO CP_PRINT_SUBGROUPS
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = P_PRINT_SUBGROUPS_FLAG;