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_FP_CI_MERGE dependencies on STANDARD

Line 5324: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE

5320:
5321: FORALL kk in L_targ_ra_id_tbl.FIRST ..L_targ_ra_id_tbl.LAST
5322: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
5323: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,CBS_ELEMENT_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
5324: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
5325: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
5326: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ
5327: ,TOTAL_LENT_RESOURCE_COST,TOTAL_TP_COST_IN,TOTAL_TP_COST_OUT,TOTAL_COST_ADJ,TOTAL_UNASSIGNED_TIME_COST
5328: ,TOTAL_UTILIZATION_PERCENT,TOTAL_UTILIZATION_HOURS,TOTAL_UTILIZATION_ADJ,TOTAL_CAPACITY,TOTAL_HEAD_COUNT

Line 5356: ,NULL -- STANDARD_BILL_RATE

5352: ,fnd_global.user_id -- CREATED_BY
5353: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5354: ,l_targ_unit_of_measure_tbl(kk) -- UNIT_OF_MEASURE
5355: ,NULL -- TRACK_AS_LABOR_FLAG
5356: ,NULL -- STANDARD_BILL_RATE
5357: ,NULL -- AVERAGE_BILL_RATE
5358: ,NULL -- AVERAGE_COST_RATE
5359: ,-1 -- PROJECT_ASSIGNMENT_ID
5360: ,NULL -- PLAN_ERROR_CODE

Line 6031: TXN_STANDARD_COST_RATE,

6027: TXN_REVENUE,
6028: BUCKETING_PERIOD_CODE,
6029: BUDGET_LINE_ID,
6030: BUDGET_VERSION_ID,
6031: TXN_STANDARD_COST_RATE,
6032: TXN_COST_RATE_OVERRIDE,
6033: COST_IND_COMPILED_SET_ID,
6034: -- TXN_BURDEN_MULTIPLIER,
6035: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 6036: TXN_STANDARD_BILL_RATE,

6032: TXN_COST_RATE_OVERRIDE,
6033: COST_IND_COMPILED_SET_ID,
6034: -- TXN_BURDEN_MULTIPLIER,
6035: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
6036: TXN_STANDARD_BILL_RATE,
6037: TXN_BILL_RATE_OVERRIDE,
6038: TXN_MARKUP_PERCENT,
6039: TXN_MARKUP_PERCENT_OVERRIDE,
6040: TXN_DISCOUNT_PERCENTAGE,

Line 6147: pbl.txn_standard_cost_rate,

6143: pbl.txn_revenue,
6144: pbl.bucketing_period_code,
6145: pa_budget_lines_s.nextval,
6146: pbl.budget_version_id,
6147: pbl.txn_standard_cost_rate,
6148: DECODE(l_target_version_type,
6149: 'REVENUE',pbl.txn_cost_rate_override,
6150: DECODE(l_targ_rate_based_flag_tbl(kk),
6151: 'N',1,

Line 6156: pbl.txn_standard_bill_rate,

6152: pbl.txn_cost_rate_override)),
6153: pbl.cost_ind_compiled_set_id,
6154: -- pbl. txn_burden_multiplier,
6155: -- pbl. txn_burden_multiplier_override,
6156: pbl.txn_standard_bill_rate,
6157: DECODE(l_target_version_type,
6158: 'REVENUE',DECODE(l_targ_rate_based_flag_tbl(kk),
6159: 'N',1,
6160: pbl.txn_bill_rate_override)

Line 6277: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,

6273: --Bug 4224757.. Code changes for bug#4224757 ends here
6274:
6275: null bucketing_period_code,
6276: p_budget_version_id budget_version_id,
6277: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,
6278:
6279: --Bug 4224757. Code changes for bug#4224757 starts here
6280: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
6281: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

Line 6292: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate ,

6288:
6289:
6290: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null) cost_ind_compiled_set_id,
6291: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
6292: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate ,
6293:
6294: --Bug 4224757. Code changes for bug#4224757 starts here
6295: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
6296: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 6439: TXN_STANDARD_COST_RATE,

