eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_REVENUE dependencies on PA_MULTI_CURRENCY_BILLING

Line 1133: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)

1129: BEGIN
1130: SELECT DECODE(asgn.bill_rate_override, NULL, NULL,
1131: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)),
1132: DECODE(asgn.bill_rate_override, NULL,
1133: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1134: * l_mcb_raw_cost / 100),l_mcb_currency_code),
1135: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT ((asgn.bill_rate_override *
1136: NVL(p_bill_rate_multiplier,1) * p_quantity),asgn.bill_rate_curr_override)),
1137: DECODE(asgn.bill_rate_override,NULL,l_mcb_currency_code,asgn.bill_rate_curr_override),

Line 1135: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT ((asgn.bill_rate_override *

1131: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)),
1132: DECODE(asgn.bill_rate_override, NULL,
1133: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1134: * l_mcb_raw_cost / 100),l_mcb_currency_code),
1135: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT ((asgn.bill_rate_override *
1136: NVL(p_bill_rate_multiplier,1) * p_quantity),asgn.bill_rate_curr_override)),
1137: DECODE(asgn.bill_rate_override,NULL,l_mcb_currency_code,asgn.bill_rate_curr_override),
1138: asgn.markup_percent_override,
1139: 'O',

Line 1162: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)

1158: SELECT DECODE(asgn.bill_rate_override, NULL, NULL,
1159: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)
1160: ),
1161: DECODE(asgn.bill_rate_override, NULL,
1162: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1163: * p_raw_cost / 100),l_projfunc_currency_code),
1164: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1165: * NVL(p_bill_rate_multiplier,1)
1166: * p_quantity),asgn.bill_rate_curr_override)),

Line 1164: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override

1160: ),
1161: DECODE(asgn.bill_rate_override, NULL,
1162: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1163: * p_raw_cost / 100),l_projfunc_currency_code),
1164: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1165: * NVL(p_bill_rate_multiplier,1)
1166: * p_quantity),asgn.bill_rate_curr_override)),
1167: DECODE(asgn.bill_rate_override,NULL,l_projfunc_currency_code,asgn.bill_rate_curr_override),
1168: asgn.markup_percent_override,

Line 1218: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((o.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),o.rate_currency_code) r_revenue,

1214: -- This cursor will select the bill rate and raw revenue on the basis of passed parameters i.e.
1215: -- if task id is not null then select will bring the task id row
1216:
1217: CURSOR C_Task IS SELECT o.rate * NVL(p_bill_rate_multiplier,1) b_rate,
1218: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((o.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),o.rate_currency_code) r_revenue,
1219: o.rate_currency_code,
1220: 'O',
1221: o.discount_percentage
1222: FROM pa_emp_bill_rate_overrides o

Line 1303: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)

1299: BEGIN
1300: SELECT DECODE(asgn.bill_rate_override, NULL, NULL,
1301: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)),
1302: DECODE(asgn.bill_rate_override, NULL,
1303: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1304: * l_mcb_raw_cost / 100),l_mcb_currency_code),
1305: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1306: * NVL(p_bill_rate_multiplier,1)
1307: * p_quantity),asgn.bill_rate_curr_override)),

Line 1305: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override

1301: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)),
1302: DECODE(asgn.bill_rate_override, NULL,
1303: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1304: * l_mcb_raw_cost / 100),l_mcb_currency_code),
1305: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1306: * NVL(p_bill_rate_multiplier,1)
1307: * p_quantity),asgn.bill_rate_curr_override)),
1308: DECODE(asgn.bill_rate_override,NULL,l_mcb_currency_code,asgn.bill_rate_curr_override),
1309: asgn.markup_percent_override,

Line 1333: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)

1329: SELECT DECODE(asgn.bill_rate_override, NULL, NULL,
1330: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)
1331: ),
1332: DECODE(asgn.bill_rate_override, NULL,
1333: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1334: * p_raw_cost / 100),l_projfunc_currency_code),
1335: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1336: * NVL(p_bill_rate_multiplier,1)
1337: * p_quantity),asgn.bill_rate_curr_override)),

