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_FIN_PLAN_VIEW_GLOBAL dependencies on PA_FIN_PLAN_ADJ_LINES

Line 908: /Update pa_fin_plan_adj_lines/

904: /***************************************************************************************/
905:
906:
907: /****************************************************************************************/
908: /*Update pa_fin_plan_adj_lines*/
909: /***************************************************************************************/
910:
911:
912: /*for period 1*/

Line 925: from pa_fin_plan_adj_lines

921: l_period_name := l_period_name1;
922:
923: select FIN_PLAN_ADJ_LINE_ID
924: into l_fin_plan_adj_line_id1
925: from pa_fin_plan_adj_lines
926: where budget_version_id = l_budget_version_id
927: and period_name=l_period_name
928: and resource_assignment_id = l_ra_id_tl
929: and adj_element_id = l_adj_element_id_tl;

Line 1087: from pa_fin_plan_adj_lines

1083: l_period_name := l_period_name2;
1084:
1085: select FIN_PLAN_ADJ_LINE_ID
1086: into l_fin_plan_adj_line_id2
1087: from pa_fin_plan_adj_lines
1088: where budget_version_id = l_budget_version_id
1089: and period_name=l_period_name
1090: and resource_assignment_id = l_ra_id_tl
1091: and adj_element_id = l_adj_element_id_tl;

Line 1245: from pa_fin_plan_adj_lines

1241: l_period_name := l_period_name3;
1242:
1243: select FIN_PLAN_ADJ_LINE_ID
1244: into l_fin_plan_adj_line_id3
1245: from pa_fin_plan_adj_lines
1246: where budget_version_id = l_budget_version_id
1247: and period_name=l_period_name
1248: and resource_assignment_id = l_ra_id_tl
1249: and adj_element_id = l_adj_element_id_tl;

Line 1406: from pa_fin_plan_adj_lines

1402: l_period_name := l_period_name4;
1403:
1404: select FIN_PLAN_ADJ_LINE_ID
1405: into l_fin_plan_adj_line_id4
1406: from pa_fin_plan_adj_lines
1407: where budget_version_id = l_budget_version_id
1408: and period_name=l_period_name
1409: and resource_assignment_id = l_ra_id_tl
1410: and adj_element_id = l_adj_element_id_tl;

Line 1567: from pa_fin_plan_adj_lines

1563: l_period_name := l_period_name5;
1564:
1565: select FIN_PLAN_ADJ_LINE_ID
1566: into l_fin_plan_adj_line_id5
1567: from pa_fin_plan_adj_lines
1568: where budget_version_id = l_budget_version_id
1569: and period_name=l_period_name
1570: and resource_assignment_id = l_ra_id_tl
1571: and adj_element_id = l_adj_element_id_tl;

Line 1726: from pa_fin_plan_adj_lines

1722: l_period_name := l_period_name6;
1723:
1724: select FIN_PLAN_ADJ_LINE_ID
1725: into l_fin_plan_adj_line_id6
1726: from pa_fin_plan_adj_lines
1727: where budget_version_id = l_budget_version_id
1728: and period_name=l_period_name
1729: and resource_assignment_id = l_ra_id_tl
1730: and adj_element_id = l_adj_element_id_tl;

Line 1889: from pa_fin_plan_adj_lines

1885: l_period_name := l_period_name7;
1886:
1887: select FIN_PLAN_ADJ_LINE_ID
1888: into l_fin_plan_adj_line_id7
1889: from pa_fin_plan_adj_lines
1890: where budget_version_id = l_budget_version_id
1891: and period_name=l_period_name
1892: and resource_assignment_id = l_ra_id_tl
1893: and adj_element_id = l_adj_element_id_tl;

Line 2049: from pa_fin_plan_adj_lines

2045: l_period_name := l_period_name8;
2046:
2047: select FIN_PLAN_ADJ_LINE_ID
2048: into l_fin_plan_adj_line_id8
2049: from pa_fin_plan_adj_lines
2050: where budget_version_id = l_budget_version_id
2051: and period_name=l_period_name
2052: and resource_assignment_id = l_ra_id_tl
2053: and adj_element_id = l_adj_element_id_tl;

Line 2205: from pa_fin_plan_adj_lines

2201: l_period_name := l_period_name9;
2202:
2203: select FIN_PLAN_ADJ_LINE_ID
2204: into l_fin_plan_adj_line_id9
2205: from pa_fin_plan_adj_lines
2206: where budget_version_id = l_budget_version_id
2207: and period_name=l_period_name
2208: and resource_assignment_id = l_ra_id_tl
2209: and adj_element_id = l_adj_element_id_tl;

Line 2366: from pa_fin_plan_adj_lines

2362: l_period_name := l_period_name10;
2363:
2364: select FIN_PLAN_ADJ_LINE_ID
2365: into l_fin_plan_adj_line_id10
2366: from pa_fin_plan_adj_lines
2367: where budget_version_id = l_budget_version_id
2368: and period_name=l_period_name
2369: and resource_assignment_id = l_ra_id_tl
2370: and adj_element_id = l_adj_element_id_tl;

Line 2528: from pa_fin_plan_adj_lines

2524: l_period_name := l_period_name11;
2525:
2526: select FIN_PLAN_ADJ_LINE_ID
2527: into l_fin_plan_adj_line_id11
2528: from pa_fin_plan_adj_lines
2529: where budget_version_id = l_budget_version_id
2530: and period_name=l_period_name
2531: and resource_assignment_id = l_ra_id_tl
2532: and adj_element_id = l_adj_element_id_tl;

Line 2687: from pa_fin_plan_adj_lines

2683: l_period_name := l_period_name12;
2684:
2685: select FIN_PLAN_ADJ_LINE_ID
2686: into l_fin_plan_adj_line_id12
2687: from pa_fin_plan_adj_lines
2688: where budget_version_id = l_budget_version_id
2689: and period_name=l_period_name
2690: and resource_assignment_id = l_ra_id_tl
2691: and adj_element_id = l_adj_element_id_tl;

Line 2848: from pa_fin_plan_adj_lines

2844: l_period_name := l_period_name13;
2845:
2846: select FIN_PLAN_ADJ_LINE_ID
2847: into l_fin_plan_adj_line_id13
2848: from pa_fin_plan_adj_lines
2849: where budget_version_id = l_budget_version_id
2850: and period_name=l_period_name
2851: and resource_assignment_id = l_ra_id_tl
2852: and adj_element_id = l_adj_element_id_tl;

