APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_CALC_FORMULAS

Line 344: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

340: l_select_start PLS_INTEGER;
341: l_disp_end PLS_INTEGER;
342: l_select_end PLS_INTEGER;
343: l_token VARCHAR2(4000);
344: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
345:
346: CURSOR exp_exists IS
347: SELECT 1
348: FROM cn_calc_sql_exps

Line 627: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

623: l_select_start PLS_INTEGER;
624: l_disp_end PLS_INTEGER;
625: l_select_end PLS_INTEGER;
626: l_token VARCHAR2(4000);
627: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
628: l_exp_names VARCHAR2(4000) := '|';
629: l_formula_ids VARCHAR2(4000) := '|';
630:
631: CURSOR parent_exist IS

Line 639: FROM cn_calc_formulas

635: FROM cn_calc_edges
636: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
637: OR (
638: EXISTS(SELECT 1
639: FROM cn_calc_formulas
640: WHERE perf_measure_id = p_calc_sql_exp_id OR output_exp_id = p_calc_sql_exp_id)
641: )
642: OR (
643: EXISTS(

Line 946: FROM cn_calc_formulas

942: FROM cn_calc_edges
943: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
944: OR (
945: EXISTS(SELECT 1
946: FROM cn_calc_formulas
947: WHERE perf_measure_id = p_calc_sql_exp_id OR output_exp_id = p_calc_sql_exp_id)
948: )
949: OR (
950: EXISTS(

Line 1089: FROM cn_calc_formulas

1085: WHERE min_exp_id = p_calc_sql_exp_id
1086: OR max_exp_id = p_calc_sql_exp_id)
1087: UNION ALL
1088: SELECT name
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

Line 1269: from cn_calc_formulas

1265:
1266: cursor calc_formulas is
1267: select name, 'cn_formula_' || abs(calc_formula_id) || '_' || abs(org_id) ||
1268: '_pkg.get_result(p_commission_line_id)' node_value
1269: from cn_calc_formulas
1270: where formula_status = 'COMPLETE'
1271: and cumulative_flag = 'N'
1272: and trx_group_code = 'INDIVIDUAL'
1273: and itd_flag = 'N'

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 1667: FROM cn_calc_formulas

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
1668: WHERE output_exp_id = p_current_id
1669: OR f_output_exp_id = p_current_id
1670: OR perf_measure_id = p_current_id;
1671:

Line 1853: FROM cn_calc_formulas

1849: l_api_version CONSTANT NUMBER := 1.0;
1850:
1851: CURSOR get_formula_name(l_segment IN VARCHAR2) IS
1852: SELECT NAME
1853: FROM cn_calc_formulas
1854: WHERE 'cn_formula_'
1855: || calc_formula_id
1856: || '_'
1857: || org_id