Line 1335: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override

1331: ),
1332: DECODE(asgn.bill_rate_override, NULL,
1333: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1334: * p_raw_cost / 100),l_projfunc_currency_code),
1335: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1336: * NVL(p_bill_rate_multiplier,1)
1337: * p_quantity),asgn.bill_rate_curr_override)),
1338: DECODE(asgn.bill_rate_override,NULL,l_projfunc_currency_code,asgn.bill_rate_curr_override),
1339: asgn.markup_percent_override,

Line 1382: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((o2.rate *

1378: -- task level select
1379:
1380: CURSOR C_Project IS
1381: SELECT o2.rate * NVL(p_bill_rate_multiplier,1) b_rate,
1382: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((o2.rate *
1383: NVL(p_bill_rate_multiplier,1) * p_quantity),o2.rate_currency_code) r_revenue,
1384: o2.rate_currency_code,
1385: 'O',
1386: o2.discount_percentage

Line 1816: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

1812: -- null then first select will bring the task id row and second select
1813: -- will bring all the raws ( If exists ) except the row which is already selected in first select
1814:
1815: CURSOR C1 IS( SELECT NULL b_rate,
1816: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1817: (m.labor_multiplier * decode(p_mcb_flag,'Y',l_mcb_raw_cost,p_raw_cost)),
1818: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code)) r_revenue,
1819: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code) curr_code
1820: FROM pa_labor_multipliers m

Line 1828: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

1824: BETWEEN m.start_date_active
1825: AND NVL(m.end_date_active,p_item_date)
1826: UNION ALL
1827: SELECT NULL b_rate,
1828: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1829: (m2.labor_multiplier * decode(p_mcb_flag,'Y',l_mcb_raw_cost,p_raw_cost)),
1830: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code)) r_revenue,
1831: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code) curr_code
1832: FROM pa_labor_multipliers m2

Line 1921: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)

1917: (b.rate * NVL(p_bill_rate_multiplier,1) *
1918: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
1919: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1920: DECODE(b.rate, NULL,
1921: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)
1922: * (l_mcb_raw_cost / 100)
1923: * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100),
1924: l_mcb_currency_code),
1925: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((b.rate * p_quantity) *

Line 1925: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((b.rate * p_quantity) *

1921: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)
1922: * (l_mcb_raw_cost / 100)
1923: * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100),
1924: l_mcb_currency_code),
1925: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((b.rate * p_quantity) *
1926: NVL(p_bill_rate_multiplier,1) *
1927: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100),
1928: b.rate_currency_code))),
1929: DECODE(b.rate, NULL,l_mcb_currency_code,b.rate_currency_code) /* Added for MCB2-Added for bug 2697945 */,

Line 1965: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)

1961: (b.rate * NVL(p_bill_rate_multiplier,1) *
1962: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
1963: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1964: DECODE(b.rate, NULL,
1965: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)
1966: * (p_raw_cost / 100) * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100), l_projfunc_currency_Code),
1967: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((b.rate * p_quantity)* NVL(p_bill_rate_multiplier,1)* (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100), b.rate_currency_code))),
1968: DECODE(b.rate, NULL,l_projfunc_currency_code,b.rate_currency_code) /* Added for MCB2 */,
1969: b.markup_percentage ,/* Added for Asgmt overide */

Line 1967: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((b.rate * p_quantity)* NVL(p_bill_rate_multiplier,1)* (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100), b.rate_currency_code))),

