APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_QUOTA_ASSIGNS_ALL

Line 417: FROM cn_srp_quota_assigns_all qa

413: -- Get the itd_flag for each quota
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;

Line 529: FROM cn_srp_quota_assigns_all qa

525: ,sysdate
526: ,l_user_id
527: ,l_login_id
528: ,qa.org_id
529: FROM cn_srp_quota_assigns_all qa
530: ,cn_period_quotas_all pq
531: ,cn_srp_plan_assigns_all pa
532: ,cn_period_statuses p
533: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id

Line 641: FROM cn_srp_quota_assigns_all qa

637: ,sysdate
638: ,l_user_id
639: ,l_login_id
640: ,qa.org_id
641: FROM cn_srp_quota_assigns_all qa
642: ,cn_period_quotas_all pq
643: ,cn_srp_plan_assigns_all pa
644: ,cn_period_statuses p
645: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id

Line 732: FROM cn_srp_quota_assigns_all qa

728: ,sysdate
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

Line 1181: SELECT quota_id FROM cn_srp_quota_assigns_all

1177: and cq.calc_formula_id = ccf.calc_formula_id;
1178: l_number_dim NUMBER;
1179:
1180: CURSOR get_quotas IS
1181: SELECT quota_id FROM cn_srp_quota_assigns_all
1182: WHERE srp_plan_assign_id = x_srp_plan_assign_id;
1183:
1184: l_last_period_id number := -1;
1185: l_last_salesrep_id number := -1;

Line 1620: FROM cn_srp_quota_assigns_all qa,

1616: ,l_quota_payment
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'