APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_QUOTAS

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 226: CURSOR l_srp_quota_assign_csr (c_quota_id cn_quotas.quota_id%TYPE,

222: l_resp_id NUMBER(15);
223: l_login_id NUMBER(15);
224: l_valid NUMBER;
225:
226: CURSOR l_srp_quota_assign_csr (c_quota_id cn_quotas.quota_id%TYPE,
227: c_srp_plan_assign_id cn_srp_quota_assigns.srp_plan_assign_id%TYPE) IS
228: SELECT srp_quota_assign_id
229: FROM cn_srp_quota_assigns_all
230: WHERE srp_plan_assign_id = c_srp_plan_assign_id

Line 242: CURSOR l_rollover_quota_csr (c_quota_id cn_quotas.quota_id%TYPE) IS

238: WHERE srp_plan_assign_id = c_srp_plan_assign_id;
239:
240: l_srp_quota_assign_c2 l_srp_quota_assign_csr2%ROWTYPE;
241:
242: CURSOR l_rollover_quota_csr (c_quota_id cn_quotas.quota_id%TYPE) IS
243: SELECT *
244: FROM cn_rollover_quotas_all
245: WHERE quota_id = c_quota_id;
246:

Line 308: ,'PERIOD' -- Could let the user define this in cn_quotas

304: ,'EQUAL' -- Currently support only one method
305: ,q.quota_type_code
306: ,q.payment_amount
307: ,q.performance_goal
308: ,'PERIOD' -- Could let the user define this in cn_quotas
309: ,sysdate
310: ,l_user_id
311: ,sysdate
312: ,l_user_id

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

Line 761: -- o Called from cn_quotas_pkg.update_record

757: -- Update_srp_quota
758: -- Purpose
759: -- Maintain srp tables after a change to the source quota
760: -- Notes
761: -- o Called from cn_quotas_pkg.update_record
762: -- o Split from main update record for readability
763:
764: PROCEDURE update_srp_quota(
765: x_quota_id NUMBER