DBA Data[Home] [Help]

APPS.CN_CALC_POPULATE_PVT dependencies on CN_QUOTAS_ALL

Line 281: cn_quotas_all q,

277: nvl(q.end_date, p_end_date),
278: nvl(rr.end_date_active, p_end_date), p_end_date) end_date
279: from cn_srp_plan_assigns_all spa,
280: cn_srp_quota_assigns_all sqa,
281: cn_quotas_all q,
282: cn_quota_rules_all qr,
283: cn_dim_hierarchies_all dh,
284: jtf_rs_salesreps jrs,
285: jtf_rs_group_members mem,

Line 341: cn_quotas_all q,

337: nvl(q.end_date, p_end_date),
338: nvl(rr.end_date_active, p_end_date), p_end_date) end_date
339: from cn_srp_plan_assigns_all spa,
340: cn_srp_quota_assigns_all sqa,
341: cn_quotas_all q,
342: cn_quota_rules_all qr,
343: jtf_rs_salesreps jrs,
344: jtf_rs_group_members mem,
345: jtf_rs_role_relations rr

Line 557: from cn_quotas_all

553: rep.start_date,
554: rep.end_date)
555: loop
556: select nvl(indirect_credit, 'ALL') into l_indirect_credit
557: from cn_quotas_all
558: where quota_id = plan.quota_id;
559:
560: select manager_flag into l_manager_flag
561: from cn_roles