Line 3038: from pa_fin_plan_adj_lines

3034: l_period_name := l_period_name1;
3035:
3036: select FIN_PLAN_ADJ_LINE_ID
3037: into l_fin_plan_adj_line_id1
3038: from pa_fin_plan_adj_lines
3039: where budget_version_id = l_budget_version_id
3040: and period_name=l_period_name
3041: and resource_assignment_id = l_ra_id_pl
3042: and adj_element_id = l_adj_element_id_pl;

Line 3198: from pa_fin_plan_adj_lines

3194: l_period_name := l_period_name2;
3195:
3196: select FIN_PLAN_ADJ_LINE_ID
3197: into l_fin_plan_adj_line_id2
3198: from pa_fin_plan_adj_lines
3199: where budget_version_id = l_budget_version_id
3200: and period_name=l_period_name
3201: and resource_assignment_id = l_ra_id_pl
3202: and adj_element_id = l_adj_element_id_pl;

Line 3355: from pa_fin_plan_adj_lines

3351: l_period_name := l_period_name3;
3352:
3353: select FIN_PLAN_ADJ_LINE_ID
3354: into l_fin_plan_adj_line_id3
3355: from pa_fin_plan_adj_lines
3356: where budget_version_id = l_budget_version_id
3357: and period_name=l_period_name
3358: and resource_assignment_id = l_ra_id_pl
3359: and adj_element_id = l_adj_element_id_pl;

Line 3516: from pa_fin_plan_adj_lines

3512: l_period_name := l_period_name4;
3513:
3514: select FIN_PLAN_ADJ_LINE_ID
3515: into l_fin_plan_adj_line_id4
3516: from pa_fin_plan_adj_lines
3517: where budget_version_id = l_budget_version_id
3518: and period_name=l_period_name
3519: and resource_assignment_id = l_ra_id_pl
3520: and adj_element_id = l_adj_element_id_pl;

Line 3678: from pa_fin_plan_adj_lines

3674: l_period_name := l_period_name5;
3675:
3676: select FIN_PLAN_ADJ_LINE_ID
3677: into l_fin_plan_adj_line_id5
3678: from pa_fin_plan_adj_lines
3679: where budget_version_id = l_budget_version_id
3680: and period_name=l_period_name
3681: and resource_assignment_id = l_ra_id_pl
3682: and adj_element_id = l_adj_element_id_pl;

Line 3838: from pa_fin_plan_adj_lines

3834: l_period_name := l_period_name6;
3835:
3836: select FIN_PLAN_ADJ_LINE_ID
3837: into l_fin_plan_adj_line_id6
3838: from pa_fin_plan_adj_lines
3839: where budget_version_id = l_budget_version_id
3840: and period_name=l_period_name
3841: and resource_assignment_id = l_ra_id_pl
3842: and adj_element_id = l_adj_element_id_pl;

Line 4000: from pa_fin_plan_adj_lines

3996: l_period_name := l_period_name7;
3997:
3998: select FIN_PLAN_ADJ_LINE_ID
3999: into l_fin_plan_adj_line_id7
4000: from pa_fin_plan_adj_lines
4001: where budget_version_id = l_budget_version_id
4002: and period_name=l_period_name
4003: and resource_assignment_id = l_ra_id_pl
4004: and adj_element_id = l_adj_element_id_pl;

Line 4160: from pa_fin_plan_adj_lines

4156: l_period_name := l_period_name8;
4157:
4158: select FIN_PLAN_ADJ_LINE_ID
4159: into l_fin_plan_adj_line_id8
4160: from pa_fin_plan_adj_lines
4161: where budget_version_id = l_budget_version_id
4162: and period_name=l_period_name
4163: and resource_assignment_id = l_ra_id_pl
4164: and adj_element_id = l_adj_element_id_pl;

Line 4317: from pa_fin_plan_adj_lines

4313: l_period_name := l_period_name9;
4314:
4315: select FIN_PLAN_ADJ_LINE_ID
4316: into l_fin_plan_adj_line_id9
4317: from pa_fin_plan_adj_lines
4318: where budget_version_id = l_budget_version_id
4319: and period_name=l_period_name
4320: and resource_assignment_id = l_ra_id_pl
4321: and adj_element_id = l_adj_element_id_pl;

Line 4478: from pa_fin_plan_adj_lines

4474: l_period_name := l_period_name10;
4475:
4476: select FIN_PLAN_ADJ_LINE_ID
4477: into l_fin_plan_adj_line_id10
4478: from pa_fin_plan_adj_lines
4479: where budget_version_id = l_budget_version_id
4480: and period_name=l_period_name
4481: and resource_assignment_id = l_ra_id_pl
4482: and adj_element_id = l_adj_element_id_pl;

Line 4638: from pa_fin_plan_adj_lines

4634: l_period_name := l_period_name11;
4635:
4636: select FIN_PLAN_ADJ_LINE_ID
4637: into l_fin_plan_adj_line_id11
4638: from pa_fin_plan_adj_lines
4639: where budget_version_id = l_budget_version_id
4640: and period_name=l_period_name
4641: and resource_assignment_id = l_ra_id_pl
4642: and adj_element_id = l_adj_element_id_pl;

Line 4796: from pa_fin_plan_adj_lines

4792: l_period_name := l_period_name12;
4793:
4794: select FIN_PLAN_ADJ_LINE_ID
4795: into l_fin_plan_adj_line_id12
4796: from pa_fin_plan_adj_lines
4797: where budget_version_id = l_budget_version_id
4798: and period_name=l_period_name
4799: and resource_assignment_id = l_ra_id_pl
4800: and adj_element_id = l_adj_element_id_pl;

Line 4956: from pa_fin_plan_adj_lines

4952: l_period_name := l_period_name13;
4953:
4954: select FIN_PLAN_ADJ_LINE_ID
4955: into l_fin_plan_adj_line_id13
4956: from pa_fin_plan_adj_lines
4957: where budget_version_id = l_budget_version_id
4958: and period_name=l_period_name
4959: and resource_assignment_id = l_ra_id_pl
4960: and adj_element_id = l_adj_element_id_pl;

Line 5113: /End of update pa_fin_plan_adj_lines/

5109:
5110:
5111:
5112: /****************************************************************************************/
5113: /*End of update pa_fin_plan_adj_lines*/
5114: /***************************************************************************************/
5115:
5116:
5117:

Line 5156: from pa_fin_plan_adj_lines

5152: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5153:
5154: select sum(nvl(revenue_adjustment,0))
5155: into l_period_amount
5156: from pa_fin_plan_adj_lines
5157: where resource_assignment_id = l_ra_id_pl
5158: and start_date = l_start_date;
5159: --Bug 4947912
5160: IF l_budget_line_id IS NOT NULL THEN

Line 5173: from pa_fin_plan_adj_lines

5169: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5170:
5171: select sum(nvl(burdened_cost_adjustment,0))
5172: into l_period_amount
5173: from pa_fin_plan_adj_lines
5174: where resource_assignment_id = l_ra_id_pl
5175: and start_date = l_start_date;
5176: --Bug 4947912
5177: IF l_budget_line_id IS NOT NULL THEN

Line 5189: from pa_fin_plan_adj_lines

5185: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5186:
5187: select sum(nvl(head_count_adjustment,0))
5188: into l_period_amount
5189: from pa_fin_plan_adj_lines
5190: where resource_assignment_id = l_ra_id_pl
5191: and start_date = l_start_date;
5192: --Bug 4947912
5193: IF l_budget_line_id IS NOT NULL THEN

Line 5205: from pa_fin_plan_adj_lines

5201: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5202:
5203: select sum(nvl(utilization_adjustment,0))
5204: into l_period_amount
5205: from pa_fin_plan_adj_lines
5206: where resource_assignment_id = l_ra_id_pl
5207: and start_date = l_start_date;
5208: --Bug 4947912
5209: IF l_budget_line_id IS NOT NULL THEN

Line 5251: from pa_fin_plan_adj_lines

5247: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5248:
5249: select sum(nvl(revenue_adjustment,0))
5250: into l_period_amount
5251: from pa_fin_plan_adj_lines
5252: where resource_assignment_id = l_ra_id_pl
5253: and start_date = l_start_date;
5254:
5255: If l_budget_line_id is not null then

Line 5268: from pa_fin_plan_adj_lines

5264: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5265:
5266: select sum(nvl(burdened_cost_adjustment,0))
5267: into l_period_amount
5268: from pa_fin_plan_adj_lines
5269: where resource_assignment_id = l_ra_id_pl
5270: and start_date = l_start_date;
5271:
5272: --Bug 4947912

Line 5285: from pa_fin_plan_adj_lines

5281: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5282:
5283: select sum(nvl(head_count_adjustment,0))
5284: into l_period_amount
5285: from pa_fin_plan_adj_lines
5286: where resource_assignment_id = l_ra_id_pl
5287: and start_date = l_start_date;
5288:
5289:

Line 5304: from pa_fin_plan_adj_lines

5300: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5301:
5302: select sum(nvl(utilization_adjustment,0))
5303: into l_period_amount
5304: from pa_fin_plan_adj_lines
5305: where resource_assignment_id = l_ra_id_pl
5306: and start_date = l_start_date;
5307:
5308:

Line 5348: from pa_fin_plan_adj_lines

5344: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5345:
5346: select sum(nvl(revenue_adjustment,0))
5347: into l_period_amount
5348: from pa_fin_plan_adj_lines
5349: where resource_assignment_id = l_ra_id_pl
5350: and start_date = l_start_date;
5351:
5352: --Bug 4947912

Line 5366: from pa_fin_plan_adj_lines

5362: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5363:
5364: select sum(nvl(burdened_cost_adjustment,0))
5365: into l_period_amount
5366: from pa_fin_plan_adj_lines
5367: where resource_assignment_id = l_ra_id_pl
5368: and start_date = l_start_date;
5369:
5370: --Bug 4947912

Line 5383: from pa_fin_plan_adj_lines

5379: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5380:
5381: select sum(nvl(head_count_adjustment,0))
5382: into l_period_amount
5383: from pa_fin_plan_adj_lines
5384: where resource_assignment_id = l_ra_id_pl
5385: and start_date = l_start_date;
5386:
5387: --Bug 4947912

Line 5401: from pa_fin_plan_adj_lines

5397: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5398:
5399: select sum(nvl(utilization_adjustment,0))
5400: into l_period_amount
5401: from pa_fin_plan_adj_lines
5402: where resource_assignment_id = l_ra_id_pl
5403: and start_date = l_start_date;
5404:
5405: --Bug 4947912

Line 5445: from pa_fin_plan_adj_lines

5441: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5442:
5443: select sum(nvl(revenue_adjustment,0))
5444: into l_period_amount
5445: from pa_fin_plan_adj_lines
5446: where resource_assignment_id = l_ra_id_pl
5447: and start_date = l_start_date;
5448:
5449: --Bug 4947912

Line 5463: from pa_fin_plan_adj_lines

5459: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5460:
5461: select sum(nvl(burdened_cost_adjustment,0))
5462: into l_period_amount
5463: from pa_fin_plan_adj_lines
5464: where resource_assignment_id = l_ra_id_pl
5465: and start_date = l_start_date;
5466:
5467: --Bug 4947912

Line 5481: from pa_fin_plan_adj_lines

5477: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5478:
5479: select sum(nvl(head_count_adjustment,0))
5480: into l_period_amount
5481: from pa_fin_plan_adj_lines
5482: where resource_assignment_id = l_ra_id_pl
5483: and start_date = l_start_date;
5484:
5485: --Bug 4947912

Line 5499: from pa_fin_plan_adj_lines

5495: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5496:
5497: select sum(nvl(utilization_adjustment,0))
5498: into l_period_amount
5499: from pa_fin_plan_adj_lines
5500: where resource_assignment_id = l_ra_id_pl
5501: and start_date = l_start_date;
5502:
5503: --Bug 4947912

Line 5546: from pa_fin_plan_adj_lines

5542: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5543:
5544: select sum(nvl(revenue_adjustment,0))
5545: into l_period_amount
5546: from pa_fin_plan_adj_lines
5547: where resource_assignment_id = l_ra_id_pl
5548: and start_date = l_start_date;
5549:
5550: --Bug 4947912

Line 5564: from pa_fin_plan_adj_lines

5560: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5561:
5562: select sum(nvl(burdened_cost_adjustment,0))
5563: into l_period_amount
5564: from pa_fin_plan_adj_lines
5565: where resource_assignment_id = l_ra_id_pl
5566: and start_date = l_start_date;
5567:
5568: --Bug 4947912

