APPS.CN_CALC_SQL_EXPS_PVT dependencies on DUAL

Line 200: -- trx_group_code = 'INDIVIDUAL', cumulative_flag = 'N' and itd_flag = 'N'

196: x_exp_type_code := x_exp_type_code || 'N';
197: END IF;
198:
199: -- check whether the embedded formulas have the following flag setting:
200: -- trx_group_code = 'INDIVIDUAL', cumulative_flag = 'N' and itd_flag = 'N'
201: -- and threshold_all_tier_flag = 'N'
202: NULL; -- to be added later
203:
204: -- convert x_exp_type_code to something that is easy to understand

Line 233: IF (p_piped_sql_from = 'DUAL|' OR p_piped_sql_from = 'SYS.DUAL|') THEN

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
236: l_pos := 1;
237:

Line 633: FROM DUAL

629: l_formula_ids VARCHAR2(4000) := '|';
630:
631: CURSOR parent_exist IS
632: SELECT 1
633: FROM DUAL
634: WHERE (EXISTS(SELECT 1
635: FROM cn_calc_edges
636: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
637: OR (

Line 828: FROM DUAL

824: , fnd_global.user_id
825: , fnd_global.login_id
826: , SYSDATE
827: , fnd_global.user_id
828: FROM DUAL
829: WHERE NOT EXISTS(
830: SELECT 1
831: FROM cn_calc_edges
832: WHERE parent_id = p_calc_sql_exp_id

Line 940: FROM DUAL

936: l_dummy PLS_INTEGER;
937:
938: CURSOR parent_exist IS
939: SELECT 1
940: FROM DUAL
941: WHERE (EXISTS(SELECT 1
942: FROM cn_calc_edges
943: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
944: OR (

Line 1272: and trx_group_code = 'INDIVIDUAL'

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'
1274: and formula_type = 'C'
1275: order by name;
1276:

Line 1909: FROM DUAL;

1905: -- Bug 2295522
1906: -- set p_sql_select to upper
1907: SELECT UPPER(p_sql_select)
1908: INTO l_sql_select_left
1909: FROM DUAL;
1910:
1911: -- next build piped sql select
1912: LOOP
1913: ct := ct + 1; -- defend against infinite loop

Line 2088: x_piped_sql_from := 'DUAL|';

2084: x_expr_disp := REPLACE(x_piped_expr_disp, '|', '');
2085: p_sql_select := REPLACE(x_piped_sql_select, '|', '');
2086:
2087: IF x_piped_sql_from IS NULL THEN
2088: x_piped_sql_from := 'DUAL|';
2089: END IF;
2090:
2091: x_sql_from := REPLACE(SUBSTR(x_piped_sql_from, 1, LENGTH(x_piped_sql_from) - 1), '|'
2092: , ', '); -- trim last comma