6435: TXN_REVENUE,
6436: BUCKETING_PERIOD_CODE,
6437: BUDGET_LINE_ID,
6438: BUDGET_VERSION_ID,
6439: TXN_STANDARD_COST_RATE,
6440: TXN_COST_RATE_OVERRIDE,
6441: COST_IND_COMPILED_SET_ID,
6442: -- TXN_BURDEN_MULTIPLIER,
6443: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 6444: TXN_STANDARD_BILL_RATE,

6440: TXN_COST_RATE_OVERRIDE,
6441: COST_IND_COMPILED_SET_ID,
6442: -- TXN_BURDEN_MULTIPLIER,
6443: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
6444: TXN_STANDARD_BILL_RATE,
6445: TXN_BILL_RATE_OVERRIDE,
6446: TXN_MARKUP_PERCENT,
6447: TXN_MARKUP_PERCENT_OVERRIDE,
6448: TXN_DISCOUNT_PERCENTAGE,

Line 6553: pbl.txn_standard_cost_rate,

6549: pbl.txn_revenue,
6550: pbl.bucketing_period_code,
6551: pa_budget_lines_s.nextval,
6552: pbl.budget_version_id,
6553: pbl.txn_standard_cost_rate,
6554: DECODE(l_target_version_type,
6555: 'REVENUE',pbl.txn_cost_rate_override,
6556: DECODE(l_targ_rate_based_flag_tbl(kk),
6557: 'N',1,

Line 6562: pbl.txn_standard_bill_rate,

6558: pbl.txn_cost_rate_override)),
6559: pbl.cost_ind_compiled_set_id,
6560: -- pbl. txn_burden_multiplier,
6561: -- pbl. txn_burden_multiplier_override,
6562: pbl.txn_standard_bill_rate,
6563: DECODE(l_target_version_type,
6564: 'REVENUE',DECODE(l_targ_rate_based_flag_tbl(kk),
6565: 'N',1,
6566: pbl.txn_bill_rate_override),

Line 6680: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,

6676: --Bug 4224757.. Code changes for bug#4224757 ends here
6677:
6678: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null) bucketing_period_code,
6679: p_budget_version_id budget_version_id,
6680: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,
6681:
6682: --Bug 4224757. Code changes for bug#4224757 starts here
6683: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
6684: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

Line 6695: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,

6691:
6692: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null) cost_ind_compiled_set_id,
6693: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
6694:
6695: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,
6696:
6697: --Bug 4224757. Code changes for bug#4224757 starts here
6698: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
6699: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 6846: TXN_STANDARD_COST_RATE,

6842: TXN_REVENUE,
6843: BUCKETING_PERIOD_CODE,
6844: BUDGET_LINE_ID,
6845: BUDGET_VERSION_ID,
6846: TXN_STANDARD_COST_RATE,
6847: TXN_COST_RATE_OVERRIDE,
6848: COST_IND_COMPILED_SET_ID,
6849: -- TXN_BURDEN_MULTIPLIER,
6850: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 6851: TXN_STANDARD_BILL_RATE,

6847: TXN_COST_RATE_OVERRIDE,
6848: COST_IND_COMPILED_SET_ID,
6849: -- TXN_BURDEN_MULTIPLIER,
6850: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
6851: TXN_STANDARD_BILL_RATE,
6852: TXN_BILL_RATE_OVERRIDE,
6853: TXN_MARKUP_PERCENT,
6854: TXN_MARKUP_PERCENT_OVERRIDE,
6855: TXN_DISCOUNT_PERCENTAGE,

Line 6960: pbl.txn_standard_cost_rate,

6956: pbl.txn_revenue,
6957: pbl.bucketing_period_code,
6958: pa_budget_lines_s.nextval,
6959: pbl.budget_version_id,
6960: pbl.txn_standard_cost_rate,
6961: DECODE(l_target_version_type,
6962: 'REVENUE',pbl.txn_cost_rate_override,
6963: DECODE(l_targ_rate_based_flag_tbl(kk),
6964: 'N',1,

Line 6969: pbl.txn_standard_bill_rate,

6965: pbl.txn_cost_rate_override)),
6966: pbl.cost_ind_compiled_set_id,
6967: -- pbl. txn_burden_multiplier,
6968: -- pbl. txn_burden_multiplier_override,
6969: pbl.txn_standard_bill_rate,
6970: DECODE(l_target_version_type,
6971: 'REVENUE',DECODE(l_targ_rate_based_flag_tbl(kk),
6972: 'N',1,
6973: pbl.txn_bill_rate_override),

Line 7088: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,

7084: --Bug 4224757.. Code changes for bug#4224757 ends here
7085:
7086: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null) bucketing_period_code,
7087: p_budget_version_id budget_version_id,
7088: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,
7089:
7090: --Bug 4224757. Code changes for bug#4224757 starts here
7091: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
7092: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

