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 1114: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)

1110: BEGIN
1111: SELECT DECODE(asgn.bill_rate_override, NULL, NULL,
1112: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)),
1113: DECODE(asgn.bill_rate_override, NULL,
1114: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1115: * l_mcb_raw_cost / 100),l_mcb_currency_code),
1116: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT ((asgn.bill_rate_override *
1117: NVL(p_bill_rate_multiplier,1) * p_quantity),asgn.bill_rate_curr_override)),
1118: DECODE(asgn.bill_rate_override,NULL,l_mcb_currency_code,asgn.bill_rate_curr_override),

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

1112: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)),
1113: DECODE(asgn.bill_rate_override, NULL,
1114: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1115: * l_mcb_raw_cost / 100),l_mcb_currency_code),
1116: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT ((asgn.bill_rate_override *
1117: NVL(p_bill_rate_multiplier,1) * p_quantity),asgn.bill_rate_curr_override)),
1118: DECODE(asgn.bill_rate_override,NULL,l_mcb_currency_code,asgn.bill_rate_curr_override),
1119: asgn.markup_percent_override,
1120: 'O',

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

1139: SELECT DECODE(asgn.bill_rate_override, NULL, NULL,
1140: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)
1141: ),
1142: DECODE(asgn.bill_rate_override, NULL,
1143: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1144: * p_raw_cost / 100),l_projfunc_currency_code),
1145: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1146: * NVL(p_bill_rate_multiplier,1)
1147: * p_quantity),asgn.bill_rate_curr_override)),

Line 1145: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override

1141: ),
1142: DECODE(asgn.bill_rate_override, NULL,
1143: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1144: * p_raw_cost / 100),l_projfunc_currency_code),
1145: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1146: * NVL(p_bill_rate_multiplier,1)
1147: * p_quantity),asgn.bill_rate_curr_override)),
1148: DECODE(asgn.bill_rate_override,NULL,l_projfunc_currency_code,asgn.bill_rate_curr_override),
1149: asgn.markup_percent_override,

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

1195: -- This cursor will select the bill rate and raw revenue on the basis of passed parameters i.e.
1196: -- if task id is not null then select will bring the task id row
1197:
1198: CURSOR C_Task IS SELECT o.rate * NVL(p_bill_rate_multiplier,1) b_rate,
1199: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((o.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),o.rate_currency_code) r_revenue,
1200: o.rate_currency_code,
1201: 'O',
1202: o.discount_percentage
1203: FROM pa_emp_bill_rate_overrides o

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

1280: BEGIN
1281: SELECT DECODE(asgn.bill_rate_override, NULL, NULL,
1282: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)),
1283: DECODE(asgn.bill_rate_override, NULL,
1284: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1285: * l_mcb_raw_cost / 100),l_mcb_currency_code),
1286: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1287: * NVL(p_bill_rate_multiplier,1)
1288: * p_quantity),asgn.bill_rate_curr_override)),

Line 1286: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override

1282: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)),
1283: DECODE(asgn.bill_rate_override, NULL,
1284: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1285: * l_mcb_raw_cost / 100),l_mcb_currency_code),
1286: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1287: * NVL(p_bill_rate_multiplier,1)
1288: * p_quantity),asgn.bill_rate_curr_override)),
1289: DECODE(asgn.bill_rate_override,NULL,l_mcb_currency_code,asgn.bill_rate_curr_override),
1290: asgn.markup_percent_override,

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

1310: SELECT DECODE(asgn.bill_rate_override, NULL, NULL,
1311: asgn.bill_rate_override * NVL(p_bill_rate_multiplier,1)
1312: ),
1313: DECODE(asgn.bill_rate_override, NULL,
1314: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1315: * p_raw_cost / 100),l_projfunc_currency_code),
1316: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1317: * NVL(p_bill_rate_multiplier,1)
1318: * p_quantity),asgn.bill_rate_curr_override)),

Line 1316: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override

1312: ),
1313: DECODE(asgn.bill_rate_override, NULL,
1314: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + asgn.markup_percent_override)
1315: * p_raw_cost / 100),l_projfunc_currency_code),
1316: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((asgn.bill_rate_override
1317: * NVL(p_bill_rate_multiplier,1)
1318: * p_quantity),asgn.bill_rate_curr_override)),
1319: DECODE(asgn.bill_rate_override,NULL,l_projfunc_currency_code,asgn.bill_rate_curr_override),
1320: asgn.markup_percent_override,

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

