APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_QUOTAS_V

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

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

Line 1288: from cn_quotas_v

1284: order by user_name;
1285:
1286: cursor plan_elements is
1287: select quota_id, name
1288: from cn_quotas_v
1289: order by name;
1290:
1291:
1292:

Line 1508: FROM cn_quotas_v

1504: , p_pe_arr IN OUT NOCOPY num_tbl_type
1505: ) IS
1506: CURSOR get_formula_id IS
1507: SELECT calc_formula_id
1508: FROM cn_quotas_v
1509: WHERE quota_id = p_current_id;
1510:
1511: CURSOR get_exp_ids IS
1512: SELECT ccse.calc_sql_exp_id

Line 1653: FROM cn_quotas_v

1649: , p_pe_arr IN OUT NOCOPY num_tbl_type
1650: ) IS
1651: CURSOR get_quota_ids IS
1652: SELECT quota_id
1653: FROM cn_quotas_v
1654: WHERE calc_formula_id = p_current_id;
1655:
1656: CURSOR get_exp_ids IS
1657: SELECT calc_sql_exp_id

Line 1862: FROM cn_quotas_v

1858: || '_pkg.get_result(p_commission_line_id)' = l_segment;
1859:
1860: CURSOR get_pe_name(l_segment IN VARCHAR2) IS
1861: SELECT NAME
1862: FROM cn_quotas_v
1863: WHERE quota_id || 'PE' = l_segment;
1864:
1865: CURSOR get_tbl(l_segment IN VARCHAR2) IS
1866: SELECT user_name