3785: 'N', sbl.project_burdened_cost,
3786: 'A', sbl.burdened_cost)),
3787: sum(decode(l_txn_currency_flag,
3788: 'Y', sbl.quantity *
3789: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3790: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3791: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3792: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3793: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3787: sum(decode(l_txn_currency_flag,
3788: 'Y', sbl.quantity *
3789: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3790: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3791: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3792: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3793: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3794: sum(decode(l_txn_currency_flag,
3795: 'Y', sbl.quantity *
3789: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3790: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3791: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3792: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3793: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3794: sum(decode(l_txn_currency_flag,
3795: 'Y', sbl.quantity *
3796: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3797: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3853: 'N', sbl.project_burdened_cost,
3854: 'A', sbl.burdened_cost)),
3855: sum(decode(l_txn_currency_flag,
3856: 'Y', sbl.quantity *
3857: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3858: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3859: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3860: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3861: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3855: sum(decode(l_txn_currency_flag,
3856: 'Y', sbl.quantity *
3857: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3858: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3859: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3860: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3861: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3862: sum(decode(l_txn_currency_flag,
3863: 'Y', sbl.quantity *
3857: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3858: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3859: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3860: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3861: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3862: sum(decode(l_txn_currency_flag,
3863: 'Y', sbl.quantity *
3864: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3865: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3921: 'N', sbl.project_burdened_cost,
3922: 'A', sbl.burdened_cost)),
3923: sum(decode(l_txn_currency_flag,
3924: 'Y', sbl.quantity *
3925: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3926: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3927: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3928: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3929: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3923: sum(decode(l_txn_currency_flag,
3924: 'Y', sbl.quantity *
3925: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3926: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3927: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3928: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3929: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3930: sum(decode(l_txn_currency_flag,
3931: 'Y', sbl.quantity *
3925: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3926: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3927: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
3928: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
3929: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3930: sum(decode(l_txn_currency_flag,
3931: 'Y', sbl.quantity *
3932: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
3933: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
3994: 'N', sbl.project_burdened_cost,
3995: 'A', sbl.burdened_cost)),
3996: sum(decode(l_txn_currency_flag,
3997: 'Y', sbl.quantity *
3998: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3999: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4000: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4001: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4002: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
3996: sum(decode(l_txn_currency_flag,
3997: 'Y', sbl.quantity *
3998: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3999: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4000: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4001: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4002: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
4003: sum(decode(l_txn_currency_flag,
4004: 'Y', sbl.quantity *
3998: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
3999: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4000: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4001: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4002: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate))), --sbl.raw_cost
4003: sum(decode(l_txn_currency_flag,
4004: 'Y', sbl.quantity *
4005: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
4006: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4066: 'N', sbl.project_burdened_cost,
4067: 'A', sbl.burdened_cost))/pa_gl.multiplier),
4068: sum((decode(l_txn_currency_flag,
4069: 'Y', sbl.quantity *
4070: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4071: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4073: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4068: sum((decode(l_txn_currency_flag,
4069: 'Y', sbl.quantity *
4070: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4071: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4073: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4075: sum((decode(l_txn_currency_flag,
4076: 'Y', sbl.quantity *
4070: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4071: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4072: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4073: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4074: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4075: sum((decode(l_txn_currency_flag,
4076: 'Y', sbl.quantity *
4077: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
4078: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4139: 'N', sbl.project_burdened_cost,
4140: 'A', sbl.burdened_cost))/pa_gl.multiplier),
4141: sum((decode(l_txn_currency_flag,
4142: 'Y', sbl.quantity *
4143: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4145: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4147: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4141: sum((decode(l_txn_currency_flag,
4142: 'Y', sbl.quantity *
4143: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4145: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4147: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4148: sum((decode(l_txn_currency_flag,
4149: 'Y', sbl.quantity *
4143: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.txn_raw_cost
4144: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *
4145: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate), --sbl.project_raw_cost
4146: 'A', sbl.quantity * NVL(sbl.projfunc_cost_exchange_rate,1) *
4147: NVL(sbl.txn_cost_rate_override,sbl.txn_standard_cost_rate)))/pa_gl.multiplier), --sbl.raw_cost
4148: sum((decode(l_txn_currency_flag,
4149: 'Y', sbl.quantity *
4150: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate), --sbl.txn_burdened_cost
4151: 'N', sbl.quantity * NVL(sbl.project_cost_exchange_rate,1) *