DBA Data[Home] [Help]

APPS.CN_COMMISSION_CALC_PVT dependencies on CN_QUOTAS

Line 32: FROM cn_quotas cq

28: SELECT ccf.name formula_name
29: , ccf.calc_formula_id formula_id
30: , ccf.formula_status formula_status
31: , ccf.org_id org_id
32: FROM cn_quotas cq
33: , cn_calc_formulas ccf
34: WHERE cq.quota_id = p_quota_id
35: AND ccf.calc_formula_id = cq.calc_formula_id;
36:

Line 144: cn_quotas q,

140: , q.name quota_name
141: , qr.revenue_class_id
142: from cn_srp_plan_assigns spa,
143: cn_srp_quota_assigns sqa,
144: cn_quotas q,
145: cn_quota_rules qr,
146: cn_dim_hierarchies dh,
147: jtf_rs_salesreps jrs,
148: jtf_rs_group_members mem,