APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_QUOTAS_V

Line 237: -- if all the tables used are only from cn_quotas_v, cn_period_quotas, cn_srp_quota_assigns,

233: END IF;
234:
235: -- check whether it can be used in dynamic rate tables also
236: IF (x_exp_type_code = 'IRIOIPGOGPBIBOBPFRFO') THEN
237: -- if all the tables used are only from cn_quotas_v, cn_period_quotas, cn_srp_quota_assigns,
238: -- and cn_srp_period_quotas, then it can be used in dynamic dimension tiers also
239: IF (p_piped_sql_from = 'DUAL|' OR p_piped_sql_from = 'SYS.DUAL|') THEN
240: x_exp_type_code := x_exp_type_code || 'DDT';
241: ELSE

Line 1296: from cn_quotas_v

1292: order by user_name;
1293:
1294: cursor plan_elements is
1295: select quota_id, name
1296: from cn_quotas_v
1297: order by name;
1298:
1299:
1300:

Line 1516: FROM cn_quotas_v

1512: , p_pe_arr IN OUT NOCOPY num_tbl_type
1513: ) IS
1514: CURSOR get_formula_id IS
1515: SELECT calc_formula_id
1516: FROM cn_quotas_v
1517: WHERE quota_id = p_current_id;
1518:
1519: CURSOR get_exp_ids IS
1520: SELECT ccse.calc_sql_exp_id

Line 1660: FROM cn_quotas_v

1656: , p_pe_arr IN OUT NOCOPY num_tbl_type
1657: ) IS
1658: CURSOR get_quota_ids IS
1659: SELECT quota_id
1660: FROM cn_quotas_v
1661: WHERE calc_formula_id = p_current_id;
1662:
1663: CURSOR get_exp_ids IS
1664: SELECT calc_sql_exp_id

Line 1881: FROM cn_quotas_v

1877: || '_pkg.get_result(p_commission_line_id)' = l_segment;
1878:
1879: CURSOR get_pe_name(l_segment IN VARCHAR2) IS
1880: SELECT NAME
1881: FROM cn_quotas_v
1882: WHERE quota_id || 'PE' = l_segment;
1883:
1884: CURSOR get_tbl(l_segment IN VARCHAR2) IS
1885: SELECT user_name