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

Line 301: ,AVG(NVL(blavgrt.txn_cost_rate_override,blavgrt.txn_standard_cost_rate)) avg_zero_null_cost_rate

297: ,SUM(nvl(blavgrt.init_quantity,0)) sum_Actual_Qty
298: ,SUM(nvl(blavgrt.quantity,0)) sum_Plan_Qty
299: */
300: /*bug fix:4693839 */
301: ,AVG(NVL(blavgrt.txn_cost_rate_override,blavgrt.txn_standard_cost_rate)) avg_zero_null_cost_rate
302: ,AVG(NVL(blavgrt.burden_cost_rate_override,blavgrt.burden_cost_rate)) avg_zero_null_burden_rate
303: ,AVG(NVL(blavgrt.txn_bill_rate_override,blavgrt.txn_standard_bill_rate)) avg_zero_null_bill_rate
304: FROM pa_budget_lines blavgrt
305: WHERE blavgrt.resource_assignment_id = p_resource_asg_id

Line 303: ,AVG(NVL(blavgrt.txn_bill_rate_override,blavgrt.txn_standard_bill_rate)) avg_zero_null_bill_rate

299: */
300: /*bug fix:4693839 */
301: ,AVG(NVL(blavgrt.txn_cost_rate_override,blavgrt.txn_standard_cost_rate)) avg_zero_null_cost_rate
302: ,AVG(NVL(blavgrt.burden_cost_rate_override,blavgrt.burden_cost_rate)) avg_zero_null_burden_rate
303: ,AVG(NVL(blavgrt.txn_bill_rate_override,blavgrt.txn_standard_bill_rate)) avg_zero_null_bill_rate
304: FROM pa_budget_lines blavgrt
305: WHERE blavgrt.resource_assignment_id = p_resource_asg_id
306: AND blavgrt.txn_currency_code = p_txn_curr_code
307: AND ( (p_line_start_date is NULL AND p_line_end_date is NULL )

Line 333: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,NULL

329: ,decode(sum(bl.txn_init_burdened_cost),0,NULL,sum(bl.txn_init_burdened_cost)) init_burdened_cost
330: ,decode(sum(bl.txn_init_revenue),0,NULL,sum(bl.txn_init_revenue)) init_revenue
331: ,(sum(decode(p_avg_txn_cost_rate_override,NULL,NULL
332: ,decode((nvl(bl.quantity,0) - nvl(bl.init_quantity,0)),0,NULL
333: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,NULL
334: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
335: nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
336: / DECODE((sum(decode(p_avg_txn_cost_rate_override,NULL,NULL
337: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL

Line 335: nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))

331: ,(sum(decode(p_avg_txn_cost_rate_override,NULL,NULL
332: ,decode((nvl(bl.quantity,0) - nvl(bl.init_quantity,0)),0,NULL
333: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,NULL
334: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
335: nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
336: / DECODE((sum(decode(p_avg_txn_cost_rate_override,NULL,NULL
337: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
338: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
339: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))

Line 338: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

334: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
335: nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
336: / DECODE((sum(decode(p_avg_txn_cost_rate_override,NULL,NULL
337: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
338: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
339: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
340: ,0,NULL,
341: (sum(decode(p_avg_txn_cost_rate_override,NULL,NULL
342: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL

Line 343: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

339: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
340: ,0,NULL,
341: (sum(decode(p_avg_txn_cost_rate_override,NULL,NULL
342: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
343: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
344: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
345: )
346: ) etc_cost_rate_override
347: ,(sum(decode(p_avg_burden_rate_override,NULL,NULL

Line 365: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,NULL

361: )
362: ) etc_burden_rate_override
363: ,(sum(decode(p_avg_bill_rate_override,NULL,NULL
364: , decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
365: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,NULL
366: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
367: nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
368: / DECODE((sum(decode(p_avg_bill_rate_override,NULL,NULL
369: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL

Line 367: nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))

363: ,(sum(decode(p_avg_bill_rate_override,NULL,NULL
364: , decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
365: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,NULL
366: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
367: nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
368: / DECODE((sum(decode(p_avg_bill_rate_override,NULL,NULL
369: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
370: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
371: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))

Line 370: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

366: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
367: nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
368: / DECODE((sum(decode(p_avg_bill_rate_override,NULL,NULL
369: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
370: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
371: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
372: ,0,NULL,
373: (sum(decode(p_avg_bill_rate_override,NULL,NULL
374: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL

Line 375: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

371: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
372: ,0,NULL,
373: (sum(decode(p_avg_bill_rate_override,NULL,NULL
374: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
375: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
376: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
377: )
378: ) etc_bill_rate_override
379: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null

Line 380: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

376: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
377: )
378: ) etc_bill_rate_override
379: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
380: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
381: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
382: nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
383: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
384: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

Line 382: nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))

378: ) etc_bill_rate_override
379: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
380: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
381: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
382: nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
383: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
384: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
385: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
386: ,0,NULL,

Line 384: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

380: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
381: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
382: nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
383: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
384: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
385: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
386: ,0,NULL,
387: (sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
388: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0

Line 388: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0

384: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
385: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
386: ,0,NULL,
387: (sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
388: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0
389: ,null,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
390: )
391: ) etc_bill_rate
392: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null

Line 393: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

389: ,null,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
390: )
391: ) etc_bill_rate
392: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
393: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
394: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
395: nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
396: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
397: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

Line 395: nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))

391: ) etc_bill_rate
392: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
393: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
394: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
395: nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
396: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
397: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
398: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
399: ,0,NULL,

Line 397: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

393: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
394: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) *
395: nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
396: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
397: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
398: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
399: ,0,NULL,
400: (sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
401: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

Line 401: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

397: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
398: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
399: ,0,NULL,
400: (sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
401: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
402: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
403: )
404: ) etc_cost_rate
405: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null

Line 1303: /* As per mail from venkatesh calling this API instead of standard one using in the costing and billing */

1299: G_MRC_INSTALLED_FLAG := 'N';
1300: END IF;
1301: ********Commented for 11.5.10+ change. MRC installed flag is no longer populated/supported by AD Team********/
1302:
1303: /* As per mail from venkatesh calling this API instead of standard one using in the costing and billing */
1304: /****MRC Elimination changes: As we are dropping the mrc_finplan package no need to call this api
1305: IF PA_MRC_FINPLAN.G_MRC_ENABLED_FOR_BUDGETS IS NULL THEN
1306: print_msg('Calling PA_MRC_FINPLAN.CHECK_MRC_INSTALL api');
1307: PA_MRC_FINPLAN.CHECK_MRC_INSTALL

Line 4311: ,bl.txn_standard_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))

4307: ,bl.txn_revenue = bl.txn_init_revenue
4308: /* Bug fix: 4071198 As discussed with sanjay, for closed periods, instead of setting the Etc rates as null
4309: * derive the plan rates. so that the copy version functionality when copies the budget versions
4310: * proper rates will be copied*/
4311: ,bl.txn_standard_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))
4312: ,bl.txn_cost_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))
4313: ,bl.burden_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_burdened_cost/bl.init_quantity))
4314: ,bl.burden_cost_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_burdened_cost/bl.init_quantity))
4315: ,bl.txn_standard_bill_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_revenue/bl.init_quantity))

Line 4315: ,bl.txn_standard_bill_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_revenue/bl.init_quantity))

4311: ,bl.txn_standard_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))
4312: ,bl.txn_cost_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))
4313: ,bl.burden_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_burdened_cost/bl.init_quantity))
4314: ,bl.burden_cost_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_burdened_cost/bl.init_quantity))
4315: ,bl.txn_standard_bill_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_revenue/bl.init_quantity))
4316: ,bl.txn_bill_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_revenue/bl.init_quantity))
4317: ,bl.raw_cost = bl.init_raw_cost
4318: ,bl.burdened_cost = bl.init_burdened_cost
4319: ,bl.revenue = bl.init_revenue

Line 6025: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate

6021: /* Bug fix: 4294287 ends */
6022: ,bl.txn_markup_percent
6023: )),NULL)
6024: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6025: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
6026: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6027: ,'C',bl.txn_standard_bill_rate
6028: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6029: ,bl.txn_standard_bill_rate

Line 6026: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)

6022: ,bl.txn_markup_percent
6023: )),NULL)
6024: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6025: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
6026: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6027: ,'C',bl.txn_standard_bill_rate
6028: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6029: ,bl.txn_standard_bill_rate
6030: )

