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 5931: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE

5927:
5928: FORALL kk in L_targ_ra_id_tbl.FIRST ..L_targ_ra_id_tbl.LAST
5929: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
5930: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
5931: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
5932: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
5933: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ
5934: ,TOTAL_LENT_RESOURCE_COST,TOTAL_TP_COST_IN,TOTAL_TP_COST_OUT,TOTAL_COST_ADJ,TOTAL_UNASSIGNED_TIME_COST
5935: ,TOTAL_UTILIZATION_PERCENT,TOTAL_UTILIZATION_HOURS,TOTAL_UTILIZATION_ADJ,TOTAL_CAPACITY,TOTAL_HEAD_COUNT

Line 5962: ,NULL -- STANDARD_BILL_RATE

5958: ,fnd_global.user_id -- CREATED_BY
5959: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5960: ,l_targ_unit_of_measure_tbl(kk) -- UNIT_OF_MEASURE
5961: ,NULL -- TRACK_AS_LABOR_FLAG
5962: ,NULL -- STANDARD_BILL_RATE
5963: ,NULL -- AVERAGE_BILL_RATE
5964: ,NULL -- AVERAGE_COST_RATE
5965: ,-1 -- PROJECT_ASSIGNMENT_ID
5966: ,NULL -- PLAN_ERROR_CODE

Line 6631: TXN_STANDARD_COST_RATE,

6627: TXN_REVENUE,
6628: BUCKETING_PERIOD_CODE,
6629: BUDGET_LINE_ID,
6630: BUDGET_VERSION_ID,
6631: TXN_STANDARD_COST_RATE,
6632: TXN_COST_RATE_OVERRIDE,
6633: COST_IND_COMPILED_SET_ID,
6634: -- TXN_BURDEN_MULTIPLIER,
6635: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 6636: TXN_STANDARD_BILL_RATE,

6632: TXN_COST_RATE_OVERRIDE,
6633: COST_IND_COMPILED_SET_ID,
6634: -- TXN_BURDEN_MULTIPLIER,
6635: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
6636: TXN_STANDARD_BILL_RATE,
6637: TXN_BILL_RATE_OVERRIDE,
6638: TXN_MARKUP_PERCENT,
6639: TXN_MARKUP_PERCENT_OVERRIDE,
6640: TXN_DISCOUNT_PERCENTAGE,

Line 6747: pbl.txn_standard_cost_rate,

6743: pbl.txn_revenue,
6744: pbl.bucketing_period_code,
6745: pa_budget_lines_s.nextval,
6746: pbl.budget_version_id,
6747: pbl.txn_standard_cost_rate,
6748: DECODE(l_target_version_type,
6749: 'REVENUE',pbl.txn_cost_rate_override,
6750: DECODE(l_targ_rate_based_flag_tbl(kk),
6751: 'N',1,

Line 6756: pbl.txn_standard_bill_rate,

6752: pbl.txn_cost_rate_override)),
6753: pbl.cost_ind_compiled_set_id,
6754: -- pbl. txn_burden_multiplier,
6755: -- pbl. txn_burden_multiplier_override,
6756: pbl.txn_standard_bill_rate,
6757: DECODE(l_target_version_type,
6758: 'REVENUE',DECODE(l_targ_rate_based_flag_tbl(kk),
6759: 'N',1,
6760: pbl.txn_bill_rate_override)

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

6873: --Bug 4224757.. Code changes for bug#4224757 ends here
6874:
6875: null bucketing_period_code,
6876: p_budget_version_id budget_version_id,
6877: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,
6878:
6879: --Bug 4224757. Code changes for bug#4224757 starts here
6880: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
6881: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

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

6888:
6889:
6890: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null) cost_ind_compiled_set_id,
6891: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
6892: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate ,
6893:
6894: --Bug 4224757. Code changes for bug#4224757 starts here
6895: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
6896: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 7039: TXN_STANDARD_COST_RATE,