1359: -- task level select
1360:
1361: CURSOR C_Project IS
1362: SELECT o2.rate * NVL(p_bill_rate_multiplier,1) b_rate,
1363: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((o2.rate *
1364: NVL(p_bill_rate_multiplier,1) * p_quantity),o2.rate_currency_code) r_revenue,
1365: o2.rate_currency_code,
1366: 'O',
1367: o2.discount_percentage

Line 1797: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

1793: -- null then first select will bring the task id row and second select
1794: -- will bring all the raws ( If exists ) except the row which is already selected in first select
1795:
1796: CURSOR C1 IS( SELECT NULL b_rate,
1797: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1798: (m.labor_multiplier * decode(p_mcb_flag,'Y',l_mcb_raw_cost,p_raw_cost)),
1799: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code)) r_revenue,
1800: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code) curr_code
1801: FROM pa_labor_multipliers m

Line 1809: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

1805: BETWEEN m.start_date_active
1806: AND NVL(m.end_date_active,p_item_date)
1807: UNION ALL
1808: SELECT NULL b_rate,
1809: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1810: (m2.labor_multiplier * decode(p_mcb_flag,'Y',l_mcb_raw_cost,p_raw_cost)),
1811: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code)) r_revenue,
1812: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code) curr_code
1813: FROM pa_labor_multipliers m2

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

1898: (b.rate * NVL(p_bill_rate_multiplier,1) *
1899: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
1900: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1901: DECODE(b.rate, NULL,
1902: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)
1903: * (l_mcb_raw_cost / 100)
1904: * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100),
1905: l_mcb_currency_code),
1906: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((b.rate * p_quantity) *

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

1902: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)
1903: * (l_mcb_raw_cost / 100)
1904: * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100),
1905: l_mcb_currency_code),
1906: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((b.rate * p_quantity) *
1907: NVL(p_bill_rate_multiplier,1) *
1908: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100),
1909: b.rate_currency_code))),
1910: DECODE(b.rate, NULL,l_mcb_currency_code,b.rate_currency_code) /* Added for MCB2-Added for bug 2697945 */,

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

1942: (b.rate * NVL(p_bill_rate_multiplier,1) *
1943: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
1944: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1945: DECODE(b.rate, NULL,
1946: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)
1947: * (p_raw_cost / 100) * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100), l_projfunc_currency_Code),
1948: 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))),
1949: DECODE(b.rate, NULL,l_projfunc_currency_code,b.rate_currency_code) /* Added for MCB2 */,
1950: b.markup_percentage ,/* Added for Asgmt overide */

Line 1948: 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))),

1944: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1945: DECODE(b.rate, NULL,
1946: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(((100 + b.markup_percentage)
1947: * (p_raw_cost / 100) * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100), l_projfunc_currency_Code),
1948: 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))),
1949: DECODE(b.rate, NULL,l_projfunc_currency_code,b.rate_currency_code) /* Added for MCB2 */,
1950: b.markup_percentage ,/* Added for Asgmt overide */
1951: DECODE(l_discount_percentage,NULL,'B','O'),
1952: nvl(l_discount_percentage,l_labor_schdl_discnt)

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

