DBA Data[Home] [Help]

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_CALC_FORMULAS_ALL

Line 455: cn_calc_formulas_all ccf

451: CURSOR get_number_dim(l_quota_id NUMBER)
452: IS
453: SELECT ccf.number_dim
454: FROM cn_quotas_all cq,
455: cn_calc_formulas_all ccf
456: WHERE cq.quota_id = l_quota_id
457: AND cq.calc_formula_id = ccf.calc_formula_id;
458:
459: l_number_dim NUMBER;

Line 1156: cn_calc_formulas_all ccf

1152: IS
1153: SELECT ccf.number_dim,
1154: cq.org_id
1155: FROM cn_quotas_all cq,
1156: cn_calc_formulas_all ccf
1157: WHERE cq.quota_id = l_quota_id
1158: AND cq.calc_formula_id = ccf.calc_formula_id;
1159:
1160: l_number_dim NUMBER;

Line 1372: cn_calc_formulas_all ccf

1368: IS
1369: SELECT ccf.number_dim
1370: FROM cn_srp_period_quotas_all cspq,
1371: cn_quotas_all cq ,
1372: cn_calc_formulas_all ccf
1373: WHERE cspq.srp_period_quota_id = x_srp_period_quota_id
1374: AND cq.quota_id = cspq.quota_id
1375: AND cq.calc_formula_id = ccf.calc_formula_id ;
1376: