APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_CALC_FORMULAS

Line 350: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

346: l_select_start PLS_INTEGER;
347: l_disp_end PLS_INTEGER;
348: l_select_end PLS_INTEGER;
349: l_token VARCHAR2(4000);
350: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
351:
352: CURSOR exp_exists IS
353: SELECT 1
354: FROM cn_calc_sql_exps

Line 634: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

630: l_select_start PLS_INTEGER;
631: l_disp_end PLS_INTEGER;
632: l_select_end PLS_INTEGER;
633: l_token VARCHAR2(4000);
634: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
635: l_exp_names VARCHAR2(4000) := '|';
636: l_formula_ids VARCHAR2(4000) := '|';
637:
638: CURSOR parent_exist IS

Line 646: FROM cn_calc_formulas

642: FROM cn_calc_edges
643: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
644: OR (
645: EXISTS(SELECT 1
646: FROM cn_calc_formulas
647: WHERE perf_measure_id = p_calc_sql_exp_id OR output_exp_id = p_calc_sql_exp_id)
648: )
649: OR (
650: EXISTS(

Line 954: FROM cn_calc_formulas

950: FROM cn_calc_edges
951: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
952: OR (
953: EXISTS(SELECT 1
954: FROM cn_calc_formulas
955: WHERE perf_measure_id = p_calc_sql_exp_id OR output_exp_id = p_calc_sql_exp_id)
956: )
957: OR (
958: EXISTS(

Line 1097: FROM cn_calc_formulas

1093: WHERE min_exp_id = p_calc_sql_exp_id
1094: OR max_exp_id = p_calc_sql_exp_id)
1095: UNION ALL
1096: SELECT name
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

Line 1277: from cn_calc_formulas

1273:
1274: cursor calc_formulas is
1275: select name, 'cn_formula_' || abs(calc_formula_id) || '_' || abs(org_id) ||
1276: '_pkg.get_result(p_commission_line_id)' node_value
1277: from cn_calc_formulas
1278: where formula_status = 'COMPLETE'
1279: and cumulative_flag = 'N'
1280: and trx_group_code = 'INDIVIDUAL'
1281: and itd_flag = 'N'

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

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
1675: WHERE output_exp_id = p_current_id
1676: OR f_output_exp_id = p_current_id
1677: OR perf_measure_id = p_current_id;
1678:

Line 1872: FROM cn_calc_formulas

1868: l_api_version CONSTANT NUMBER := 1.0;
1869:
1870: CURSOR get_formula_name(l_segment IN VARCHAR2) IS
1871: SELECT NAME
1872: FROM cn_calc_formulas
1873: WHERE 'cn_formula_'
1874: || calc_formula_id
1875: || '_'
1876: || org_id