1963: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1964: DECODE(b.rate, NULL,
1965: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)
1966: * (p_raw_cost / 100) * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100), l_projfunc_currency_Code),
1967: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((b.rate * p_quantity)* NVL(p_bill_rate_multiplier,1)* (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100), b.rate_currency_code))),
1968: DECODE(b.rate, NULL,l_projfunc_currency_code,b.rate_currency_code) /* Added for MCB2 */,
1969: b.markup_percentage ,/* Added for Asgmt overide */
1970: DECODE(l_discount_percentage,NULL,'B','O'),
1971: nvl(l_discount_percentage,l_labor_schdl_discnt)

Line 2977: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)

2973: CURSOR C_Nl_Bill_Rate_Overrides_Mcb IS
2974: SELECT DECODE(o.bill_rate, NULL, NULL,o.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
2975: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
2976: DECODE(o.bill_rate, NULL,
2977: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
2978: * (DECODE(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
2979: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2980: * p_quantity , o.rate_currency_code)) r_revenue,
2981: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,

Line 2979: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)

2975: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
2976: DECODE(o.bill_rate, NULL,
2977: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
2978: * (DECODE(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
2979: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2980: * p_quantity , o.rate_currency_code)) r_revenue,
2981: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
2982: o.discount_percentage discount_pct
2983: FROM pa_nl_bill_rate_overrides o

Line 2998: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)

2994:
2995: SELECT DECODE(o.bill_rate, NULL,NULL, o.bill_rate * NVL(p_bill_rate_multiplier,1)),
2996: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
2997: DECODE(o.bill_rate, NULL,
2998: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
2999: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3000: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3001: * p_quantity, o.rate_currency_code)),
3002: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,

Line 3000: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)

2996: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
2997: DECODE(o.bill_rate, NULL,
2998: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
2999: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3000: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3001: * p_quantity, o.rate_currency_code)),
3002: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
3003: o.discount_percentage discount_pct
3004: FROM pa_nl_bill_rate_overrides o

Line 3031: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)

3027:
3028: SELECT DECODE(o2.bill_rate, NULL,NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3029: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3030: DECODE(o2.bill_rate, NULL,
3031: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3032: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3033: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3034: * p_quantity, o2.rate_currency_code)),
3035: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,

Line 3033: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)

3029: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3030: DECODE(o2.bill_rate, NULL,
3031: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3032: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3033: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3034: * p_quantity, o2.rate_currency_code)),
3035: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3036: o2.discount_percentage discount_pct
3037: FROM pa_nl_bill_rate_overrides o2

Line 3063: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)

3059:
3060: SELECT DECODE(o2.bill_rate, NULL,NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3061: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3062: DECODE(o2.bill_rate, NULL,
3063: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3064: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3065: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3066: * p_quantity, o2.rate_currency_code)) r_revenue,
3067: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,

Line 3065: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)

3061: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3062: DECODE(o2.bill_rate, NULL,
3063: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3064: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3065: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3066: * p_quantity, o2.rate_currency_code)) r_revenue,
3067: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3068: o2.discount_percentage discount_pct
3069: FROM pa_nl_bill_rate_overrides o2

Line 3107: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)

3103: CURSOR C_Nl_Bill_Rate_Overrides IS
3104: SELECT DECODE(o.bill_rate, NULL, NULL, o.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3105: DECODE(o.markup_percentage, NULL, NULL, o.markup_percentage) b_markup,
3106: DECODE(o.bill_rate,NULL,
3107: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3108: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3109: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3110: * p_quantity, o.rate_currency_code)) r_revenue,
3111: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,

Line 3109: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)

3105: DECODE(o.markup_percentage, NULL, NULL, o.markup_percentage) b_markup,
3106: DECODE(o.bill_rate,NULL,
3107: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3108: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3109: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3110: * p_quantity, o.rate_currency_code)) r_revenue,
3111: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,
3112: o.discount_percentage discount_pct
3113: FROM pa_nl_bill_rate_overrides o

Line 3126: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)