7035: TXN_REVENUE,
7036: BUCKETING_PERIOD_CODE,
7037: BUDGET_LINE_ID,
7038: BUDGET_VERSION_ID,
7039: TXN_STANDARD_COST_RATE,
7040: TXN_COST_RATE_OVERRIDE,
7041: COST_IND_COMPILED_SET_ID,
7042: -- TXN_BURDEN_MULTIPLIER,
7043: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 7044: TXN_STANDARD_BILL_RATE,

7040: TXN_COST_RATE_OVERRIDE,
7041: COST_IND_COMPILED_SET_ID,
7042: -- TXN_BURDEN_MULTIPLIER,
7043: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
7044: TXN_STANDARD_BILL_RATE,
7045: TXN_BILL_RATE_OVERRIDE,
7046: TXN_MARKUP_PERCENT,
7047: TXN_MARKUP_PERCENT_OVERRIDE,
7048: TXN_DISCOUNT_PERCENTAGE,

Line 7153: pbl.txn_standard_cost_rate,

7149: pbl.txn_revenue,
7150: pbl.bucketing_period_code,
7151: pa_budget_lines_s.nextval,
7152: pbl.budget_version_id,
7153: pbl.txn_standard_cost_rate,
7154: DECODE(l_target_version_type,
7155: 'REVENUE',pbl.txn_cost_rate_override,
7156: DECODE(l_targ_rate_based_flag_tbl(kk),
7157: 'N',1,

Line 7162: pbl.txn_standard_bill_rate,

7158: pbl.txn_cost_rate_override)),
7159: pbl.cost_ind_compiled_set_id,
7160: -- pbl. txn_burden_multiplier,
7161: -- pbl. txn_burden_multiplier_override,
7162: pbl.txn_standard_bill_rate,
7163: DECODE(l_target_version_type,
7164: 'REVENUE',DECODE(l_targ_rate_based_flag_tbl(kk),
7165: 'N',1,
7166: pbl.txn_bill_rate_override),

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

7276: --Bug 4224757.. Code changes for bug#4224757 ends here
7277:
7278: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null) bucketing_period_code,
7279: p_budget_version_id budget_version_id,
7280: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,
7281:
7282: --Bug 4224757. Code changes for bug#4224757 starts here
7283: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
7284: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

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

7291:
7292: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null) cost_ind_compiled_set_id,
7293: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
7294:
7295: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,
7296:
7297: --Bug 4224757. Code changes for bug#4224757 starts here
7298: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
7299: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 7446: TXN_STANDARD_COST_RATE,

7442: TXN_REVENUE,
7443: BUCKETING_PERIOD_CODE,
7444: BUDGET_LINE_ID,
7445: BUDGET_VERSION_ID,
7446: TXN_STANDARD_COST_RATE,
7447: TXN_COST_RATE_OVERRIDE,
7448: COST_IND_COMPILED_SET_ID,
7449: -- TXN_BURDEN_MULTIPLIER,
7450: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 7451: TXN_STANDARD_BILL_RATE,

7447: TXN_COST_RATE_OVERRIDE,
7448: COST_IND_COMPILED_SET_ID,
7449: -- TXN_BURDEN_MULTIPLIER,
7450: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
7451: TXN_STANDARD_BILL_RATE,
7452: TXN_BILL_RATE_OVERRIDE,
7453: TXN_MARKUP_PERCENT,
7454: TXN_MARKUP_PERCENT_OVERRIDE,
7455: TXN_DISCOUNT_PERCENTAGE,

Line 7560: pbl.txn_standard_cost_rate,

7556: pbl.txn_revenue,
7557: pbl.bucketing_period_code,
7558: pa_budget_lines_s.nextval,
7559: pbl.budget_version_id,
7560: pbl.txn_standard_cost_rate,
7561: DECODE(l_target_version_type,
7562: 'REVENUE',pbl.txn_cost_rate_override,
7563: DECODE(l_targ_rate_based_flag_tbl(kk),
7564: 'N',1,

Line 7569: pbl.txn_standard_bill_rate,

7565: pbl.txn_cost_rate_override)),
7566: pbl.cost_ind_compiled_set_id,
7567: -- pbl. txn_burden_multiplier,
7568: -- pbl. txn_burden_multiplier_override,
7569: pbl.txn_standard_bill_rate,
7570: DECODE(l_target_version_type,
7571: 'REVENUE',DECODE(l_targ_rate_based_flag_tbl(kk),
7572: 'N',1,
7573: pbl.txn_bill_rate_override),

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

7684: --Bug 4224757.. Code changes for bug#4224757 ends here
7685:
7686: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null) bucketing_period_code,
7687: p_budget_version_id budget_version_id,
7688: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,
7689:
7690: --Bug 4224757. Code changes for bug#4224757 starts here
7691: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
7692: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

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

7699:
7700: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null) cost_ind_compiled_set_id,
7701: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
7702:
7703: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,
7704:
7705: --Bug 4224757. Code changes for bug#4224757 starts here
7706: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
7707: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 7852: TXN_STANDARD_COST_RATE,

7848: TXN_REVENUE,
7849: BUCKETING_PERIOD_CODE,
7850: BUDGET_LINE_ID,
7851: BUDGET_VERSION_ID,
7852: TXN_STANDARD_COST_RATE,
7853: TXN_COST_RATE_OVERRIDE,
7854: COST_IND_COMPILED_SET_ID,
7855: -- TXN_BURDEN_MULTIPLIER,
7856: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 7857: TXN_STANDARD_BILL_RATE,

7853: TXN_COST_RATE_OVERRIDE,
7854: COST_IND_COMPILED_SET_ID,
7855: -- TXN_BURDEN_MULTIPLIER,
7856: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
7857: TXN_STANDARD_BILL_RATE,
7858: TXN_BILL_RATE_OVERRIDE,
7859: TXN_MARKUP_PERCENT,
7860: TXN_MARKUP_PERCENT_OVERRIDE,
7861: TXN_DISCOUNT_PERCENTAGE,

Line 7966: pbl.txn_standard_cost_rate,

7962: pbl.txn_revenue,
7963: pbl.bucketing_period_code,
7964: pa_budget_lines_s.nextval,
7965: pbl.budget_version_id,
7966: pbl.txn_standard_cost_rate,
7967: DECODE(l_target_version_type,
7968: 'REVENUE',pbl.txn_cost_rate_override,
7969: DECODE(l_targ_rate_based_flag_tbl(kk),
7970: 'N',1,

Line 7975: pbl.txn_standard_bill_rate,

7971: pbl.txn_cost_rate_override)),
7972: pbl.cost_ind_compiled_set_id,
7973: -- pbl. txn_burden_multiplier,
7974: -- pbl. txn_burden_multiplier_override,
7975: pbl.txn_standard_bill_rate,
7976: DECODE(l_target_version_type,
7977: 'REVENUE',DECODE(l_targ_rate_based_flag_tbl(kk),
7978: 'N',1,
7979: pbl.txn_bill_rate_override),

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

8090: --Bug 4224757.. Code changes for bug#4224757 ends here
8091:
8092: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null) bucketing_period_code,
8093: p_budget_version_id budget_version_id,
8094: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null) txn_standard_cost_rate,
8095:
8096: --Bug 4224757. Code changes for bug#4224757 starts here
8097: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
8098: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

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

8103:
8104: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null) cost_ind_compiled_set_id,
8105: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
8106:
8107: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null) txn_standard_bill_rate,
8108:
8109: --Bug 4224757. Code changes for bug#4224757 starts here
8110: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
8111: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

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

8256: nvl(pbls.project_revenue,0)))))*l_partial_factor ,
8257: --Bug 4224757.. Code changes for bug#4224757 ends here
8258:
8259: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null),
8260: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),
8261:
8262: --Bug 4224757. Code changes for bug#4224757 starts here
8263: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
8264: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

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

8269:
8270: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null),
8271: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
8272:
8273: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),
8274:
8275: --Bug 4224757. Code changes for bug#4224757 starts here
8276: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
8277: 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: nvl(pbls.project_revenue,0)))))*l_partial_factor ,
8508: --Bug 4224757.. Code changes for bug#4224757 ends here
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 8729: ,pbls.txn_standard_cost_rate

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

Line 8732: ,pbls.txn_standard_bill_rate

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

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

8861: SUM(decode(l_rev_impl_flag,'Y',decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.revenue,0),
8862: DECODE(l_same_multi_curr_flag, 'Y', nvl(pbls.txn_revenue,0), nvl(pbls.project_revenue,0)))))*l_partial_factor,
8863: --Bug 4247568. Code changes for bug 4247568 ends here.
8864: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null),
8865: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),
8866:
8867: --Bug 4224757. Code changes for bug#4224757 starts here
8868: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
8869: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

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

8874:
8875: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null),
8876: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
8877:
8878: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),
8879:
8880: --Bug 4224757. Code changes for bug#4224757 starts here
8881: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
8882: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

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

9107: --Bug 4224757.. Code changes for bug#4224757 ends here
9108:
9109:
9110: decode(count(pbls.budget_line_id),1,max(pbls.BUCKETING_PERIOD_CODE),null),
9111: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_cost_rate),null),
9112:
9113: --Bug 4224757. Code changes for bug#4224757 starts here
9114: decode(nvl(sum(pbls.quantity),0),0,0,SUM(decode(l_cost_impl_flag,'Y',
9115: decode(l_copy_pfc_for_txn_amt_flag,'Y',nvl(pbls.raw_cost,0), DECODE(l_same_multi_curr_flag, 'Y',

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

9120:
9121: decode(count(pbls.budget_line_id),1,max(pbls.cost_ind_compiled_set_id),null),
9122: -- decode(count(pbls.budget_line_id),1,max(pbls.txn_burden_multiplier),null),
9123:
9124: decode(count(pbls.budget_line_id),1,max(pbls.txn_standard_bill_rate),null),
9125:
9126: --Bug 4224757. Code changes for bug#4224757 starts here
9127: decode(nvl(sum(pbls.quantity),0),0,0,sum(Decode(l_rev_impl_flag ,'Y',
9128: decode(l_copy_pfc_for_txn_amt_flag,'Y', nvl(pbls.revenue,0), DECODE(l_same_multi_curr_flag,

Line 9328: ,pbls.txn_standard_cost_rate

9324: ,pbls.txn_revenue
9325: ,pbls.bucketing_period_code
9326: ,pbls.budget_line_id
9327: ,pbls.budget_version_id
9328: ,pbls.txn_standard_cost_rate
9329: ,pbls.txn_cost_rate_override
9330: ,pbls.cost_ind_compiled_set_id
9331: ,pbls.txn_standard_bill_rate
9332: ,pbls.txn_bill_rate_override

Line 9331: ,pbls.txn_standard_bill_rate

9327: ,pbls.budget_version_id
9328: ,pbls.txn_standard_cost_rate
9329: ,pbls.txn_cost_rate_override
9330: ,pbls.cost_ind_compiled_set_id
9331: ,pbls.txn_standard_bill_rate
9332: ,pbls.txn_bill_rate_override
9333: ,pbls.txn_markup_percent
9334: ,pbls.txn_markup_percent_override
9335: ,pbls.txn_discount_percentage

Line 9540: TXN_STANDARD_COST_RATE,

9536: TXN_REVENUE,
9537: BUCKETING_PERIOD_CODE,
9538: BUDGET_LINE_ID,
9539: BUDGET_VERSION_ID,
9540: TXN_STANDARD_COST_RATE,
9541: TXN_COST_RATE_OVERRIDE,
9542: COST_IND_COMPILED_SET_ID,
9543: -- TXN_BURDEN_MULTIPLIER,
9544: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,

Line 9545: TXN_STANDARD_BILL_RATE,

9541: TXN_COST_RATE_OVERRIDE,
9542: COST_IND_COMPILED_SET_ID,
9543: -- TXN_BURDEN_MULTIPLIER,
9544: -- TXN_BURDEN_MULTIPLIER_OVERRIDE,
9545: TXN_STANDARD_BILL_RATE,
9546: TXN_BILL_RATE_OVERRIDE,
9547: TXN_MARKUP_PERCENT,
9548: TXN_MARKUP_PERCENT_OVERRIDE,
9549: TXN_DISCOUNT_PERCENTAGE,