Line 7103: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,

7099:
7100: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null) cost_ind_compiled_set_id,
7101: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
7102:
7103: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,
7104:
7105: --Bug 4224757. Code changes for bug#4224757 starts here
7106: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
7107: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 7252: TXN_STANDARD_COST_RATE,

7248: TXN_REVENUE,
7249: BUCKETING_PERIOD_CODE,
7250: BUDGET_LINE_ID,
7251: BUDGET_VERSION_ID,
7252: TXN_STANDARD_COST_RATE,
7253: TXN_COST_RATE_OVERRIDE,
7254: COST_IND_COMPILED_SET_ID,
7255: -- TXN_BURDEN_MULTIPLIER,
7256: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 7257: TXN_STANDARD_BILL_RATE,

7253: TXN_COST_RATE_OVERRIDE,
7254: COST_IND_COMPILED_SET_ID,
7255: -- TXN_BURDEN_MULTIPLIER,
7256: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
7257: TXN_STANDARD_BILL_RATE,
7258: TXN_BILL_RATE_OVERRIDE,
7259: TXN_MARKUP_PERCENT,
7260: TXN_MARKUP_PERCENT_OVERRIDE,
7261: TXN_DISCOUNT_PERCENTAGE,

Line 7366: pbl.txn_standard_cost_rate,

7362: pbl.txn_revenue,
7363: pbl.bucketing_period_code,
7364: pa_budget_lines_s.nextval,
7365: pbl.budget_version_id,
7366: pbl.txn_standard_cost_rate,
7367: DECODE(l_target_version_type,
7368: 'REVENUE',pbl.txn_cost_rate_override,
7369: DECODE(l_targ_rate_based_flag_tbl(kk),
7370: 'N',1,

Line 7375: pbl.txn_standard_bill_rate,

7371: pbl.txn_cost_rate_override)),
7372: pbl.cost_ind_compiled_set_id,
7373: -- pbl. txn_burden_multiplier,
7374: -- pbl. txn_burden_multiplier_override,
7375: pbl.txn_standard_bill_rate,
7376: DECODE(l_target_version_type,
7377: 'REVENUE',DECODE(l_targ_rate_based_flag_tbl(kk),
7378: 'N',1,
7379: pbl.txn_bill_rate_override),

Line 7494: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,

7490: --Bug 4224757.. Code changes for bug#4224757 ends here
7491:
7492: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null) bucketing_period_code,
7493: p_budget_version_id budget_version_id,
7494: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,
7495:
7496: --Bug 4224757. Code changes for bug#4224757 starts here
7497: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
7498: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

Line 7507: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,

7503:
7504: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null) cost_ind_compiled_set_id,
7505: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
7506:
7507: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,
7508:
7509: --Bug 4224757. Code changes for bug#4224757 starts here
7510: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
7511: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 7660: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),

7656: nvl(pbls.project_revenue,0)))))*l_partial_factor ,
7657: --Bug 4224757.. Code changes for bug#4224757 ends here
7658:
7659: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null),
7660: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),
7661:
7662: --Bug 4224757. Code changes for bug#4224757 starts here
7663: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
7664: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

Line 7673: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),

7669:
7670: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null),
7671: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
7672:
7673: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),
7674:
7675: --Bug 4224757. Code changes for bug#4224757 starts here
7676: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
7677: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 7911: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),

7907: nvl(pbls.project_revenue,0)))))*l_partial_factor ,
7908: --Bug 4224757.. Code changes for bug#4224757 ends here
7909:
7910: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null),
7911: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),
7912:
7913: --Bug 4224757. Code changes for bug#4224757 starts here
7914: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
7915: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

Line 7924: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),