3122: UNION
3123: SELECT DECODE(o.bill_rate, NULL,NULL, o.bill_rate * NVL(p_bill_rate_multiplier,1)),
3124: DECODE(o.markup_percentage, NULL, NULL, o.markup_percentage) b_markup,
3125: DECODE(o.bill_rate, NULL,
3126: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3127: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3128: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3129: * p_quantity, o.rate_currency_code)),
3130: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code ,

Line 3128: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)

3124: DECODE(o.markup_percentage, NULL, NULL, o.markup_percentage) b_markup,
3125: DECODE(o.bill_rate, NULL,
3126: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3127: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3128: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3129: * p_quantity, o.rate_currency_code)),
3130: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code ,
3131: o.discount_percentage discount_pct
3132: FROM pa_nl_bill_rate_overrides o

Line 3157: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)

3153: UNION
3154: SELECT DECODE(o2.bill_rate, NULL,NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3155: DECODE(o2.markup_percentage, NULL, NULL, o2.markup_percentage) b_markup,
3156: DECODE(o2.bill_rate, NULL,
3157: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3158: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3159: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3160: * p_quantity, o2.rate_currency_code)),
3161: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code ,

Line 3159: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)

3155: DECODE(o2.markup_percentage, NULL, NULL, o2.markup_percentage) b_markup,
3156: DECODE(o2.bill_rate, NULL,
3157: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3158: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3159: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3160: * p_quantity, o2.rate_currency_code)),
3161: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code ,
3162: o2.discount_percentage discount_pct
3163: FROM pa_nl_bill_rate_overrides o2

Line 3187: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)

3183: UNION
3184: SELECT DECODE(o2.bill_rate, NULL,NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3185: DECODE(o2.markup_percentage, NULL, NULL, o2.markup_percentage) b_markup,
3186: DECODE(o2.bill_rate, NULL,
3187: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3188: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100), p_proj_func_currency),
3189: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3190: * p_quantity, o2.rate_currency_code)),
3191: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,

Line 3189: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)

3185: DECODE(o2.markup_percentage, NULL, NULL, o2.markup_percentage) b_markup,
3186: DECODE(o2.bill_rate, NULL,
3187: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3188: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100), p_proj_func_currency),
3189: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3190: * p_quantity, o2.rate_currency_code)),
3191: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,
3192: o2.discount_percentage discount_pct
3193: FROM pa_nl_bill_rate_overrides o2

Line 3337: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)

3333: CURSOR C_Std_Non_Labor_Mcb IS
3334: SELECT DECODE(b.rate, NULL,NULL, b.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3335: DECODE(b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3336: DECODE(b.rate, NULL,
3337: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3338: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3339: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3340: * p_quantity, b.rate_currency_code)) r_revenue,
3341: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,

Line 3339: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

3335: DECODE(b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3336: DECODE(b.rate, NULL,
3337: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3338: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3339: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3340: * p_quantity, b.rate_currency_code)) r_revenue,
3341: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3342: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3343: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100 , b.rate_currency_code)) adjusted_rate,

Line 3342: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

3338: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3339: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3340: * p_quantity, b.rate_currency_code)) r_revenue,
3341: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3342: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3343: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100 , b.rate_currency_code)) adjusted_rate,
3344: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3345: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3346: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)

Line 3345: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)

3341: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3342: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3343: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100 , b.rate_currency_code)) adjusted_rate,
3344: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3345: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3346: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3347: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), l_mcb_currency_code),
3348: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3349: * NVL(p_bill_rate_multiplier,1)

Line 3348: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)

3344: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3345: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3346: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3347: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), l_mcb_currency_code),
3348: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3349: * NVL(p_bill_rate_multiplier,1)
3350: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))) trans_adjusted_revenue,
3351: DECODE(b.rate, NULL, l_mcb_currency_code, b.rate_currency_code) rate_currency_code,
3352: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct

Line 3368: DECODE(b2.rate, NULL, PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)

3364: UNION
3365:
3366: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)),
3367: DECODE(b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3368: DECODE(b2.rate, NULL, PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3369: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3370: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3371: * p_quantity, b2.rate_currency_code)),
3372: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,