2947: CURSOR C_Nl_Bill_Rate_Overrides_Mcb IS
2948: SELECT DECODE(o.bill_rate, NULL, NULL,o.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
2949: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
2950: DECODE(o.bill_rate, NULL,
2951: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
2952: * (DECODE(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
2953: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2954: * p_quantity , o.rate_currency_code)) r_revenue,
2955: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,

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

2949: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
2950: DECODE(o.bill_rate, NULL,
2951: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
2952: * (DECODE(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
2953: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2954: * p_quantity , o.rate_currency_code)) r_revenue,
2955: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
2956: o.discount_percentage discount_pct
2957: FROM pa_nl_bill_rate_overrides o

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

2968:
2969: SELECT DECODE(o.bill_rate, NULL,NULL, o.bill_rate * NVL(p_bill_rate_multiplier,1)),
2970: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
2971: DECODE(o.bill_rate, NULL,
2972: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
2973: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
2974: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2975: * p_quantity, o.rate_currency_code)),
2976: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,

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

2970: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
2971: DECODE(o.bill_rate, NULL,
2972: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
2973: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
2974: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2975: * p_quantity, o.rate_currency_code)),
2976: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
2977: o.discount_percentage discount_pct
2978: FROM pa_nl_bill_rate_overrides o

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

3001:
3002: SELECT DECODE(o2.bill_rate, NULL,NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3003: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3004: DECODE(o2.bill_rate, NULL,
3005: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3006: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3007: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3008: * p_quantity, o2.rate_currency_code)),
3009: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,

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

3003: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3004: DECODE(o2.bill_rate, NULL,
3005: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3006: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3007: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3008: * p_quantity, o2.rate_currency_code)),
3009: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3010: o2.discount_percentage discount_pct
3011: FROM pa_nl_bill_rate_overrides o2

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

3033:
3034: SELECT DECODE(o2.bill_rate, NULL,NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3035: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3036: DECODE(o2.bill_rate, NULL,
3037: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3038: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3039: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3040: * p_quantity, o2.rate_currency_code)) r_revenue,
3041: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,

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

3035: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3036: DECODE(o2.bill_rate, NULL,
3037: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3038: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3039: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3040: * p_quantity, o2.rate_currency_code)) r_revenue,
3041: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3042: o2.discount_percentage discount_pct
3043: FROM pa_nl_bill_rate_overrides o2

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

3077: CURSOR C_Nl_Bill_Rate_Overrides IS
3078: SELECT DECODE(o.bill_rate, NULL, NULL, o.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3079: DECODE(o.markup_percentage, NULL, NULL, o.markup_percentage) b_markup,
3080: DECODE(o.bill_rate,NULL,
3081: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3082: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3083: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3084: * p_quantity, o.rate_currency_code)) r_revenue,
3085: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,

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

3079: DECODE(o.markup_percentage, NULL, NULL, o.markup_percentage) b_markup,
3080: DECODE(o.bill_rate,NULL,
3081: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3082: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3083: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3084: * p_quantity, o.rate_currency_code)) r_revenue,
3085: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,
3086: o.discount_percentage discount_pct
3087: FROM pa_nl_bill_rate_overrides o

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

3096: UNION
3097: SELECT DECODE(o.bill_rate, NULL,NULL, o.bill_rate * NVL(p_bill_rate_multiplier,1)),
3098: DECODE(o.markup_percentage, NULL, NULL, o.markup_percentage) b_markup,
3099: DECODE(o.bill_rate, NULL,
3100: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3101: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3102: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3103: * p_quantity, o.rate_currency_code)),
3104: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code ,

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

3098: DECODE(o.markup_percentage, NULL, NULL, o.markup_percentage) b_markup,
3099: DECODE(o.bill_rate, NULL,
3100: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3101: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3102: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3103: * p_quantity, o.rate_currency_code)),
3104: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code ,
3105: o.discount_percentage discount_pct
3106: FROM pa_nl_bill_rate_overrides o

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

3127: UNION
3128: SELECT DECODE(o2.bill_rate, NULL,NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3129: DECODE(o2.markup_percentage, NULL, NULL, o2.markup_percentage) b_markup,
3130: DECODE(o2.bill_rate, NULL,
3131: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3132: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3133: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3134: * p_quantity, o2.rate_currency_code)),
3135: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code ,

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

3129: DECODE(o2.markup_percentage, NULL, NULL, o2.markup_percentage) b_markup,
3130: DECODE(o2.bill_rate, NULL,
3131: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3132: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3133: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3134: * p_quantity, o2.rate_currency_code)),
3135: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code ,
3136: o2.discount_percentage discount_pct
3137: FROM pa_nl_bill_rate_overrides o2

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

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

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

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

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

