APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_FORMULA_INPUTS

Line 652: FROM cn_formula_inputs

648: )
649: OR (
650: EXISTS(
651: SELECT 1
652: FROM cn_formula_inputs
653: WHERE calc_sql_exp_id = p_calc_sql_exp_id
654: OR f_calc_sql_exp_id = p_calc_sql_exp_id)
655: )
656: OR (EXISTS(SELECT 1

Line 960: FROM cn_formula_inputs

956: )
957: OR (
958: EXISTS(
959: SELECT 1
960: FROM cn_formula_inputs
961: WHERE calc_sql_exp_id = p_calc_sql_exp_id
962: OR f_calc_sql_exp_id = p_calc_sql_exp_id)
963: )
964: OR (EXISTS(SELECT 1

Line 1101: OR (calc_formula_id IN (SELECT calc_formula_id FROM cn_formula_inputs

1097: FROM cn_calc_formulas
1098: WHERE perf_measure_id = p_calc_sql_exp_id
1099: OR output_exp_id = p_calc_sql_exp_id
1100: OR f_output_exp_id = p_calc_sql_exp_id
1101: OR (calc_formula_id IN (SELECT calc_formula_id FROM cn_formula_inputs
1102: WHERE calc_sql_exp_id = p_calc_sql_exp_id
1103: OR f_calc_sql_exp_id = p_calc_sql_exp_id));
1104:
1105: BEGIN

Line 1521: FROM cn_calc_sql_exps ccse, cn_calc_formulas ccf, cn_formula_inputs cfi

1517: WHERE quota_id = p_current_id;
1518:
1519: CURSOR get_exp_ids IS
1520: SELECT ccse.calc_sql_exp_id
1521: FROM cn_calc_sql_exps ccse, cn_calc_formulas ccf, cn_formula_inputs cfi
1522: WHERE (
1523: (ccse.calc_sql_exp_id = ccf.perf_measure_id)
1524: OR (ccse.calc_sql_exp_id = ccf.output_exp_id)
1525: OR (ccse.calc_sql_exp_id = cfi.calc_sql_exp_id)

Line 1670: FROM cn_formula_inputs

1666: WHERE DBMS_LOB.SUBSTR(sql_select) LIKE '%(' || p_current_id || 'PE.%';
1667:
1668: CURSOR get_formulas IS
1669: SELECT calc_formula_id
1670: FROM cn_formula_inputs
1671: WHERE calc_sql_exp_id = p_current_id OR f_calc_sql_exp_id = p_current_id
1672: UNION ALL
1673: SELECT calc_formula_id
1674: FROM cn_calc_formulas