APPS.PMI_COMMON_PKG SQL Statements

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

Line: 13

           SELECT orgn_code
             FROM ic_whse_mst
            WHERE whse_code = l_whse_code;

Line: 18

            SELECT b.orgn_code,c.GL_COST_MTHD
            FROM   ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c
            WHERE  a.whse_code = l_whse_code
            AND    a.orgn_code = b.orgn_code
            AND    b.co_code = c.co_code;

Line: 69

           SELECT rate_type_code
             FROM gl_srce_mst
            WHERE TRANS_SOURCE_TYPE=5;

Line: 129

           SELECT rate_type_code
             FROM gl_srce_mst
            WHERE TRANS_SOURCE_TYPE=5;

Line: 178

    SELECT TARGET_LEVEL_ID
    FROM   bisbv_target_levels
    WHERE  lower(target_level_short_name) = lower(p_target_shortname);

Line: 189

        SELECT p_period_set_name || '+' || period_name INTO time_lvl_id
        FROM gl_periods
        WHERE period_type     = p_period_type AND
            period_set_name   = p_period_set_name AND
            start_Date        BETWEEN p_from_date AND p_to_date  AND
            period_num        = p_period_num AND
            ADJUSTMENT_PERIOD_FLAG <> 'Y' ;

Line: 204

      SELECT p_period_set_name || '+' || period_name INTO time_lvl_id
      FROM gl_periods
      WHERE period_type     = p_period_type AND
            period_set_name = p_period_set_name AND
            start_Date      BETWEEN p_from_date AND p_to_date AND
            ADJUSTMENT_PERIOD_FLAG <> 'Y' ;

Line: 225

   SELECT  TARGET INTO l_target
   FROM bisbv_targets
   WHERE target_level_id  =  target_lvl_id and
     ORG_LEVEL_VALUE_ID   =  p_ORG_LVL_ID  AND
     PLAN_ID              =  p_plan_id     AND
     DIM1_LEVEL_VALUE_ID  =  p_DIM1_LVL_ID AND
     TIME_LEVEL_VALUE_ID  =  time_lvl_id;