Line 5582: from pa_fin_plan_adj_lines

5578: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5579:
5580: select sum(nvl(head_count_adjustment,0))
5581: into l_period_amount
5582: from pa_fin_plan_adj_lines
5583: where resource_assignment_id = l_ra_id_pl
5584: and start_date = l_start_date;
5585:
5586: --Bug 4947912

Line 5600: from pa_fin_plan_adj_lines

5596: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5597:
5598: select sum(nvl(utilization_adjustment,0))
5599: into l_period_amount
5600: from pa_fin_plan_adj_lines
5601: where resource_assignment_id = l_ra_id_pl
5602: and start_date = l_start_date;
5603:
5604: --Bug 4947912

Line 5645: from pa_fin_plan_adj_lines

5641: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5642:
5643: select sum(nvl(revenue_adjustment,0))
5644: into l_period_amount
5645: from pa_fin_plan_adj_lines
5646: where resource_assignment_id = l_ra_id_pl
5647: and start_date = l_start_date;
5648:
5649: --Bug 4947912

Line 5663: from pa_fin_plan_adj_lines

5659: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5660:
5661: select sum(nvl(burdened_cost_adjustment,0))
5662: into l_period_amount
5663: from pa_fin_plan_adj_lines
5664: where resource_assignment_id = l_ra_id_pl
5665: and start_date = l_start_date;
5666:
5667: --Bug 4947912

Line 5680: from pa_fin_plan_adj_lines

5676: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5677:
5678: select sum(nvl(head_count_adjustment,0))
5679: into l_period_amount
5680: from pa_fin_plan_adj_lines
5681: where resource_assignment_id = l_ra_id_pl
5682: and start_date = l_start_date;
5683:
5684: --Bug 4947912

Line 5698: from pa_fin_plan_adj_lines

5694: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5695:
5696: select sum(nvl(utilization_adjustment,0))
5697: into l_period_amount
5698: from pa_fin_plan_adj_lines
5699: where resource_assignment_id = l_ra_id_pl
5700: and start_date = l_start_date;
5701:
5702: --Bug 4947912

Line 5743: from pa_fin_plan_adj_lines

5739: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5740:
5741: select sum(nvl(revenue_adjustment,0))
5742: into l_period_amount
5743: from pa_fin_plan_adj_lines
5744: where resource_assignment_id = l_ra_id_pl
5745: and start_date = l_start_date;
5746:
5747: --Bug 4947912

Line 5761: from pa_fin_plan_adj_lines

5757: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5758:
5759: select sum(nvl(burdened_cost_adjustment,0))
5760: into l_period_amount
5761: from pa_fin_plan_adj_lines
5762: where resource_assignment_id = l_ra_id_pl
5763: and start_date = l_start_date;
5764: --Bug 4947912
5765: If l_budget_line_id is not null then

Line 5777: from pa_fin_plan_adj_lines

5773: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5774:
5775: select sum(nvl(head_count_adjustment,0))
5776: into l_period_amount
5777: from pa_fin_plan_adj_lines
5778: where resource_assignment_id = l_ra_id_pl
5779: and start_date = l_start_date;
5780: --Bug 4947912
5781: If l_budget_line_id is not null then

Line 5793: from pa_fin_plan_adj_lines

5789: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5790:
5791: select sum(nvl(utilization_adjustment,0))
5792: into l_period_amount
5793: from pa_fin_plan_adj_lines
5794: where resource_assignment_id = l_ra_id_pl
5795: and start_date = l_start_date;
5796: --Bug 4947912
5797: If l_budget_line_id is not null then

Line 5838: from pa_fin_plan_adj_lines

5834: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5835:
5836: select sum(nvl(revenue_adjustment,0))
5837: into l_period_amount
5838: from pa_fin_plan_adj_lines
5839: where resource_assignment_id = l_ra_id_pl
5840: and start_date = l_start_date;
5841:
5842: --Bug 4947912

Line 5856: from pa_fin_plan_adj_lines

5852: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5853:
5854: select sum(nvl(burdened_cost_adjustment,0))
5855: into l_period_amount
5856: from pa_fin_plan_adj_lines
5857: where resource_assignment_id = l_ra_id_pl
5858: and start_date = l_start_date;
5859:
5860: --Bug 4947912

Line 5873: from pa_fin_plan_adj_lines

5869: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5870:
5871: select sum(nvl(head_count_adjustment,0))
5872: into l_period_amount
5873: from pa_fin_plan_adj_lines
5874: where resource_assignment_id = l_ra_id_pl
5875: and start_date = l_start_date;
5876:
5877: --Bug 4947912

Line 5890: from pa_fin_plan_adj_lines

5886: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5887:
5888: select sum(nvl(utilization_adjustment,0))
5889: into l_period_amount
5890: from pa_fin_plan_adj_lines
5891: where resource_assignment_id = l_ra_id_pl
5892: and start_date = l_start_date;
5893:
5894: --Bug 4947912

Line 5931: from pa_fin_plan_adj_lines

5927: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
5928:
5929: select sum(nvl(revenue_adjustment,0))
5930: into l_period_amount
5931: from pa_fin_plan_adj_lines
5932: where resource_assignment_id = l_ra_id_pl
5933: and start_date = l_start_date;
5934:
5935: --Bug 4947912

Line 5949: from pa_fin_plan_adj_lines

5945: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
5946:
5947: select sum(nvl(burdened_cost_adjustment,0))
5948: into l_period_amount
5949: from pa_fin_plan_adj_lines
5950: where resource_assignment_id = l_ra_id_pl
5951: and start_date = l_start_date;
5952:
5953: --Bug 4947912

Line 5966: from pa_fin_plan_adj_lines

5962: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
5963:
5964: select sum(nvl(head_count_adjustment,0))
5965: into l_period_amount
5966: from pa_fin_plan_adj_lines
5967: where resource_assignment_id = l_ra_id_pl
5968: and start_date = l_start_date;
5969:
5970: --Bug 4947912

Line 5983: from pa_fin_plan_adj_lines

5979: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
5980:
5981: select sum(nvl(utilization_adjustment,0))
5982: into l_period_amount
5983: from pa_fin_plan_adj_lines
5984: where resource_assignment_id = l_ra_id_pl
5985: and start_date = l_start_date;
5986:
5987: --Bug 4947912

Line 6026: from pa_fin_plan_adj_lines

6022: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6023:
6024: select sum(nvl(revenue_adjustment,0))
6025: into l_period_amount
6026: from pa_fin_plan_adj_lines
6027: where resource_assignment_id = l_ra_id_pl
6028: and start_date = l_start_date;
6029:
6030: --Bug 4947912

Line 6044: from pa_fin_plan_adj_lines

6040: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6041:
6042: select sum(nvl(burdened_cost_adjustment,0))
6043: into l_period_amount
6044: from pa_fin_plan_adj_lines
6045: where resource_assignment_id = l_ra_id_pl
6046: and start_date = l_start_date;
6047:
6048: --Bug 4947912

Line 6061: from pa_fin_plan_adj_lines

6057: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6058:
6059: select sum(nvl(head_count_adjustment,0))
6060: into l_period_amount
6061: from pa_fin_plan_adj_lines
6062: where resource_assignment_id = l_ra_id_pl
6063: and start_date = l_start_date;
6064:
6065: --Bug 4947912

Line 6078: from pa_fin_plan_adj_lines

6074: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6075:
6076: select sum(nvl(utilization_adjustment,0))
6077: into l_period_amount
6078: from pa_fin_plan_adj_lines
6079: where resource_assignment_id = l_ra_id_pl
6080: and start_date = l_start_date;
6081:
6082: --Bug 4947912

Line 6124: from pa_fin_plan_adj_lines

6120: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6121:
6122: select sum(nvl(revenue_adjustment,0))
6123: into l_period_amount
6124: from pa_fin_plan_adj_lines
6125: where resource_assignment_id = l_ra_id_pl
6126: and start_date = l_start_date;
6127: --Bug 4947912
6128: If l_budget_line_id is not null then

Line 6141: from pa_fin_plan_adj_lines

6137: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6138:
6139: select sum(nvl(burdened_cost_adjustment,0))
6140: into l_period_amount
6141: from pa_fin_plan_adj_lines
6142: where resource_assignment_id = l_ra_id_pl
6143: and start_date = l_start_date;
6144:
6145: --Bug 4947912

Line 6158: from pa_fin_plan_adj_lines

6154: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6155:
6156: select sum(nvl(head_count_adjustment,0))
6157: into l_period_amount
6158: from pa_fin_plan_adj_lines
6159: where resource_assignment_id = l_ra_id_pl
6160: and start_date = l_start_date;
6161:
6162: --Bug 4947912

Line 6175: from pa_fin_plan_adj_lines

6171: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6172:
6173: select sum(nvl(utilization_adjustment,0))
6174: into l_period_amount
6175: from pa_fin_plan_adj_lines
6176: where resource_assignment_id = l_ra_id_pl
6177: and start_date = l_start_date;
6178:
6179: --Bug 4947912

Line 6220: from pa_fin_plan_adj_lines

6216: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6217:
6218: select sum(nvl(revenue_adjustment,0))
6219: into l_period_amount
6220: from pa_fin_plan_adj_lines
6221: where resource_assignment_id = l_ra_id_pl
6222: and start_date = l_start_date;
6223:
6224: --Bug 4947912

Line 6238: from pa_fin_plan_adj_lines

6234: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6235:
6236: select sum(nvl(burdened_cost_adjustment,0))
6237: into l_period_amount
6238: from pa_fin_plan_adj_lines
6239: where resource_assignment_id = l_ra_id_pl
6240: and start_date = l_start_date;
6241:
6242: --Bug 4947912

Line 6255: from pa_fin_plan_adj_lines

6251: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6252:
6253: select sum(nvl(head_count_adjustment,0))
6254: into l_period_amount
6255: from pa_fin_plan_adj_lines
6256: where resource_assignment_id = l_ra_id_pl
6257: and start_date = l_start_date;
6258:
6259: --Bug 4947912

Line 6272: from pa_fin_plan_adj_lines

6268: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6269:
6270: select sum(nvl(utilization_adjustment,0))
6271: into l_period_amount
6272: from pa_fin_plan_adj_lines
6273: where resource_assignment_id = l_ra_id_pl
6274: and start_date = l_start_date;
6275:
6276: --Bug 4947912

Line 6316: from pa_fin_plan_adj_lines

6312: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6313:
6314: select sum(nvl(revenue_adjustment,0))
6315: into l_period_amount
6316: from pa_fin_plan_adj_lines
6317: where resource_assignment_id = l_ra_id_pl
6318: and start_date = l_start_date;
6319:
6320: --Bug 4947912

Line 6334: from pa_fin_plan_adj_lines

6330: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6331:
6332: select sum(nvl(burdened_cost_adjustment,0))
6333: into l_period_amount
6334: from pa_fin_plan_adj_lines
6335: where resource_assignment_id = l_ra_id_pl
6336: and start_date = l_start_date;
6337:
6338: --Bug 4947912

Line 6351: from pa_fin_plan_adj_lines

6347: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6348:
6349: select sum(nvl(head_count_adjustment,0))
6350: into l_period_amount
6351: from pa_fin_plan_adj_lines
6352: where resource_assignment_id = l_ra_id_pl
6353: and start_date = l_start_date;
6354:
6355: --Bug 4947912

Line 6368: from pa_fin_plan_adj_lines

6364: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6365:
6366: select sum(nvl(utilization_adjustment,0))
6367: into l_period_amount
6368: from pa_fin_plan_adj_lines
6369: where resource_assignment_id = l_ra_id_pl
6370: and start_date = l_start_date;
6371:
6372: --Bug 4947912

Line 6419: from pa_fin_plan_adj_lines

6415: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6416:
6417: select sum(nvl(revenue_adjustment,0))
6418: into l_period_amount
6419: from pa_fin_plan_adj_lines
6420: where resource_assignment_id = l_ra_id_tl
6421: and start_date = l_start_date;
6422: --Bug 4947912
6423: If l_budget_line_id is not null then

Line 6436: from pa_fin_plan_adj_lines

6432: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6433:
6434: select sum(nvl(burdened_cost_adjustment,0))
6435: into l_period_amount
6436: from pa_fin_plan_adj_lines
6437: where resource_assignment_id = l_ra_id_tl
6438: and start_date = l_start_date;
6439: --Bug 4947912
6440: If l_budget_line_id is not null then

Line 6452: from pa_fin_plan_adj_lines

6448: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6449:
6450: select sum(nvl(head_count_adjustment,0))
6451: into l_period_amount
6452: from pa_fin_plan_adj_lines
6453: where resource_assignment_id = l_ra_id_tl
6454: and start_date = l_start_date;
6455: --Bug 4947912
6456: If l_budget_line_id is not null then

Line 6468: from pa_fin_plan_adj_lines

6464: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6465:
6466: select sum(nvl(utilization_adjustment,0))
6467: into l_period_amount
6468: from pa_fin_plan_adj_lines
6469: where resource_assignment_id = l_ra_id_tl
6470: and start_date = l_start_date;
6471: --Bug 4947912
6472: If l_budget_line_id is not null then

Line 6511: from pa_fin_plan_adj_lines

6507: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6508:
6509: select sum(nvl(revenue_adjustment,0))
6510: into l_period_amount
6511: from pa_fin_plan_adj_lines
6512: where resource_assignment_id = l_ra_id_tl
6513: and start_date = l_start_date;
6514: --Bug 4947912
6515: If l_budget_line_id is not null then

Line 6528: from pa_fin_plan_adj_lines

6524: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6525:
6526: select sum(nvl(burdened_cost_adjustment,0))
6527: into l_period_amount
6528: from pa_fin_plan_adj_lines
6529: where resource_assignment_id = l_ra_id_tl
6530: and start_date = l_start_date;
6531: --Bug 4947912
6532: If l_budget_line_id is not null then

Line 6544: from pa_fin_plan_adj_lines

6540: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6541:
6542: select sum(nvl(head_count_adjustment,0))
6543: into l_period_amount
6544: from pa_fin_plan_adj_lines
6545: where resource_assignment_id = l_ra_id_tl
6546: and start_date = l_start_date;
6547: --Bug 4947912
6548: If l_budget_line_id is not null then

Line 6560: from pa_fin_plan_adj_lines

6556: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6557:
6558: select sum(nvl(utilization_adjustment,0))
6559: into l_period_amount
6560: from pa_fin_plan_adj_lines
6561: where resource_assignment_id = l_ra_id_tl
6562: and start_date = l_start_date;
6563: --Bug 4947912
6564: If l_budget_line_id is not null then

Line 6600: from pa_fin_plan_adj_lines

6596: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6597:
6598: select sum(nvl(revenue_adjustment,0))
6599: into l_period_amount
6600: from pa_fin_plan_adj_lines
6601: where resource_assignment_id = l_ra_id_tl
6602: and start_date = l_start_date;
6603: --Bug 4947912
6604: If l_budget_line_id is not null then

Line 6617: from pa_fin_plan_adj_lines

6613: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6614:
6615: select sum(nvl(burdened_cost_adjustment,0))
6616: into l_period_amount
6617: from pa_fin_plan_adj_lines
6618: where resource_assignment_id = l_ra_id_tl
6619: and start_date = l_start_date;
6620: --Bug 4947912
6621: If l_budget_line_id is not null then

Line 6633: from pa_fin_plan_adj_lines

6629: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6630:
6631: select sum(nvl(head_count_adjustment,0))
6632: into l_period_amount
6633: from pa_fin_plan_adj_lines
6634: where resource_assignment_id = l_ra_id_tl
6635: and start_date = l_start_date;
6636: --Bug 4947912
6637: If l_budget_line_id is not null then

Line 6649: from pa_fin_plan_adj_lines

6645: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6646:
6647: select sum(nvl(utilization_adjustment,0))
6648: into l_period_amount
6649: from pa_fin_plan_adj_lines
6650: where resource_assignment_id = l_ra_id_tl
6651: and start_date = l_start_date;
6652: --Bug 4947912
6653: If l_budget_line_id is not null then

Line 6690: from pa_fin_plan_adj_lines

6686: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6687:
6688: select sum(nvl(revenue_adjustment,0))
6689: into l_period_amount
6690: from pa_fin_plan_adj_lines
6691: where resource_assignment_id = l_ra_id_tl
6692: and start_date = l_start_date;
6693: --Bug 4947912
6694: If l_budget_line_id is not null then

Line 6707: from pa_fin_plan_adj_lines

6703: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6704:
6705: select sum(nvl(burdened_cost_adjustment,0))
6706: into l_period_amount
6707: from pa_fin_plan_adj_lines
6708: where resource_assignment_id = l_ra_id_tl
6709: and start_date = l_start_date;
6710: --Bug 4947912
6711: If l_budget_line_id is not null then

Line 6723: from pa_fin_plan_adj_lines

6719: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6720:
6721: select sum(nvl(head_count_adjustment,0))
6722: into l_period_amount
6723: from pa_fin_plan_adj_lines
6724: where resource_assignment_id = l_ra_id_tl
6725: and start_date = l_start_date;
6726: --Bug 4947912
6727: If l_budget_line_id is not null then

Line 6739: from pa_fin_plan_adj_lines

6735: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6736:
6737: select sum(nvl(utilization_adjustment,0))
6738: into l_period_amount
6739: from pa_fin_plan_adj_lines
6740: where resource_assignment_id = l_ra_id_tl
6741: and start_date = l_start_date;
6742: --Bug 4947912
6743: If l_budget_line_id is not null then

Line 6782: from pa_fin_plan_adj_lines

6778: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6779:
6780: select sum(nvl(revenue_adjustment,0))
6781: into l_period_amount
6782: from pa_fin_plan_adj_lines
6783: where resource_assignment_id = l_ra_id_tl
6784: and start_date = l_start_date;
6785: --Bug 4947912
6786: If l_budget_line_id is not null then

Line 6799: from pa_fin_plan_adj_lines

6795: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6796:
6797: select sum(nvl(burdened_cost_adjustment,0))
6798: into l_period_amount
6799: from pa_fin_plan_adj_lines
6800: where resource_assignment_id = l_ra_id_tl
6801: and start_date = l_start_date;
6802: --Bug 4947912
6803: If l_budget_line_id is not null then

Line 6815: from pa_fin_plan_adj_lines

6811: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6812:
6813: select sum(nvl(head_count_adjustment,0))
6814: into l_period_amount
6815: from pa_fin_plan_adj_lines
6816: where resource_assignment_id = l_ra_id_tl
6817: and start_date = l_start_date;
6818: --Bug 4947912
6819: If l_budget_line_id is not null then

Line 6831: from pa_fin_plan_adj_lines

