eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_CALC_FORMULAS_ALL

Line 468: from cn_quotas_all cq, cn_calc_formulas_all ccf

464:
465: -- get number_dim
466: CURSOR get_number_dim(l_quota_id number) IS
467: select ccf.number_dim
468: from cn_quotas_all cq, cn_calc_formulas_all ccf
469: where cq.quota_id = l_quota_id
470: and cq.calc_formula_id = ccf.calc_formula_id;
471:
472: l_number_dim NUMBER;

Line 1175: from cn_quotas_all cq, cn_calc_formulas_all ccf

1171:
1172: -- get number_dim
1173: CURSOR get_number_dim(l_quota_id number) IS
1174: select ccf.number_dim, cq.org_id
1175: from cn_quotas_all cq, cn_calc_formulas_all ccf
1176: where cq.quota_id = l_quota_id
1177: and cq.calc_formula_id = ccf.calc_formula_id;
1178: l_number_dim NUMBER;
1179:

Line 1415: cn_calc_formulas_all ccf

1411: -- only use this if number_dim not used
1412: CURSOR DIM_NUMBER_CUR IS
1413: select ccf.number_dim
1414: from cn_srp_period_quotas_all cspq, cn_quotas_all cq,
1415: cn_calc_formulas_all ccf
1416: where cspq.srp_period_quota_id = x_srp_period_quota_id
1417: and cq.quota_id = cspq.quota_id
1418: and cq.calc_formula_id = ccf.calc_formula_id ;
1419: