APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_FORMULA_INPUTS

Line 645: FROM cn_formula_inputs

641: )
642: OR (
643: EXISTS(
644: SELECT 1
645: FROM cn_formula_inputs
646: WHERE calc_sql_exp_id = p_calc_sql_exp_id
647: OR f_calc_sql_exp_id = p_calc_sql_exp_id)
648: )
649: OR (EXISTS(SELECT 1

Line 952: FROM cn_formula_inputs

948: )
949: OR (
950: EXISTS(
951: SELECT 1
952: FROM cn_formula_inputs
953: WHERE calc_sql_exp_id = p_calc_sql_exp_id
954: OR f_calc_sql_exp_id = p_calc_sql_exp_id)
955: )
956: OR (EXISTS(SELECT 1

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

1089: FROM cn_calc_formulas
1090: WHERE perf_measure_id = p_calc_sql_exp_id
1091: OR output_exp_id = p_calc_sql_exp_id
1092: OR f_output_exp_id = p_calc_sql_exp_id
1093: OR (calc_formula_id IN (SELECT calc_formula_id FROM cn_formula_inputs
1094: WHERE calc_sql_exp_id = p_calc_sql_exp_id
1095: OR f_calc_sql_exp_id = p_calc_sql_exp_id));
1096:
1097: BEGIN

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

1509: WHERE quota_id = p_current_id;
1510:
1511: CURSOR get_exp_ids IS
1512: SELECT ccse.calc_sql_exp_id
1513: FROM cn_calc_sql_exps ccse, cn_calc_formulas ccf, cn_formula_inputs cfi
1514: WHERE (
1515: (ccse.calc_sql_exp_id = ccf.perf_measure_id)
1516: OR (ccse.calc_sql_exp_id = ccf.output_exp_id)
1517: OR (ccse.calc_sql_exp_id = cfi.calc_sql_exp_id)

Line 1663: FROM cn_formula_inputs

1659: WHERE DBMS_LOB.SUBSTR(sql_select) LIKE '%(' || p_current_id || 'PE.%';
1660:
1661: CURSOR get_formulas IS
1662: SELECT calc_formula_id
1663: FROM cn_formula_inputs
1664: WHERE calc_sql_exp_id = p_current_id OR f_calc_sql_exp_id = p_current_id
1665: UNION ALL
1666: SELECT calc_formula_id
1667: FROM cn_calc_formulas