APPS.CN_UPGRADE_PE_FORMULA_PKG dependencies on DUAL

Line 35: || DECODE (l_quota.trx_group_code, 'INDIVIDUAL', 'In', 'GROUP', 'Gr', 'In')

31: 'DISCOUNT', 'DIS',
32: 'MARGIN', 'MR'
33: )
34: || '_'
35: || DECODE (l_quota.trx_group_code, 'INDIVIDUAL', 'In', 'GROUP', 'Gr', 'In')
36: || '_'
37: || DECODE (l_quota.discount_option_code, 'NONE', 'DiN', 'QUOTA', 'DiQ', 'PAYMENT', 'DiP', 'DiN')
38: || '_'
39: || DECODE (l_quota.payment_type_code, 'FIXED', 'Fix', 'PAYMENT', 'Pay', 'TRANSACTION', 'App', '')

Line 49: FROM DUAL;

45: || DECODE (l_quota.itd_flag, 'Y', 'IY', 'N', 'IN', 'IN')
46: || '_'
47: || TO_CHAR (l_quota.org_id)
48: INTO l_formula_name
49: FROM DUAL;
50:
51: x_formula_name := l_formula_name;
52: END get_formula_name;
53:

Line 89: FROM DUAL;

85: 'Margin Percentage/100', 'ch.margin_percentage/100',
86: 'ch.transaction_amount'
87: )
88: INTO l_sql_select
89: FROM DUAL;
90:
91: cn_calc_sql_exps_pvt.create_expression (p_api_version => 1.0,
92: p_org_id => p_org_id,
93: p_name => p_name,

Line 277: p_sql_from => 'DUAL',

273: p_name => p_name,
274: p_description => p_name,
275: p_expression_disp => 'RateResult',
276: p_sql_select => 'RateResult',
277: p_sql_from => 'DUAL',
278: p_piped_expression_disp => 'RateResult|',
279: p_piped_sql_select => 'RateResult|',
280: p_piped_sql_from => 'DUAL|',
281: x_calc_sql_exp_id => l_calc_sql_exp_id,

Line 280: p_piped_sql_from => 'DUAL|',

276: p_sql_select => 'RateResult',
277: p_sql_from => 'DUAL',
278: p_piped_expression_disp => 'RateResult|',
279: p_piped_sql_select => 'RateResult|',
280: p_piped_sql_from => 'DUAL|',
281: x_calc_sql_exp_id => l_calc_sql_exp_id,
282: x_exp_type_code => l_exp_type_code,
283: x_status => l_status,
284: x_return_status => l_return_status,

Line 356: p_trx_group_code => 'INDIVIDUAL',

352: p_generate_packages => fnd_api.g_false,
353: p_name => 'Discount Option Formula',
354: p_description => '',
355: p_formula_type => 'C',
356: p_trx_group_code => 'INDIVIDUAL',
357: p_number_dim => 1,
358: p_cumulative_flag => 'N',
359: p_itd_flag => 'N',
360: p_split_flag => 'N',

Line 452: FROM DUAL;

448: 'MARGIN', 'Margin Percentage',
449: 'Revenue'
450: )
451: INTO l_perf_measure_name
452: FROM DUAL;
453:
454: IF l_quota.quota_type_code = 'TARGET'
455: THEN
456: IF l_quota.itd_flag = 'Y'