Line 3370: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)

3366: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)),
3367: DECODE(b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3368: DECODE(b2.rate, NULL, PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3369: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3370: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3371: * p_quantity, b2.rate_currency_code)),
3372: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3373: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3374: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),

Line 3373: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)

3369: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3370: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3371: * p_quantity, b2.rate_currency_code)),
3372: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3373: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3374: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3375: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,DECODE(b2.rate, NULL,
3376: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage) *
3377: (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)

Line 3376: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage) *

3372: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3373: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3374: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3375: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,DECODE(b2.rate, NULL,
3376: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage) *
3377: (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3378: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100), l_mcb_currency_code),
3379: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3380: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),

Line 3379: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)

3375: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,DECODE(b2.rate, NULL,
3376: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage) *
3377: (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3378: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100), l_mcb_currency_code),
3379: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3380: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3381: DECODE(b2.rate, NULL, l_mcb_currency_code, b2.rate_currency_code) rate_currency_code,
3382: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct
3383: FROM pa_bill_rates_all b2

Line 3411: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)

3407: CURSOR C_Std_Non_Labor IS
3408: SELECT DECODE(b.rate, NULL,NULL, b.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3409: DECODE(b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3410: DECODE(b.rate, NULL,
3411: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3412: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3413: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3414: * p_quantity, b.rate_currency_code)) r_revenue,
3415: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,

Line 3413: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

3409: DECODE(b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3410: DECODE(b.rate, NULL,
3411: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3412: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3413: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3414: * p_quantity, b.rate_currency_code)) r_revenue,
3415: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3416: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3417: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,

Line 3416: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

3412: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3413: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3414: * p_quantity, b.rate_currency_code)) r_revenue,
3415: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3416: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3417: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,
3418: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3419: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3420: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)

Line 3419: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3415: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3416: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3417: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,
3418: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3419: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3420: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3421: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), p_proj_func_currency ),
3422: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3423: * NVL(p_bill_rate_multiplier,1)

Line 3422: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)

3418: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3419: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3420: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3421: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), p_proj_func_currency ),
3422: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3423: * NVL(p_bill_rate_multiplier,1)
3424: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))) trans_adjusted_revenue,
3425: DECODE(b.rate, NULL, p_proj_func_currency, b.rate_currency_code) rate_currency_code,
3426: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct

Line 3443: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)

3439:
3440: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)),
3441: DECODE(b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3442: DECODE(b2.rate, NULL,
3443: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3444: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),
3445: p_proj_func_currency),
3446: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3447: * p_quantity, b2.rate_currency_code)),

Line 3446: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)

3442: DECODE(b2.rate, NULL,
3443: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3444: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),
3445: p_proj_func_currency),
3446: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3447: * p_quantity, b2.rate_currency_code)),
3448: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3449: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3450: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),

Line 3449: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)

3445: p_proj_func_currency),
3446: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3447: * p_quantity, b2.rate_currency_code)),
3448: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3449: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3450: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3451: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,DECODE(b2.rate, NULL,
3452: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3453: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)

Line 3452: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)

3448: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3449: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3450: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3451: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,DECODE(b2.rate, NULL,
3452: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3453: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3454: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100)
3455: ,p_proj_func_currency),
3456: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)

Line 3456: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)

3452: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3453: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3454: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100)
3455: ,p_proj_func_currency),
3456: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3457: * NVL(p_bill_rate_multiplier,1)
3458: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3459: DECODE(b2.rate, NULL, p_proj_func_currency, b2.rate_currency_code) rate_currency_code,
3460: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct

Line 3581: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)

3577: CURSOR C_Exp_Type_Overrides_Ncb IS
3578: SELECT DECODE(o.bill_rate, NULL, NULL,o.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3579: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
3580: DECODE(o.bill_rate, NULL,
3581: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3582: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3583: l_mcb_currency_code),
3584: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3585: * p_quantity, o.rate_currency_code)) r_revenue,

