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 118: FROM cn_quotas_all

114: FROM cn_srp_period_quotas_all
115: WHERE srp_period_quota_id = x_start_srp_period_quota_id;
116: SELECT interval_type_id
117: INTO l_interval_type_id
118: FROM cn_quotas_all
119: WHERE quota_id = l_quota_id;
120:
121: OPEN max_prev_period_csr(l_interval_type_id,l_start_period_id,l_org_id);
122: FETCH max_prev_period_csr INTO l_previous_period_id ;

Line 246: cn_quotas_all cq

242: NVL(spq.performance_goal_ptd,0) performance_goal_ptd
243: FROM cn_srp_period_quotas_all spq,
244: cn_period_statuses_all cp ,
245: cn_cal_per_int_types_all cpit ,
246: cn_quotas_all cq
247: WHERE spq.quota_id = x_quota_id
248: AND spq.quota_id = cq.quota_id
249: AND spq.period_id = cp.period_id
250: AND spq.org_id = cp.org_id

Line 271: cn_quotas_all cq

267: p.period_year period_year
268: FROM cn_srp_period_quotas_v p,
269: cn_period_statuses cp ,
270: cn_cal_per_int_types_all cpit ,
271: cn_quotas_all cq
272: WHERE p.quota_id = x_quota_id
273: AND p.quota_id = cq.quota_id
274: AND p.period_id = cp.period_id
275: AND cp.period_status IN ('O', 'F')

Line 405: cn_quotas_all q

401: IS
402: SELECT q.quota_id quota_id,
403: q.org_id
404: FROM cn_srp_quota_assigns_all qa ,
405: cn_quotas_all q
406: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
407: -- do not need itd and formula id anymore, bug 2462767,AND q.calc_formula_id = cf.calc_formula_id(+)
408: AND qa.quota_id = q.quota_id;
409: -- clku bug 2845024, performance fix, avoid full table scan by avoiding

Line 454: FROM cn_quotas_all cq,

450: -- get number_dim
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:

Line 729: cn_quotas_all q ,

725: l_user_id ,
726: l_login_id ,
727: qa.org_id
728: FROM cn_srp_quota_assigns_all qa ,
729: cn_quotas_all q ,
730: cn_srp_plan_assigns_all pa ,
731: cn_acc_period_statuses_v p
732: -- bug fix 4042235
733: ,

Line 899: cn_quotas_all cq

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

Line 923: cn_quotas_all cq

919: spq.period_year period_year
920: FROM cn_srp_period_quotas_v spq,
921: cn_period_statuses cp ,
922: cn_cal_per_int_types_all cpit ,
923: cn_quotas_all cq
924: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
925: AND spq.quota_id = cq.quota_id
926: AND spq.period_id = cp.period_id
927: AND cp.period_status IN ('O', 'F')

Line 1155: FROM cn_quotas_all cq,

1151: CURSOR get_number_dim(l_quota_id NUMBER)
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:

Line 1371: cn_quotas_all cq ,

1367: CURSOR DIM_NUMBER_CUR
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 ;

Line 1496: cn_quotas_all cq

1492: SELECT spq.srp_period_quota_id
1493: FROM cn_srp_period_quotas_v spq,
1494: cn_period_statuses cp ,
1495: cn_cal_per_int_types_all cpit ,
1496: cn_quotas_all cq
1497: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
1498: AND spq.quota_id = cq.quota_id
1499: AND spq.period_id = cp.period_id
1500: AND cp.period_status IN ('O', 'F')

Line 1520: cn_quotas_all cq

1516: spq.period_year period_year
1517: FROM cn_srp_period_quotas_v spq,
1518: cn_period_statuses cp ,
1519: cn_cal_per_int_types_all cpit ,
1520: cn_quotas_all cq
1521: WHERE spq.srp_quota_assign_id = x_srp_quota_assign_id
1522: AND spq.quota_id = cq.quota_id
1523: AND spq.period_id = cp.period_id
1524: AND cp.period_status IN ('O', 'F')

Line 1574: cn_quotas_all q

1570: l_performance_goal ,
1571: l_dist_rule_code ,
1572: l_period_type_code
1573: FROM cn_srp_quota_assigns_all qa,
1574: cn_quotas_all q
1575: WHERE qa.srp_quota_assign_id = x_srp_quota_assign_id
1576: AND q.quota_id = qa.quota_id
1577: AND qa.period_target_dist_rule_code <> 'USER_DEFINED' ;
1578: -- Currently this is the only distribution rule we support