APPS.CN_CALC_SQL_EXPS_PVT dependencies on DUAL

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

202: x_exp_type_code := x_exp_type_code || 'N';
203: END IF;
204:
205: -- check whether the embedded formulas have the following flag setting:
206: -- trx_group_code = 'INDIVIDUAL', cumulative_flag = 'N' and itd_flag = 'N'
207: -- and threshold_all_tier_flag = 'N'
208: NULL; -- to be added later
209:
210: -- convert x_exp_type_code to something that is easy to understand

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

235: -- check whether it can be used in dynamic rate tables also
236: IF (x_exp_type_code = 'IRIOIPGOGPBIBOBPFRFO') THEN
237: -- if all the tables used are only from cn_quotas_v, cn_period_quotas, cn_srp_quota_assigns,
238: -- and cn_srp_period_quotas, then it can be used in dynamic dimension tiers also
239: IF (p_piped_sql_from = 'DUAL|' OR p_piped_sql_from = 'SYS.DUAL|') THEN
240: x_exp_type_code := x_exp_type_code || 'DDT';
241: ELSE
242: l_pos := 1;
243:

Line 640: FROM DUAL

636: l_formula_ids VARCHAR2(4000) := '|';
637:
638: CURSOR parent_exist IS
639: SELECT 1
640: FROM DUAL
641: WHERE (EXISTS(SELECT 1
642: FROM cn_calc_edges
643: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
644: OR (

Line 836: FROM DUAL

832: , fnd_global.user_id
833: , fnd_global.login_id
834: , SYSDATE
835: , fnd_global.user_id
836: FROM DUAL
837: WHERE NOT EXISTS(
838: SELECT 1
839: FROM cn_calc_edges
840: WHERE parent_id = p_calc_sql_exp_id

Line 948: FROM DUAL

944: l_dummy PLS_INTEGER;
945:
946: CURSOR parent_exist IS
947: SELECT 1
948: FROM DUAL
949: WHERE (EXISTS(SELECT 1
950: FROM cn_calc_edges
951: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
952: OR (

Line 1280: and trx_group_code = 'INDIVIDUAL'

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'
1282: and formula_type = 'C'
1283: order by name;
1284:

Line 1928: FROM DUAL;

1924: -- Bug 2295522
1925: -- set p_sql_select to upper
1926: SELECT UPPER(p_sql_select)
1927: INTO l_sql_select_left
1928: FROM DUAL;
1929:
1930: -- next build piped sql select
1931: LOOP
1932: ct := ct + 1; -- defend against infinite loop

Line 2107: x_piped_sql_from := 'DUAL|';

2103: x_expr_disp := REPLACE(x_piped_expr_disp, '|', '');
2104: p_sql_select := REPLACE(x_piped_sql_select, '|', '');
2105:
2106: IF x_piped_sql_from IS NULL THEN
2107: x_piped_sql_from := 'DUAL|';
2108: END IF;
2109:
2110: x_sql_from := REPLACE(SUBSTR(x_piped_sql_from, 1, LENGTH(x_piped_sql_from) - 1), '|'
2111: , ', '); -- trim last comma