3307: CURSOR C_Std_Non_Labor_Mcb IS
3308: SELECT DECODE(b.rate, NULL,NULL, b.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3309: DECODE(b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3310: DECODE(b.rate, NULL,
3311: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3312: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3313: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3314: * p_quantity, b.rate_currency_code)) r_revenue,
3315: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,

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

3309: DECODE(b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3310: DECODE(b.rate, NULL,
3311: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3312: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3313: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3314: * p_quantity, b.rate_currency_code)) r_revenue,
3315: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3316: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3317: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100 , b.rate_currency_code)) adjusted_rate,

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

3312: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3313: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3314: * p_quantity, b.rate_currency_code)) r_revenue,
3315: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3316: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3317: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100 , b.rate_currency_code)) adjusted_rate,
3318: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3319: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3320: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)

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

3315: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3316: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3317: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100 , b.rate_currency_code)) adjusted_rate,
3318: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3319: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3320: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3321: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), l_mcb_currency_code),
3322: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3323: * NVL(p_bill_rate_multiplier,1)

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

3318: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3319: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3320: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3321: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), l_mcb_currency_code),
3322: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3323: * NVL(p_bill_rate_multiplier,1)
3324: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))) trans_adjusted_revenue,
3325: DECODE(b.rate, NULL, l_mcb_currency_code, b.rate_currency_code) rate_currency_code,
3326: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct

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

3338: UNION
3339:
3340: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)),
3341: DECODE(b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3342: DECODE(b2.rate, NULL, PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3343: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3344: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3345: * p_quantity, b2.rate_currency_code)),
3346: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,

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

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

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

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

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

3346: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3347: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3348: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3349: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,DECODE(b2.rate, NULL,
3350: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage) *
3351: (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3352: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100), l_mcb_currency_code),
3353: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3354: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),

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

3349: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,DECODE(b2.rate, NULL,
3350: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage) *
3351: (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3352: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100), l_mcb_currency_code),
3353: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3354: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3355: DECODE(b2.rate, NULL, l_mcb_currency_code, b2.rate_currency_code) rate_currency_code,
3356: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct
3357: FROM pa_bill_rates_all b2

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

3381: CURSOR C_Std_Non_Labor IS
3382: SELECT DECODE(b.rate, NULL,NULL, b.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3383: DECODE(b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3384: DECODE(b.rate, NULL,
3385: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3386: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3387: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3388: * p_quantity, b.rate_currency_code)) r_revenue,
3389: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,

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

3383: DECODE(b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3384: DECODE(b.rate, NULL,
3385: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3386: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3387: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3388: * p_quantity, b.rate_currency_code)) r_revenue,
3389: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3390: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3391: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,

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

3386: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3387: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3388: * p_quantity, b.rate_currency_code)) r_revenue,
3389: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3390: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3391: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,
3392: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3393: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3394: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)

Line 3393: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3389: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3390: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3391: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,
3392: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3393: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3394: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3395: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), p_proj_func_currency ),
3396: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3397: * NVL(p_bill_rate_multiplier,1)

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

3392: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,DECODE(b.rate, NULL,
3393: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3394: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3395: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), p_proj_func_currency ),
3396: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3397: * NVL(p_bill_rate_multiplier,1)
3398: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))) trans_adjusted_revenue,
3399: DECODE(b.rate, NULL, p_proj_func_currency, b.rate_currency_code) rate_currency_code,
3400: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct

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

3413:
3414: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)),
3415: DECODE(b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3416: DECODE(b2.rate, NULL,
3417: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3418: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),
3419: p_proj_func_currency),
3420: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3421: * p_quantity, b2.rate_currency_code)),

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

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

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

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

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

3422: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3423: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3424: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3425: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,DECODE(b2.rate, NULL,
3426: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3427: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3428: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100)
3429: ,p_proj_func_currency),
3430: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)

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

3426: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3427: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3428: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100)
3429: ,p_proj_func_currency),
3430: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3431: * NVL(p_bill_rate_multiplier,1)
3432: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3433: DECODE(b2.rate, NULL, p_proj_func_currency, b2.rate_currency_code) rate_currency_code,
3434: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct

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

3551: CURSOR C_Exp_Type_Overrides_Ncb IS
3552: SELECT DECODE(o.bill_rate, NULL, NULL,o.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3553: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
3554: DECODE(o.bill_rate, NULL,
3555: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3556: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3557: l_mcb_currency_code),
3558: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3559: * p_quantity, o.rate_currency_code)) r_revenue,

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

