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 1273: /* As per mail from venkatesh calling this API instead of standard one using in the costing and billing */

1269: G_MRC_INSTALLED_FLAG := 'N';
1270: END IF;
1271: ********Commented for 11.5.10+ change. MRC installed flag is no longer populated/supported by AD Team********/
1272:
1273: /* As per mail from venkatesh calling this API instead of standard one using in the costing and billing */
1274: /****MRC Elimination changes: As we are dropping the mrc_finplan package no need to call this api
1275: IF PA_MRC_FINPLAN.G_MRC_ENABLED_FOR_BUDGETS IS NULL THEN
1276: print_msg('Calling PA_MRC_FINPLAN.CHECK_MRC_INSTALL api');
1277: PA_MRC_FINPLAN.CHECK_MRC_INSTALL

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

4272: ,bl.txn_revenue = bl.txn_init_revenue
4273: /* Bug fix: 4071198 As discussed with sanjay, for closed periods, instead of setting the Etc rates as null
4274: * derive the plan rates. so that the copy version functionality when copies the budget versions
4275: * proper rates will be copied*/
4276: ,bl.txn_standard_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))
4277: ,bl.txn_cost_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))
4278: ,bl.burden_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_burdened_cost/bl.init_quantity))
4279: ,bl.burden_cost_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_burdened_cost/bl.init_quantity))
4280: ,bl.txn_standard_bill_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_revenue/bl.init_quantity))

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

4276: ,bl.txn_standard_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))
4277: ,bl.txn_cost_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_raw_cost/bl.init_quantity))
4278: ,bl.burden_cost_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_burdened_cost/bl.init_quantity))
4279: ,bl.burden_cost_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_burdened_cost/bl.init_quantity))
4280: ,bl.txn_standard_bill_rate = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_revenue/bl.init_quantity))
4281: ,bl.txn_bill_rate_override = DECODE(nvl(bl.init_quantity,0),0,NULL,(bl.txn_init_revenue/bl.init_quantity))
4282: ,bl.raw_cost = bl.init_raw_cost
4283: ,bl.burdened_cost = bl.init_burdened_cost
4284: ,bl.revenue = bl.init_revenue

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

5986: /* Bug fix: 4294287 ends */
5987: ,bl.txn_markup_percent
5988: )),NULL)
5989: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5990: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
5991: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5992: ,'C',bl.txn_standard_bill_rate
5993: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5994: ,bl.txn_standard_bill_rate

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

5987: ,bl.txn_markup_percent
5988: )),NULL)
5989: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5990: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
5991: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5992: ,'C',bl.txn_standard_bill_rate
5993: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5994: ,bl.txn_standard_bill_rate
5995: )

Line 5992: ,'C',bl.txn_standard_bill_rate

5988: )),NULL)
5989: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5990: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
5991: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5992: ,'C',bl.txn_standard_bill_rate
5993: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5994: ,bl.txn_standard_bill_rate
5995: )
5996: ),NULL)

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

5989: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5990: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
5991: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5992: ,'C',bl.txn_standard_bill_rate
5993: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5994: ,bl.txn_standard_bill_rate
5995: )
5996: ),NULL)
5997: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL

Line 5994: ,bl.txn_standard_bill_rate

5990: ,decode(ra.rate_based_flag,'N',bl.txn_standard_bill_rate
5991: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5992: ,'C',bl.txn_standard_bill_rate
5993: ,'R',decode(bl.quantity,null,bl.txn_standard_bill_rate,NULL)
5994: ,bl.txn_standard_bill_rate
5995: )
5996: ),NULL)
5997: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5998: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate

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

5994: ,bl.txn_standard_bill_rate
5995: )
5996: ),NULL)
5997: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5998: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
5999: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6000: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6001: ,'R',bl.txn_standard_cost_rate
6002: ,bl.txn_standard_cost_rate

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

5995: )
5996: ),NULL)
5997: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5998: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
5999: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6000: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6001: ,'R',bl.txn_standard_cost_rate
6002: ,bl.txn_standard_cost_rate
6003: )

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

5996: ),NULL)
5997: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5998: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
5999: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6000: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6001: ,'R',bl.txn_standard_cost_rate
6002: ,bl.txn_standard_cost_rate
6003: )
6004: ),NULL)

Line 6001: ,'R',bl.txn_standard_cost_rate

5997: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
5998: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
5999: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6000: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6001: ,'R',bl.txn_standard_cost_rate
6002: ,bl.txn_standard_cost_rate
6003: )
6004: ),NULL)
6005: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL

Line 6002: ,bl.txn_standard_cost_rate

5998: ,decode(ra.rate_based_flag,'N',bl.txn_standard_cost_rate
5999: ,decode(tmp.refresh_rates_flag,'Y',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6000: ,'C',decode(bl.quantity,null,bl.txn_standard_cost_rate,NULL)
6001: ,'R',bl.txn_standard_cost_rate
6002: ,bl.txn_standard_cost_rate
6003: )
6004: ),NULL)
6005: ,DECODE(tmp.TXN_CURR_CODE_OVERRIDE,NULL
6006: ,decode(ra.rate_based_flag,'N',bl.txn_cost_rate_override

Line 7955: l_bl_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

7951:
7952: --pa_budget_lines local variables---
7953: l_budget_line_id pa_budget_lines.budget_line_id%TYPE;
7954: l_bl_quantity pa_budget_lines.quantity%TYPE;
7955: l_bl_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
7956: l_bl_standard_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
7957: l_bl_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
7958: l_bl_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
7959: l_bl_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

Line 7956: l_bl_standard_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

7952: --pa_budget_lines local variables---
7953: l_budget_line_id pa_budget_lines.budget_line_id%TYPE;
7954: l_bl_quantity pa_budget_lines.quantity%TYPE;
7955: l_bl_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
7956: l_bl_standard_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
7957: l_bl_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
7958: l_bl_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
7959: l_bl_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
7960: l_bl_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

Line 7963: l_bl_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

7959: l_bl_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
7960: l_bl_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
7961: l_bl_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
7962: l_bl_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
7963: l_bl_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
7964: l_bl_standard_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
7965: l_bl_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
7966: l_bl_revenue pa_budget_lines.txn_revenue%TYPE;
7967:

Line 7964: l_bl_standard_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

7960: l_bl_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
7961: l_bl_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
7962: l_bl_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
7963: l_bl_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
7964: l_bl_standard_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
7965: l_bl_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
7966: l_bl_revenue pa_budget_lines.txn_revenue%TYPE;
7967:
7968: l_actual_exists_flag VARCHAR2(60);

Line 8952: l_bl_standard_cost_rate := NULL;

8948:
8949: /* Initialize the bl variables */
8950: l_bl_quantity := NULL;
8951: l_bl_raw_cost_rate := NULL;
8952: l_bl_standard_cost_rate := NULL;
8953: l_bl_cost_rate_override := NULL;
8954: l_bl_raw_cost := NULL;
8955: l_bl_avg_burden_cost_rate := NULL;
8956: l_bl_burden_cost_rate := NULL;

Line 8960: l_bl_standard_bill_rate := NULL;

8956: l_bl_burden_cost_rate := NULL;
8957: l_bl_burden_cost_rate_override := NULL;
8958: l_bl_burdened_cost := NULL;
8959: l_bl_bill_rate := NULL;
8960: l_bl_standard_bill_rate := NULL;
8961: l_bl_bill_rate_override := NULL;
8962: l_bl_revenue := NULL;
8963: -- end of initalization
8964:

Line 11618: ,ra.standard_bill_rate

11614: ,tmp.txn_revenue
11615: ,ra.task_id
11616: ,ra.resource_list_member_id
11617: ,ra.unit_of_measure
11618: ,ra.standard_bill_rate
11619: ,ra.wbs_element_version_id
11620: ,ra.rbs_element_id
11621: ,ra.planning_start_date
11622: ,ra.planning_end_date

Line 15693: ,bl.txn_standard_bill_rate

15689: ,bl.txn_init_raw_cost
15690: ,bl.txn_init_burdened_cost
15691: ,bl.txn_init_revenue
15692: ,bl.txn_markup_percent
15693: ,bl.txn_standard_bill_rate
15694: ,bl.txn_standard_cost_rate
15695: ,bl.txn_cost_rate_override
15696: ,bl.burden_cost_rate
15697: ,bl.txn_bill_rate_override

Line 15694: ,bl.txn_standard_cost_rate

15690: ,bl.txn_init_burdened_cost
15691: ,bl.txn_init_revenue
15692: ,bl.txn_markup_percent
15693: ,bl.txn_standard_bill_rate
15694: ,bl.txn_standard_cost_rate
15695: ,bl.txn_cost_rate_override
15696: ,bl.burden_cost_rate
15697: ,bl.txn_bill_rate_override
15698: ,bl.burden_cost_rate_override