Line 3584: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)

3580: DECODE(o.bill_rate, NULL,
3581: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3582: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3583: l_mcb_currency_code),
3584: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3585: * p_quantity, o.rate_currency_code)) r_revenue,
3586: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
3587: o.discount_percentage discount_pct
3588: FROM pa_nl_bill_rate_overrides o

Line 3603: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)

3599:
3600: SELECT DECODE(o2.bill_rate, NULL, NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3601: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3602: DECODE(o2.bill_rate, NULL,
3603: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3604: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3605: l_mcb_currency_code),
3606: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3607: * p_quantity, o2.rate_currency_code)),

Line 3606: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)

3602: DECODE(o2.bill_rate, NULL,
3603: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3604: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3605: l_mcb_currency_code),
3606: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3607: * p_quantity, o2.rate_currency_code)),
3608: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3609: o2.discount_percentage
3610: FROM pa_nl_bill_rate_overrides o2

Line 3637: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)

3633: CURSOR C_Exp_Type_Overrides IS
3634: SELECT DECODE(o.bill_rate, NULL, NULL,o.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3635: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
3636: DECODE(o.bill_rate, NULL,
3637: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3638: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3639: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3640: * p_quantity, o.rate_currency_code)) r_revenue,
3641: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,

Line 3639: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)

3635: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
3636: DECODE(o.bill_rate, NULL,
3637: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3638: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3639: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3640: * p_quantity, o.rate_currency_code)) r_revenue,
3641: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,
3642: o.discount_percentage discount_pct
3643: FROM pa_nl_bill_rate_overrides o

Line 3658: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)

3654:
3655: SELECT DECODE(o2.bill_rate, NULL, NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3656: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3657: DECODE(o2.bill_rate, NULL,
3658: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3659: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3660: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3661: * p_quantity, o2.rate_currency_code)),
3662: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,

Line 3660: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)

3656: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3657: DECODE(o2.bill_rate, NULL,
3658: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3659: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3660: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3661: * p_quantity, o2.rate_currency_code)),
3662: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,
3663: o2.discount_percentage
3664: FROM pa_nl_bill_rate_overrides o2

Line 3788: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)

3784: CURSOR C_Std_Exp_Type_Sch_Ncb IS
3785: SELECT DECODE (b.rate, NULL,NULL, b.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3786: DECODE (b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3787: DECODE (b.rate, NULL,
3788: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3789: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3790: l_mcb_currency_code) ,
3791: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3792: * p_quantity, b.rate_currency_code)) r_revenue,

Line 3791: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

3787: DECODE (b.rate, NULL,
3788: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3789: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3790: l_mcb_currency_code) ,
3791: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3792: * p_quantity, b.rate_currency_code)) r_revenue,
3793: DECODE (NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3794: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3795: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code) ) adjusted_rate ,

Line 3794: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

3790: l_mcb_currency_code) ,
3791: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3792: * p_quantity, b.rate_currency_code)) r_revenue,
3793: DECODE (NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3794: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3795: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code) ) adjusted_rate ,
3796: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3797: DECODE(b.rate, NULL,
3798: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 3798: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3794: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3795: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code) ) adjusted_rate ,
3796: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3797: DECODE(b.rate, NULL,
3798: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3799: (100 + b.markup_percentage) * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3800: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), l_mcb_currency_code),
3801: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3802: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))

Line 3801: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)

3797: DECODE(b.rate, NULL,
3798: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3799: (100 + b.markup_percentage) * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3800: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), l_mcb_currency_code),
3801: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3802: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))
3803: ) trans_adjusted_amount,
3804: DECODE(b.rate, NULL, l_mcb_currency_code, b.rate_currency_code) rate_currency_code ,
3805: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct

Line 3822: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)