Line 6027: ,'C',bl.txn_standard_bill_rate

6023: )),NULL)
6024: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6025: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
6026: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6027: ,'C',bl.txn_standard_bill_rate
6028: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6029: ,bl.txn_standard_bill_rate
6030: )
6031: ),NULL)

Line 6028: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)

6024: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6025: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
6026: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6027: ,'C',bl.txn_standard_bill_rate
6028: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6029: ,bl.txn_standard_bill_rate
6030: )
6031: ),NULL)
6032: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL

Line 6029: ,bl.txn_standard_bill_rate

6025: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
6026: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6027: ,'C',bl.txn_standard_bill_rate
6028: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
6029: ,bl.txn_standard_bill_rate
6030: )
6031: ),NULL)
6032: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6033: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate

Line 6033: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate

6029: ,bl.txn_standard_bill_rate
6030: )
6031: ),NULL)
6032: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6033: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
6034: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6035: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6036: ,'R',bl.txn_standard_cost_rate
6037: ,bl.txn_standard_cost_rate

Line 6034: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)

6030: )
6031: ),NULL)
6032: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6033: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
6034: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6035: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6036: ,'R',bl.txn_standard_cost_rate
6037: ,bl.txn_standard_cost_rate
6038: )

Line 6035: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)

6031: ),NULL)
6032: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6033: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
6034: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6035: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6036: ,'R',bl.txn_standard_cost_rate
6037: ,bl.txn_standard_cost_rate
6038: )
6039: ),NULL)

Line 6036: ,'R',bl.txn_standard_cost_rate

6032: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6033: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
6034: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6035: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6036: ,'R',bl.txn_standard_cost_rate
6037: ,bl.txn_standard_cost_rate
6038: )
6039: ),NULL)
6040: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL

Line 6037: ,bl.txn_standard_cost_rate

6033: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
6034: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6035: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6036: ,'R',bl.txn_standard_cost_rate
6037: ,bl.txn_standard_cost_rate
6038: )
6039: ),NULL)
6040: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6041: ,decode(ra.rate_based_flag,'N',bl.txn_cost_rate_override

Line 8051: l_bl_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

8047:
8048: --pa_budget_lines local variables---
8049: l_budget_line_id pa_budget_lines.budget_line_id%TYPE;
8050: l_bl_quantity pa_budget_lines.quantity%TYPE;
8051: l_bl_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
8052: l_bl_standard_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
8053: l_bl_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
8054: l_bl_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
8055: l_bl_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

Line 8052: l_bl_standard_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

8048: --pa_budget_lines local variables---
8049: l_budget_line_id pa_budget_lines.budget_line_id%TYPE;
8050: l_bl_quantity pa_budget_lines.quantity%TYPE;
8051: l_bl_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
8052: l_bl_standard_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
8053: l_bl_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
8054: l_bl_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
8055: l_bl_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
8056: l_bl_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

Line 8059: l_bl_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

8055: l_bl_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
8056: l_bl_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
8057: l_bl_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
8058: l_bl_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
8059: l_bl_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
8060: l_bl_standard_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
8061: l_bl_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
8062: l_bl_revenue pa_budget_lines.txn_revenue%TYPE;
8063:

Line 8060: l_bl_standard_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

8056: l_bl_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
8057: l_bl_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
8058: l_bl_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
8059: l_bl_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
8060: l_bl_standard_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
8061: l_bl_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
8062: l_bl_revenue pa_budget_lines.txn_revenue%TYPE;
8063:
8064: l_actual_exists_flag VARCHAR2(60);

Line 9059: l_bl_standard_cost_rate := NULL;

9055:
9056: /* Initialize the bl variables */
9057: l_bl_quantity := NULL;
9058: l_bl_raw_cost_rate := NULL;
9059: l_bl_standard_cost_rate := NULL;
9060: l_bl_cost_rate_override := NULL;
9061: l_bl_raw_cost := NULL;
9062: l_bl_avg_burden_cost_rate := NULL;
9063: l_bl_burden_cost_rate := NULL;

Line 9067: l_bl_standard_bill_rate := NULL;

9063: l_bl_burden_cost_rate := NULL;
9064: l_bl_burden_cost_rate_override := NULL;
9065: l_bl_burdened_cost := NULL;
9066: l_bl_bill_rate := NULL;
9067: l_bl_standard_bill_rate := NULL;
9068: l_bl_bill_rate_override := NULL;
9069: l_bl_revenue := NULL;
9070: -- end of initalization
9071:

Line 11798: ,ra.standard_bill_rate

11794: ,tmp.txn_revenue
11795: ,ra.task_id
11796: ,ra.resource_list_member_id
11797: ,ra.unit_of_measure
11798: ,ra.standard_bill_rate
11799: ,ra.wbs_element_version_id
11800: ,ra.rbs_element_id
11801: ,ra.planning_start_date
11802: ,ra.planning_end_date

Line 15905: ,bl.txn_standard_bill_rate

15901: ,bl.txn_init_raw_cost
15902: ,bl.txn_init_burdened_cost
15903: ,bl.txn_init_revenue
15904: ,bl.txn_markup_percent
15905: ,bl.txn_standard_bill_rate
15906: ,bl.txn_standard_cost_rate
15907: ,bl.txn_cost_rate_override
15908: ,bl.burden_cost_rate
15909: ,bl.txn_bill_rate_override

Line 15906: ,bl.txn_standard_cost_rate

15902: ,bl.txn_init_burdened_cost
15903: ,bl.txn_init_revenue
15904: ,bl.txn_markup_percent
15905: ,bl.txn_standard_bill_rate
15906: ,bl.txn_standard_cost_rate
15907: ,bl.txn_cost_rate_override
15908: ,bl.burden_cost_rate
15909: ,bl.txn_bill_rate_override
15910: ,bl.burden_cost_rate_override