6827: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6828:
6829: select sum(nvl(utilization_adjustment,0))
6830: into l_period_amount
6831: from pa_fin_plan_adj_lines
6832: where resource_assignment_id = l_ra_id_tl
6833: and start_date = l_start_date;
6834: --Bug 4947912
6835: If l_budget_line_id is not null then

Line 6874: from pa_fin_plan_adj_lines

6870: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6871:
6872: select sum(nvl(revenue_adjustment,0))
6873: into l_period_amount
6874: from pa_fin_plan_adj_lines
6875: where resource_assignment_id = l_ra_id_tl
6876: and start_date = l_start_date;
6877: --Bug 4947912
6878: If l_budget_line_id is not null then

Line 6891: from pa_fin_plan_adj_lines

6887: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6888:
6889: select sum(nvl(burdened_cost_adjustment,0))
6890: into l_period_amount
6891: from pa_fin_plan_adj_lines
6892: where resource_assignment_id = l_ra_id_tl
6893: and start_date = l_start_date;
6894: --Bug 4947912
6895: If l_budget_line_id is not null then

Line 6907: from pa_fin_plan_adj_lines

6903: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6904:
6905: select sum(nvl(head_count_adjustment,0))
6906: into l_period_amount
6907: from pa_fin_plan_adj_lines
6908: where resource_assignment_id = l_ra_id_tl
6909: and start_date = l_start_date;
6910: --Bug 4947912
6911: If l_budget_line_id is not null then

Line 6923: from pa_fin_plan_adj_lines

6919: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
6920:
6921: select sum(nvl(utilization_adjustment,0))
6922: into l_period_amount
6923: from pa_fin_plan_adj_lines
6924: where resource_assignment_id = l_ra_id_tl
6925: and start_date = l_start_date;
6926: --Bug 4947912
6927: If l_budget_line_id is not null then

Line 6966: from pa_fin_plan_adj_lines

6962: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
6963:
6964: select sum(nvl(revenue_adjustment,0))
6965: into l_period_amount
6966: from pa_fin_plan_adj_lines
6967: where resource_assignment_id = l_ra_id_tl
6968: and start_date = l_start_date;
6969: --Bug 4947912
6970: If l_budget_line_id is not null then

Line 6983: from pa_fin_plan_adj_lines

6979: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
6980:
6981: select sum(nvl(burdened_cost_adjustment,0))
6982: into l_period_amount
6983: from pa_fin_plan_adj_lines
6984: where resource_assignment_id = l_ra_id_tl
6985: and start_date = l_start_date;
6986: --Bug 4947912
6987: If l_budget_line_id is not null then

Line 6999: from pa_fin_plan_adj_lines

6995: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
6996:
6997: select sum(nvl(head_count_adjustment,0))
6998: into l_period_amount
6999: from pa_fin_plan_adj_lines
7000: where resource_assignment_id = l_ra_id_tl
7001: and start_date = l_start_date;
7002: --Bug 4947912
7003: If l_budget_line_id is not null then

Line 7015: from pa_fin_plan_adj_lines

7011: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
7012:
7013: select sum(nvl(utilization_adjustment,0))
7014: into l_period_amount
7015: from pa_fin_plan_adj_lines
7016: where resource_assignment_id = l_ra_id_tl
7017: and start_date = l_start_date;
7018: --Bug 4947912
7019: If l_budget_line_id is not null then

Line 7058: from pa_fin_plan_adj_lines

7054: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
7055:
7056: select sum(nvl(revenue_adjustment,0))
7057: into l_period_amount
7058: from pa_fin_plan_adj_lines
7059: where resource_assignment_id = l_ra_id_tl
7060: and start_date = l_start_date;
7061: --Bug 4947912
7062: If l_budget_line_id is not null then

Line 7075: from pa_fin_plan_adj_lines

7071: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
7072:
7073: select sum(nvl(burdened_cost_adjustment,0))
7074: into l_period_amount
7075: from pa_fin_plan_adj_lines
7076: where resource_assignment_id = l_ra_id_tl
7077: and start_date = l_start_date;
7078: --Bug 4947912
7079: If l_budget_line_id is not null then

Line 7091: from pa_fin_plan_adj_lines

7087: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
7088:
7089: select sum(nvl(head_count_adjustment,0))
7090: into l_period_amount
7091: from pa_fin_plan_adj_lines
7092: where resource_assignment_id = l_ra_id_tl
7093: and start_date = l_start_date;
7094: --Bug 4947912
7095: If l_budget_line_id is not null then

Line 7107: from pa_fin_plan_adj_lines

7103: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
7104:
7105: select sum(nvl(utilization_adjustment,0))
7106: into l_period_amount
7107: from pa_fin_plan_adj_lines
7108: where resource_assignment_id = l_ra_id_tl
7109: and start_date = l_start_date;
7110: --Bug 4947912
7111: If l_budget_line_id is not null then

Line 7147: from pa_fin_plan_adj_lines

7143: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
7144:
7145: select sum(nvl(revenue_adjustment,0))
7146: into l_period_amount
7147: from pa_fin_plan_adj_lines
7148: where resource_assignment_id = l_ra_id_tl
7149: and start_date = l_start_date;
7150: --Bug 4947912
7151: If l_budget_line_id is not null then

Line 7164: from pa_fin_plan_adj_lines

7160: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
7161:
7162: select sum(nvl(burdened_cost_adjustment,0))
7163: into l_period_amount
7164: from pa_fin_plan_adj_lines
7165: where resource_assignment_id = l_ra_id_tl
7166: and start_date = l_start_date;
7167: --Bug 4947912
7168: If l_budget_line_id is not null then

Line 7180: from pa_fin_plan_adj_lines

7176: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
7177:
7178: select sum(nvl(head_count_adjustment,0))
7179: into l_period_amount
7180: from pa_fin_plan_adj_lines
7181: where resource_assignment_id = l_ra_id_tl
7182: and start_date = l_start_date;
7183: --Bug 4947912
7184: If l_budget_line_id is not null then

Line 7196: from pa_fin_plan_adj_lines

7192: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
7193:
7194: select sum(nvl(utilization_adjustment,0))
7195: into l_period_amount
7196: from pa_fin_plan_adj_lines
7197: where resource_assignment_id = l_ra_id_tl
7198: and start_date = l_start_date;
7199: --Bug 4947912
7200: If l_budget_line_id is not null then

