APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_QUOTAS_ALL

Line 17: from cn_quotas_all

13: INTO l_max_period_id
14: FROM cn_cal_per_int_types_all p2,
15: cn_srp_period_quotas_all cspq
16: WHERE p2.interval_type_id = (select interval_type_id
17: from cn_quotas_all
18: where quota_id = p_quota_id)
19: AND p2.interval_number = (select p1.interval_number
20: from cn_cal_per_int_types_all p1
21: where p1.cal_period_id = p_period_id

Line 24: from cn_quotas_all

20: from cn_cal_per_int_types_all p1
21: where p1.cal_period_id = p_period_id
22: and p1.org_id = g_org_id
23: and p1.interval_type_id = (select interval_type_id
24: from cn_quotas_all
25: where quota_id = p_quota_id))
26: AND p2.org_id = g_org_id
27: AND cspq.srp_plan_assign_id = p_srp_plan_assign_id
28: AND cspq.quota_id = p_quota_id

Line 138: and exists (select 1 from cn_quotas_all q

134: and spa.org_id = g_org_id
135: and sp.salesrep_id = spa.payee_id
136: and sp.period_id between pb.period_id and pb.end_period_id
137: and sp.quota_id = spa.quota_id
138: and exists (select 1 from cn_quotas_all q
139: where q.quota_id = sp.quota_id
140: and q.incentive_type_code = l_calc_type)
141: and cl.credited_salesrep_id(+) = spa.salesrep_id
142: and cl.srp_payee_assign_id(+) = spa.srp_payee_assign_id

Line 168: and exists (select 1 from cn_quotas_all q

164: and pb.end_date >= spa.start_date
165: and sp.salesrep_id = spa.payee_id
166: and sp.period_id between pb.period_id and pb.end_period_id
167: and sp.quota_id = spa.quota_id
168: and exists (select 1 from cn_quotas_all q
169: where q.quota_id = sp.quota_id
170: and q.incentive_type_code = l_calc_type)
171: and sp.role_id = g_payee_role
172: group by sp.salesrep_id, sp.credit_type_id;

Line 223: AND exists (select 1 from cn_quotas_all

219: AND cl.pay_period_id = l_period_id
220: AND cl.role_id = l_role_id
221: AND cl.quota_id = l_quota_id
222: AND cl.status = 'CALC'
223: AND exists (select 1 from cn_quotas_all
224: where quota_id = cl.quota_id
225: and credit_type_id = l_credit_type_id)
226: AND cl.srp_payee_assign_id is NULL;-- only line added to the previously existing query for fixing bug#2495614
227:

Line 236: cn_quotas_all cq

232: FROM cn_commission_lines_all cl,
233: cn_commission_headers_all ch,
234: cn_srp_plan_assigns_all cspa,
235: cn_role_plans_all crp,
236: cn_quotas_all cq
237: WHERE cl.credited_salesrep_id = l_salesrep_id
238: AND cl.org_id = g_org_id
239: AND ch.commission_header_id = cl.commission_header_id
240: AND cl.pay_period_id = l_period_id

Line 335: -- clku, 2655685, change cn_quotas to cn_quotas_all

331: -- wrong calc_type, raise an error
332: RAISE FND_API.g_exc_error;
333: END IF;
334:
335: -- clku, 2655685, change cn_quotas to cn_quotas_all
336: -- to handle the deleted PE
337: IF l_quota_id is not null THEN
338: select incentive_type_code
339: into l_int_type_code

Line 340: from cn_quotas_all

336: -- to handle the deleted PE
337: IF l_quota_id is not null THEN
338: select incentive_type_code
339: into l_int_type_code
340: from cn_quotas_all
341: where quota_id = l_quota_id;
342:
343: If l_int_type_code = l_calc_type THEN
344: l_delta_subledger.srp_period_id := l_subledger.srp_period_id;

Line 575: cn_quotas_all q

571: q.package_name package_name,
572: f.trx_group_code trx_group_code,
573: q.org_id
574: FROM cn_calc_formulas_all f,
575: cn_quotas_all q
576: WHERE q.quota_id = p_srp_pe_subledger.quota_id
577: AND f.calc_formula_id(+) = q.calc_formula_id
578: AND f.org_id(+) = q.org_id;
579: