APPS.CN_SFP_FORMULA_CMN_PKG dependencies on CN_SRP_QUOTA_CATES

Line 51: FROM cn_srp_quota_cates sqc,

47: -- Find the formula associated with the srp_quota_cate
48:
49: SELECT rqc.calc_formula_id
50: INTO l_formula_id
51: FROM cn_srp_quota_cates sqc,
52: cn_role_quota_cates rqc
53: WHERE sqc.role_quota_cate_id = rqc.role_quota_cate_id
54: AND sqc.srp_quota_cate_id = p_srp_quota_cate_id
55: ;

Line 88: FROM cn_srp_quota_cates sqc,

84: SELECT
85: DECODE(qc.quota_unit_code, 'REVENUE', ( ROUND(NVL(sqc.est_achievement,0)/NVL(pt.rounding_factor, 1))*NVL(pt.rounding_factor, 1)),
86: '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
87: INTO l_est_achievement, l_object_version_number
88: FROM cn_srp_quota_cates sqc,
89: cn_role_details_v pt,
90: cn_quota_categories qc
91: WHERE sqc.srp_quota_cate_id = p_srp_quota_cate_id
92: AND sqc.role_id = pt.role_id