APPS.GMF_CMRGLR_XMLP_PKG SQL Statements

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

Line: 146

      SELECT
        FORMULA_NO,
        FORMULA_VERS
      INTO FLD1,FLD2
      FROM
        FM_FORM_EFF EFF,
        FM_FORM_MST MST
      WHERE EFF.FMEFF_ID = FRM_ID
        AND EFF.FORMULA_ID = MST.FORMULA_ID;

Line: 159

      SELECT
        ROUTING_NO,
        ROUTING_VERS
      INTO FLD3,FLD4
      FROM
        FM_FORM_EFF EFF,
        FM_ROUT_HDR HDR
      WHERE EFF.FMEFF_ID = FRM_ID
        AND EFF.ROUTING_ID = HDR.ROUTING_ID;

Line: 187

      SELECT
        FORMULA_NO,
        FORMULA_VERS
      INTO FLD1,FLD2
      FROM
        FM_FORM_EFF EFF,
        FM_FORM_MST MST
      WHERE EFF.FMEFF_ID = FRM_ID_DTL
        AND EFF.FORMULA_ID = MST.FORMULA_ID;

Line: 200

      SELECT
        ROUTING_NO,
        ROUTING_VERS
      INTO FLD3,FLD4
      FROM
        FM_FORM_EFF EFF,
        FM_ROUT_HDR HDR
      WHERE EFF.FMEFF_ID = FRM_ID_DTL
        AND EFF.ROUTING_ID = HDR.ROUTING_ID;

Line: 325

      SELECT
        COST_MTHD_CODE
      INTO L_COST_MTHD_CODE
      FROM
        CM_MTHD_MST
      WHERE COST_TYPE_ID = P_COST_TYPE_ID;

Line: 341

      SELECT
        LEGAL_ENTITY_NAME
      INTO L_LEGAL_ENTITY_NAME
      FROM
        GMF_LEGAL_ENTITIES
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 358

      SELECT
        PERIOD_ID,
        DECODE(PERIOD_STATUS
              ,'O'
              ,'Open'
              ,'F'
              ,'Future'
              ,'C'
              ,'Closed')
      INTO L_PERIOD_ID,L_PERIOD_STATUS
      FROM
        GMF_PERIOD_STATUSES
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
        AND CALENDAR_CODE = P_CALENDAR_CODE
        AND PERIOD_CODE = P_PERIOD_CODE
        AND COST_TYPE_ID = P_COST_TYPE_ID;