Line 7237: from pa_fin_plan_adj_lines

7233: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
7234:
7235: select sum(nvl(revenue_adjustment,0))
7236: into l_period_amount
7237: from pa_fin_plan_adj_lines
7238: where resource_assignment_id = l_ra_id_tl
7239: and start_date = l_start_date;
7240: --Bug 4947912
7241: If l_budget_line_id is not null then

Line 7254: from pa_fin_plan_adj_lines

7250: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
7251:
7252: select sum(nvl(burdened_cost_adjustment,0))
7253: into l_period_amount
7254: from pa_fin_plan_adj_lines
7255: where resource_assignment_id = l_ra_id_tl
7256: and start_date = l_start_date;
7257: --Bug 4947912
7258: If l_budget_line_id is not null then

Line 7270: from pa_fin_plan_adj_lines

7266: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
7267:
7268: select sum(nvl(head_count_adjustment,0))
7269: into l_period_amount
7270: from pa_fin_plan_adj_lines
7271: where resource_assignment_id = l_ra_id_tl
7272: and start_date = l_start_date;
7273: --Bug 4947912
7274: If l_budget_line_id is not null then

Line 7286: from pa_fin_plan_adj_lines

7282: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
7283:
7284: select sum(nvl(utilization_adjustment,0))
7285: into l_period_amount
7286: from pa_fin_plan_adj_lines
7287: where resource_assignment_id = l_ra_id_tl
7288: and start_date = l_start_date;
7289: --Bug 4947912
7290: If l_budget_line_id is not null then

Line 7329: from pa_fin_plan_adj_lines

7325: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
7326:
7327: select sum(nvl(revenue_adjustment,0))
7328: into l_period_amount
7329: from pa_fin_plan_adj_lines
7330: where resource_assignment_id = l_ra_id_tl
7331: and start_date = l_start_date;
7332: --Bug 4947912
7333: If l_budget_line_id is not null then

Line 7347: from pa_fin_plan_adj_lines

7343: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
7344:
7345: select sum(nvl(burdened_cost_adjustment,0))
7346: into l_period_amount
7347: from pa_fin_plan_adj_lines
7348: where resource_assignment_id = l_ra_id_tl
7349: and start_date = l_start_date;
7350: --Bug 4947912
7351: If l_budget_line_id is not null then

Line 7363: from pa_fin_plan_adj_lines

7359: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
7360:
7361: select sum(nvl(head_count_adjustment,0))
7362: into l_period_amount
7363: from pa_fin_plan_adj_lines
7364: where resource_assignment_id = l_ra_id_tl
7365: and start_date = l_start_date;
7366: --Bug 4947912
7367: If l_budget_line_id is not null then

Line 7379: from pa_fin_plan_adj_lines

7375: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
7376:
7377: select sum(nvl(utilization_adjustment,0))
7378: into l_period_amount
7379: from pa_fin_plan_adj_lines
7380: where resource_assignment_id = l_ra_id_tl
7381: and start_date = l_start_date;
7382: --Bug 4947912
7383: If l_budget_line_id is not null then

Line 7422: from pa_fin_plan_adj_lines

7418: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
7419:
7420: select sum(nvl(revenue_adjustment,0))
7421: into l_period_amount
7422: from pa_fin_plan_adj_lines
7423: where resource_assignment_id = l_ra_id_tl
7424: and start_date = l_start_date;
7425: --Bug 4947912
7426: If l_budget_line_id is not null then

Line 7439: from pa_fin_plan_adj_lines

7435: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
7436:
7437: select sum(nvl(burdened_cost_adjustment,0))
7438: into l_period_amount
7439: from pa_fin_plan_adj_lines
7440: where resource_assignment_id = l_ra_id_tl
7441: and start_date = l_start_date;
7442: --Bug 4947912
7443: If l_budget_line_id is not null then

Line 7455: from pa_fin_plan_adj_lines

7451: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
7452:
7453: select sum(nvl(head_count_adjustment,0))
7454: into l_period_amount
7455: from pa_fin_plan_adj_lines
7456: where resource_assignment_id = l_ra_id_tl
7457: and start_date = l_start_date;
7458: --Bug 4947912
7459: If l_budget_line_id is not null then

Line 7471: from pa_fin_plan_adj_lines

7467: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
7468:
7469: select sum(nvl(utilization_adjustment,0))
7470: into l_period_amount
7471: from pa_fin_plan_adj_lines
7472: where resource_assignment_id = l_ra_id_tl
7473: and start_date = l_start_date;
7474: --Bug 4947912
7475: If l_budget_line_id is not null then

Line 7514: from pa_fin_plan_adj_lines

7510: IF l_amount_subtype_code = 'REVENUE_ADJUSTMENTS' then
7511:
7512: select sum(nvl(revenue_adjustment,0))
7513: into l_period_amount
7514: from pa_fin_plan_adj_lines
7515: where resource_assignment_id = l_ra_id_tl
7516: and start_date = l_start_date;
7517: --Bug 4947912
7518: If l_budget_line_id is not null then

Line 7531: from pa_fin_plan_adj_lines

7527: IF l_amount_subtype_code = 'COST_ADJUSTMENTS' then
7528:
7529: select sum(nvl(burdened_cost_adjustment,0))
7530: into l_period_amount
7531: from pa_fin_plan_adj_lines
7532: where resource_assignment_id = l_ra_id_tl
7533: and start_date = l_start_date;
7534: --Bug 4947912
7535: If l_budget_line_id is not null then

Line 7547: from pa_fin_plan_adj_lines

7543: IF l_amount_subtype_code = 'HEADCOUNT_ADJUSTMENTS' then
7544:
7545: select sum(nvl(head_count_adjustment,0))
7546: into l_period_amount
7547: from pa_fin_plan_adj_lines
7548: where resource_assignment_id = l_ra_id_tl
7549: and start_date = l_start_date;
7550: --Bug 4947912
7551: If l_budget_line_id is not null then

Line 7563: from pa_fin_plan_adj_lines

7559: IF l_amount_subtype_code = 'UTILIZATION_ADJUSTMENTS' then
7560:
7561: select sum(nvl(utilization_adjustment,0))
7562: into l_period_amount
7563: from pa_fin_plan_adj_lines
7564: where resource_assignment_id = l_ra_id_tl
7565: and start_date = l_start_date;
7566: --Bug 4947912
7567: If l_budget_line_id is not null then