APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_QUOTA_ASSIGNS_ALL

Line 404: FROM cn_srp_quota_assigns_all qa ,

400: CURSOR ytd_flag
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;

Line 513: FROM cn_srp_quota_assigns_all qa ,

509: sysdate ,
510: l_user_id ,
511: l_login_id ,
512: qa.org_id
513: FROM cn_srp_quota_assigns_all qa ,
514: cn_period_quotas_all pq ,
515: cn_srp_plan_assigns_all pa ,
516: cn_period_statuses p
517: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id

Line 628: FROM cn_srp_quota_assigns_all qa ,

624: sysdate ,
625: l_user_id ,
626: l_login_id ,
627: qa.org_id
628: FROM cn_srp_quota_assigns_all qa ,
629: cn_period_quotas_all pq ,
630: cn_srp_plan_assigns_all pa ,
631: cn_period_statuses p
632: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id

Line 728: FROM cn_srp_quota_assigns_all qa ,

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

Line 1164: FROM cn_srp_quota_assigns_all

1160: l_number_dim NUMBER;
1161: CURSOR get_quotas
1162: IS
1163: SELECT quota_id
1164: FROM cn_srp_quota_assigns_all
1165: WHERE srp_plan_assign_id = x_srp_plan_assign_id;
1166:
1167: l_last_period_id NUMBER := -1;
1168: l_last_salesrep_id NUMBER := -1;

Line 1573: FROM cn_srp_quota_assigns_all qa,

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