3554: DECODE(o.bill_rate, NULL,
3555: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3556: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3557: l_mcb_currency_code),
3558: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3559: * p_quantity, o.rate_currency_code)) r_revenue,
3560: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
3561: o.discount_percentage discount_pct
3562: FROM pa_nl_bill_rate_overrides o

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

3573:
3574: SELECT DECODE(o2.bill_rate, NULL, NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3575: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3576: DECODE(o2.bill_rate, NULL,
3577: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3578: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3579: l_mcb_currency_code),
3580: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3581: * p_quantity, o2.rate_currency_code)),

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

3576: DECODE(o2.bill_rate, NULL,
3577: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3578: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3579: l_mcb_currency_code),
3580: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3581: * p_quantity, o2.rate_currency_code)),
3582: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3583: o2.discount_percentage
3584: FROM pa_nl_bill_rate_overrides o2

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

3607: CURSOR C_Exp_Type_Overrides IS
3608: SELECT DECODE(o.bill_rate, NULL, NULL,o.bill_rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3609: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
3610: DECODE(o.bill_rate, NULL,
3611: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3612: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3613: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3614: * p_quantity, o.rate_currency_code)) r_revenue,
3615: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,

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

3609: DECODE(o.markup_percentage, NULL, NULL,o.markup_percentage ) b_markup,
3610: DECODE(o.bill_rate, NULL,
3611: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o.markup_percentage)
3612: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3613: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3614: * p_quantity, o.rate_currency_code)) r_revenue,
3615: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,
3616: o.discount_percentage discount_pct
3617: FROM pa_nl_bill_rate_overrides o

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

3628:
3629: SELECT DECODE(o2.bill_rate, NULL, NULL,o2.bill_rate * NVL(p_bill_rate_multiplier,1)),
3630: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3631: DECODE(o2.bill_rate, NULL,
3632: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3633: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3634: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3635: * p_quantity, o2.rate_currency_code)),
3636: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,

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

3630: DECODE(o2.markup_percentage, NULL, NULL,o2.markup_percentage ) b_markup,
3631: DECODE(o2.bill_rate, NULL,
3632: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + o2.markup_percentage)
3633: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3634: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3635: * p_quantity, o2.rate_currency_code)),
3636: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,
3637: o2.discount_percentage
3638: FROM pa_nl_bill_rate_overrides o2

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

3758: CURSOR C_Std_Exp_Type_Sch_Ncb IS
3759: SELECT DECODE (b.rate, NULL,NULL, b.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3760: DECODE (b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3761: DECODE (b.rate, NULL,
3762: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3763: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3764: l_mcb_currency_code) ,
3765: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3766: * p_quantity, b.rate_currency_code)) r_revenue,

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

3761: DECODE (b.rate, NULL,
3762: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3763: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),
3764: l_mcb_currency_code) ,
3765: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3766: * p_quantity, b.rate_currency_code)) r_revenue,
3767: DECODE (NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3768: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3769: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code) ) adjusted_rate ,

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

3764: l_mcb_currency_code) ,
3765: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3766: * p_quantity, b.rate_currency_code)) r_revenue,
3767: DECODE (NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3768: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3769: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code) ) adjusted_rate ,
3770: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3771: DECODE(b.rate, NULL,
3772: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 3772: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3768: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3769: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code) ) adjusted_rate ,
3770: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3771: DECODE(b.rate, NULL,
3772: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3773: (100 + b.markup_percentage) * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3774: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), l_mcb_currency_code),
3775: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3776: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))

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

3771: DECODE(b.rate, NULL,
3772: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3773: (100 + b.markup_percentage) * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3774: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), l_mcb_currency_code),
3775: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3776: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))
3777: ) trans_adjusted_amount,
3778: DECODE(b.rate, NULL, l_mcb_currency_code, b.rate_currency_code) rate_currency_code ,
3779: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct

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

3792:
3793: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3794: DECODE (b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3795: DECODE(b2.rate, NULL,
3796: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3797: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3798: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3799: * p_quantity, b2.rate_currency_code)) r_revenue,
3800: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,

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

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

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

