APPS.PSB_PSBWSSUB_XMLP_PKG SQL Statements

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

Line: 16

    SELECT
      NAME
    INTO CP_BUDGET_GROUP_NAME
    FROM
      PSB_BUDGET_GROUPS
    WHERE BUDGET_GROUP_ID = P_BUDGET_GROUP_ID;

Line: 22

    SELECT
      MEANING
    INTO CP_NOT_SUBMITTED_ONLY
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = P_NOT_SUBMITTED_ONLY_FLAG;

Line: 29

    SELECT
      BUDGET_CALENDAR_ID,
      GLOBAL_WORKSHEET_ID,
      NVL(GLOBAL_WORKSHEET_FLAG
         ,'N')
    INTO L_BUDGET_CALENDAR_ID,L_GLOBAL_WORKSHEET_ID,L_GLOBAL_WORKSHEET_FLAG
    FROM
      PSB_WORKSHEETS
    WHERE WORKSHEET_ID = P_WORKSHEET_ID;