3818:
3819: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3820: DECODE (b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3821: DECODE(b2.rate, NULL,
3822: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3823: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3824: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3825: * p_quantity, b2.rate_currency_code)) r_revenue,
3826: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,

Line 3824: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)

3820: DECODE (b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3821: DECODE(b2.rate, NULL,
3822: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3823: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3824: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3825: * p_quantity, b2.rate_currency_code)) r_revenue,
3826: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3827: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3828: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)) adjusted_rate,

Line 3827: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)

3823: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3824: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3825: * p_quantity, b2.rate_currency_code)) r_revenue,
3826: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3827: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3828: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)) adjusted_rate,
3829: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3830: DECODE(b2.rate, NULL,
3831: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 3831: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3827: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3828: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)) adjusted_rate,
3829: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3830: DECODE(b2.rate, NULL,
3831: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3832: (100 + b2.markup_percentage) * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3833: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100),l_mcb_currency_code),
3834: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3835: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100,

Line 3834: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)

3830: DECODE(b2.rate, NULL,
3831: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3832: (100 + b2.markup_percentage) * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3833: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100),l_mcb_currency_code),
3834: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3835: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100,
3836: b2.rate_currency_code))) trans_adjusted_amount,
3837: DECODE(b2.rate, NULL, l_mcb_currency_code, b2.rate_currency_code) rate_currency_code,
3838: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct

Line 3869: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)

3865: CURSOR C_Std_Exp_Type_Sch IS
3866: SELECT DECODE(b.rate, NULL,NULL, b.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3867: DECODE (b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3868: DECODE(b.rate, NULL,
3869: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3870: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3871: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3872: * p_quantity, b.rate_currency_code)) r_revenue,
3873: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,

Line 3871: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

3867: DECODE (b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3868: DECODE(b.rate, NULL,
3869: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3870: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3871: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3872: * p_quantity, b.rate_currency_code)) r_revenue,
3873: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3874: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3875: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,

Line 3874: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

3870: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3871: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3872: * p_quantity, b.rate_currency_code)) r_revenue,
3873: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3874: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3875: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,
3876: DECODE (NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,
3877: DECODE(b.rate, NULL,
3878: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 3878: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3874: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3875: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,
3876: DECODE (NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,
3877: DECODE(b.rate, NULL,
3878: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3879: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3880: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), p_proj_func_currency),
3881: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3882: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100,

Line 3881: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)

3877: DECODE(b.rate, NULL,
3878: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3879: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3880: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), p_proj_func_currency),
3881: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3882: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100,
3883: b.rate_currency_code))) trans_adjusted_amount,
3884: DECODE(b.rate, NULL, p_proj_func_currency, b.rate_currency_code) rate_currency_code ,
3885: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct

Line 3902: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)

3898:
3899: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)),
3900: DECODE (b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3901: DECODE(b2.rate, NULL,
3902: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3903: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3904: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3905: * p_quantity, b2.rate_currency_code)),
3906: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,

Line 3904: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)

3900: DECODE (b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3901: DECODE(b2.rate, NULL,
3902: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3903: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3904: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3905: * p_quantity, b2.rate_currency_code)),
3906: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3907: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3908: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),

Line 3907: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)

3903: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3904: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3905: * p_quantity, b2.rate_currency_code)),
3906: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3907: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3908: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3909: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,
3910: DECODE(b2.rate, NULL,
3911: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 3911: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3907: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3908: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3909: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,
3910: DECODE(b2.rate, NULL,
3911: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3912: (100 + b2.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3913: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100), p_proj_func_currency),
3914: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3915: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),

Line 3914: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)

3910: DECODE(b2.rate, NULL,
3911: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3912: (100 + b2.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3913: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100), p_proj_func_currency),
3914: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3915: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3916: DECODE(b2.rate, NULL, p_proj_func_currency, b2.rate_currency_code) rate_currency_code,
3917: NVL(l_rate_discount_pct,p_project_sch_discount)
3918: FROM pa_bill_rates_all b2