7920:
7921: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null),
7922: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
7923:
7924: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),
7925:
7926: --Bug 4224757. Code changes for bug#4224757 starts here
7927: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
7928: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 8129: ,pbls.txn_standard_cost_rate

8125: ,pbls.txn_revenue
8126: ,pbls.bucketing_period_code
8127: ,pbls.budget_line_id
8128: ,pbls.budget_version_id
8129: ,pbls.txn_standard_cost_rate
8130: ,pbls.txn_cost_rate_override
8131: ,pbls.cost_ind_compiled_set_id
8132: ,pbls.txn_standard_bill_rate
8133: ,pbls.txn_bill_rate_override

Line 8132: ,pbls.txn_standard_bill_rate

8128: ,pbls.budget_version_id
8129: ,pbls.txn_standard_cost_rate
8130: ,pbls.txn_cost_rate_override
8131: ,pbls.cost_ind_compiled_set_id
8132: ,pbls.txn_standard_bill_rate
8133: ,pbls.txn_bill_rate_override
8134: ,pbls.txn_markup_percent
8135: ,pbls.txn_markup_percent_override
8136: ,pbls.txn_discount_percentage

Line 8265: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),

8261: SUM(decode(l_rev_impl_flag,'Y',decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.revenue,0),
8262: DECODE(l_same_multi_curr_flag, 'Y', nvl(pbls.txn_revenue,0), nvl(pbls.project_revenue,0)))))*l_partial_factor,
8263: --Bug 4247568. Code changes for bug 4247568 ends here.
8264: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null),
8265: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),
8266:
8267: --Bug 4224757. Code changes for bug#4224757 starts here
8268: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
8269: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

Line 8278: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),

8274:
8275: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null),
8276: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
8277:
8278: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),
8279:
8280: --Bug 4224757. Code changes for bug#4224757 starts here
8281: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
8282: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 8511: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),

8507: --Bug 4224757.. Code changes for bug#4224757 ends here
8508:
8509:
8510: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null),
8511: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),
8512:
8513: --Bug 4224757. Code changes for bug#4224757 starts here
8514: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
8515: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

Line 8524: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),

8520:
8521: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null),
8522: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
8523:
8524: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),
8525:
8526: --Bug 4224757. Code changes for bug#4224757 starts here
8527: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
8528: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 8728: ,pbls.txn_standard_cost_rate

8724: ,pbls.txn_revenue
8725: ,pbls.bucketing_period_code
8726: ,pbls.budget_line_id
8727: ,pbls.budget_version_id
8728: ,pbls.txn_standard_cost_rate
8729: ,pbls.txn_cost_rate_override
8730: ,pbls.cost_ind_compiled_set_id
8731: ,pbls.txn_standard_bill_rate
8732: ,pbls.txn_bill_rate_override

Line 8731: ,pbls.txn_standard_bill_rate

8727: ,pbls.budget_version_id
8728: ,pbls.txn_standard_cost_rate
8729: ,pbls.txn_cost_rate_override
8730: ,pbls.cost_ind_compiled_set_id
8731: ,pbls.txn_standard_bill_rate
8732: ,pbls.txn_bill_rate_override
8733: ,pbls.txn_markup_percent
8734: ,pbls.txn_markup_percent_override
8735: ,pbls.txn_discount_percentage

Line 8940: TXN_STANDARD_COST_RATE,

8936: TXN_REVENUE,
8937: BUCKETING_PERIOD_CODE,
8938: BUDGET_LINE_ID,
8939: BUDGET_VERSION_ID,
8940: TXN_STANDARD_COST_RATE,
8941: TXN_COST_RATE_OVERRIDE,
8942: COST_IND_COMPILED_SET_ID,
8943: -- TXN_BURDEN_MULTIPLIER,
8944: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 8945: TXN_STANDARD_BILL_RATE,

8941: TXN_COST_RATE_OVERRIDE,
8942: COST_IND_COMPILED_SET_ID,
8943: -- TXN_BURDEN_MULTIPLIER,
8944: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
8945: TXN_STANDARD_BILL_RATE,
8946: TXN_BILL_RATE_OVERRIDE,
8947: TXN_MARKUP_PERCENT,
8948: TXN_MARKUP_PERCENT_OVERRIDE,
8949: TXN_DISCOUNT_PERCENTAGE,