APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_QUOTAS_ALL

Line 79: , cn_quotas_all cq

75: FROM
76: (
77: SELECT 'X'
78: FROM cn_srp_quota_assigns_all csqa
79: , cn_quotas_all cq
80: WHERE csqa.srp_quota_assign_id = x_srp_quota_assign_id
81: AND cq.quota_id = x_quota_id
82: AND (
83: csqa.target <> cq.target

Line 176: SELECT 1 FROM cn_quotas_all cq

172: SELECT 1 FROM cn_quota_assigns_all cqa
173: WHERE cqa.comp_plan_id = csqa.comp_plan_id
174: AND EXISTS
175: (
176: SELECT 1 FROM cn_quotas_all cq
177: WHERE cq.quota_id = cqa.quota_id
178: AND cq.payee_assign_flag = 'Y'
179: )
180: )

Line 315: FROM cn_quotas_all q

311: ,sysdate
312: ,l_user_id
313: ,l_login_id
314: ,org_id
315: FROM cn_quotas_all q
316: WHERE q.quota_id = x_quota_id
317: ;
318:
319: -- clku, populate_srp_rollover_quotas

Line 396: FROM cn_quotas_all q

392: ,sysdate
393: ,l_user_id
394: ,l_login_id
395: ,q.org_id
396: FROM cn_quotas_all q
397: ,cn_srp_plan_assigns_all pa
398: ,cn_quota_assigns_all qa
399: WHERE pa.srp_plan_assign_id = x_srp_plan_assign_id
400: AND pa.comp_plan_id = qa.comp_plan_id

Line 642: from cn_quotas_all

638: performance_goal) =
639: (select target,
640: payment_amount,
641: performance_goal
642: from cn_quotas_all
643: where quota_id = x_quota_id)
644: where srp_quota_assign_id = x_srp_quota_assign_id;
645:
646: -- clku, revert changes in cn_srp_rolling_quotas