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_QUOTAS_ALL

Line 125: FROM cn_quotas_all WHERE quota_id = l_quota_id;

121: FROM cn_srp_period_quotas_all
122: WHERE srp_period_quota_id = x_start_srp_period_quota_id;
123:
124: SELECT interval_type_id INTO l_interval_type_id
125: FROM cn_quotas_all WHERE quota_id = l_quota_id;
126:
127: OPEN max_prev_period_csr(l_interval_type_id,l_start_period_id,l_org_id);
128: FETCH max_prev_period_csr INTO l_previous_period_id ;
129: if max_prev_period_csr%NOTFOUND then

Line 231: cn_quotas_all cq

227: FROM
228: cn_srp_period_quotas_all spq,
229: cn_period_statuses_all cp,
230: cn_cal_per_int_types_all cpit,
231: cn_quotas_all cq
232: WHERE spq.quota_id = x_quota_id
233: AND spq.quota_id = cq.quota_id
234: AND spq.period_id = cp.period_id
235: AND spq.org_id = cp.org_id

Line 258: cn_quotas_all cq

254: p.period_year period_year
255: FROM cn_srp_period_quotas_v p,
256: cn_period_statuses cp,
257: cn_cal_per_int_types_all cpit,
258: cn_quotas_all cq
259: WHERE p.quota_id = x_quota_id
260: AND p.quota_id = cq.quota_id
261: AND p.period_id = cp.period_id
262: AND cp.period_status IN ('O', 'F')

Line 418: ,cn_quotas_all q

414:
415: CURSOR ytd_flag IS
416: SELECT q.quota_id quota_id, q.org_id
417: FROM cn_srp_quota_assigns_all qa
418: ,cn_quotas_all q
419: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
420: -- do not need itd and formula id anymore, bug 2462767,AND q.calc_formula_id = cf.calc_formula_id(+)
421: AND qa.quota_id = q.quota_id;
422:

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 733: ,cn_quotas_all q

729: ,l_user_id
730: ,l_login_id
731: ,qa.org_id
732: FROM cn_srp_quota_assigns_all qa
733: ,cn_quotas_all q
734: ,cn_srp_plan_assigns_all pa
735: ,cn_acc_period_statuses_v p
736: -- bug fix 4042235
737: ,cn_period_statuses p2

Line 901: cn_quotas_all cq

897: ,spq.performance_goal_ptd
898: FROM cn_srp_period_quotas_v spq,
899: cn_period_statuses cp,
900: cn_cal_per_int_types_all cpit,
901: cn_quotas_all cq
902: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
903: AND spq.quota_id = cq.quota_id
904: AND spq.period_id = cp.period_id
905: AND cp.period_status IN ('O', 'F')

Line 928: cn_quotas_all cq

924: spq.period_year period_year
925: FROM cn_srp_period_quotas_v spq,
926: cn_period_statuses cp,
927: cn_cal_per_int_types_all cpit,
928: cn_quotas_all cq
929: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
930: AND spq.quota_id = cq.quota_id
931: AND spq.period_id = cp.period_id
932: AND cp.period_status IN ('O', 'F')

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 1414: from cn_srp_period_quotas_all cspq, cn_quotas_all cq,

1410:
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 ;

Line 1534: cn_quotas_all cq

1530: SELECT spq.srp_period_quota_id
1531: FROM cn_srp_period_quotas_v spq,
1532: cn_period_statuses cp,
1533: cn_cal_per_int_types_all cpit,
1534: cn_quotas_all cq
1535: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
1536: AND spq.quota_id = cq.quota_id
1537: AND spq.period_id = cp.period_id
1538: AND cp.period_status IN ('O', 'F')

Line 1561: cn_quotas_all cq

1557: spq.period_year period_year
1558: FROM cn_srp_period_quotas_v spq,
1559: cn_period_statuses cp,
1560: cn_cal_per_int_types_all cpit,
1561: cn_quotas_all cq
1562: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
1563: AND spq.quota_id = cq.quota_id
1564: AND spq.period_id = cp.period_id
1565: AND cp.period_status IN ('O', 'F')

Line 1621: cn_quotas_all q

1617: ,l_performance_goal
1618: ,l_dist_rule_code
1619: ,l_period_type_code
1620: FROM cn_srp_quota_assigns_all qa,
1621: cn_quotas_all q
1622: WHERE qa.srp_quota_assign_id = x_srp_quota_assign_id
1623: AND q.quota_id = qa.quota_id
1624: AND qa.period_target_dist_rule_code <> 'USER_DEFINED'
1625: ;