APPS.CN_SFP_FORMULA_CMN_PKG SQL Statements

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

Line: 49

       SELECT rqc.calc_formula_id
        INTO l_formula_id
        FROM cn_srp_quota_cates sqc,
             cn_role_quota_cates rqc
        WHERE sqc.role_quota_cate_id = rqc.role_quota_cate_id
        AND sqc.srp_quota_cate_id = p_srp_quota_cate_id
        ;

Line: 66

      SELECT formula_status, org_id
       INTO l_formula_status, l_org_id
        FROM cn_calc_formulas
        WHERE calc_formula_id = l_formula_id;

Line: 84

       SELECT
        DECODE(qc.quota_unit_code, 'REVENUE', ( ROUND(NVL(sqc.est_achievement,0)/NVL(pt.rounding_factor, 1))*NVL(pt.rounding_factor, 1)),
        'UNIT', (NVL(sqc.est_achievement,0)), ( ROUND(NVL(sqc.est_achievement,0)/NVL(pt.rounding_factor, 1))*NVL(pt.rounding_factor, 1)) ) , sqc.object_version_number
       INTO l_est_achievement, l_object_version_number
       FROM cn_srp_quota_cates sqc,
          cn_role_details_v pt,
          cn_quota_categories qc
       WHERE sqc.srp_quota_cate_id = p_srp_quota_cate_id
         AND  sqc.role_id = pt.role_id
         AND  sqc.quota_category_id = qc.quota_category_id
        ;

Line: 271

    SELECT rdt.maximum_amount,
        rdt.minimum_amount,
        sqr.comm_rate comm_rate,
        rd.dim_unit_code tier_unit_code
        FROM
        cn_rate_dim_tiers rdt,
        cn_rate_sch_dims rsd,
        cn_rate_dimensions rd,
        cn_srp_quota_rates sqr,
        cn_role_quota_rates rqr
        WHERE
        sqr.role_quota_rate_id = rqr.role_quota_rate_id
        AND rqr.rate_schedule_id = rsd.rate_schedule_id
        AND rsd.rate_dimension_id = rdt.rate_dimension_id
        AND rsd.rate_dimension_id = rd.rate_dimension_id
        AND sqr.rate_tier_id = rdt.tier_sequence
        AND sqr.srp_quota_cate_id = p_srp_quota_cate_id
        ORDER BY rdt.minimum_amount;

Line: 292

      SELECT rdt.maximum_amount,
        rdt.minimum_amount,
        sqr.comm_rate comm_rate,
        rd.dim_unit_code tier_unit_code
        FROM
       cn_rate_dim_tiers rdt,
        cn_rate_sch_dims rsd,
        cn_rate_tiers rt,
        cn_rate_dimensions rd,
        cn_srp_quota_rates sqr
        WHERE sqr.rate_tier_id = rt.rate_tier_id
        AND rt.rate_schedule_id = rsd.rate_schedule_id
        AND rsd.rate_dimension_id = rdt.rate_dimension_id
        AND rsd.rate_dimension_id = rd.rate_dimension_id
        AND rt.rate_sequence = rdt.tier_sequence
        AND sqr.srp_quota_cate_id = p_srp_quota_cate_id
        ORDER BY rdt.minimum_amount
       ;