3797: * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100),l_mcb_currency_code),
3798: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3799: * p_quantity, b2.rate_currency_code)) r_revenue,
3800: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3801: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3802: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)) adjusted_rate,
3803: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3804: DECODE(b2.rate, NULL,
3805: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 3805: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3801: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3802: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)) adjusted_rate,
3803: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,
3804: DECODE(b2.rate, NULL,
3805: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3806: (100 + b2.markup_percentage) * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3807: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100),l_mcb_currency_code),
3808: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3809: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100,

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

3804: DECODE(b2.rate, NULL,
3805: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3806: (100 + b2.markup_percentage) * (decode(p_sl_function,6,l_mcb_burdened_cost,l_mcb_raw_cost) / 100)
3807: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100),l_mcb_currency_code),
3808: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3809: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100,
3810: b2.rate_currency_code))) trans_adjusted_amount,
3811: DECODE(b2.rate, NULL, l_mcb_currency_code, b2.rate_currency_code) rate_currency_code,
3812: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct

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

3839: CURSOR C_Std_Exp_Type_Sch IS
3840: SELECT DECODE(b.rate, NULL,NULL, b.rate * NVL(p_bill_rate_multiplier,1)) b_rate,
3841: DECODE (b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3842: DECODE(b.rate, NULL,
3843: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3844: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3845: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3846: * p_quantity, b.rate_currency_code)) r_revenue,
3847: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,

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

3841: DECODE (b.markup_percentage, NULL,NULL, b.markup_percentage ) b_markup,
3842: DECODE(b.rate, NULL,
3843: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b.markup_percentage)
3844: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3845: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3846: * p_quantity, b.rate_currency_code)) r_revenue,
3847: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3848: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3849: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,

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

3844: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3845: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3846: * p_quantity, b.rate_currency_code)) r_revenue,
3847: DECODE(NVL(l_rate_discount_pct,p_task_sch_discount), NULL, NULL,
3848: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3849: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,
3850: DECODE (NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,
3851: DECODE(b.rate, NULL,
3852: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 3852: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3848: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
3849: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) /100, b.rate_currency_code)) adjusted_rate,
3850: DECODE (NVL(l_rate_discount_pct,p_task_sch_discount), NULL,NULL,
3851: DECODE(b.rate, NULL,
3852: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3853: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3854: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), p_proj_func_currency),
3855: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3856: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100,

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

3851: DECODE(b.rate, NULL,
3852: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3853: (100 + b.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3854: * ((100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100), p_proj_func_currency),
3855: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b.rate * p_quantity)
3856: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100,
3857: b.rate_currency_code))) trans_adjusted_amount,
3858: DECODE(b.rate, NULL, p_proj_func_currency, b.rate_currency_code) rate_currency_code ,
3859: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct

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

3872:
3873: SELECT DECODE(b2.rate, NULL, NULL,b2.rate * NVL(p_bill_rate_multiplier,1)),
3874: DECODE (b2.markup_percentage, NULL,NULL, b2.markup_percentage ) b_markup,
3875: DECODE(b2.rate, NULL,
3876: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((100 + b2.markup_percentage)
3877: * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100),p_proj_func_currency),
3878: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3879: * p_quantity, b2.rate_currency_code)),
3880: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL, NULL,

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

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

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

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

Line 3885: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

3881: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b2.rate * NVL(p_bill_rate_multiplier,1)
3882: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) /100, b2.rate_currency_code)),
3883: DECODE(NVL(l_rate_discount_pct,p_project_sch_discount), NULL,NULL,
3884: DECODE(b2.rate, NULL,
3885: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3886: (100 + b2.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3887: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100), p_proj_func_currency),
3888: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3889: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),

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

3884: DECODE(b2.rate, NULL,
3885: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
3886: (100 + b2.markup_percentage) * (decode(p_sl_function,6,p_burden_cost,p_raw_cost) / 100)
3887: * ((100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100), p_proj_func_currency),
3888: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3889: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3890: DECODE(b2.rate, NULL, p_proj_func_currency, b2.rate_currency_code) rate_currency_code,
3891: NVL(l_rate_discount_pct,p_project_sch_discount)
3892: FROM pa_bill_rates_all b2