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_COST_PLUS dependencies on PA_TASKS

Line 2011: --PA_TASKS TASK, /* Bug 3458139 */

2007: TYPE.burden_amt_display_method,
2008: ITEM.adjusted_expenditure_item_id, -- Bug 3893837
2009: ITEM.project_id -- added bug 8248419
2010: FROM PA_Expenditure_Items ITEM,
2011: --PA_TASKS TASK, /* Bug 3458139 */
2012: PA_PROJECTS_ALL PROJ,
2013: PA_PROJECT_TYPES_ALL TYPE
2014: WHERE ITEM.Cost_Distributed_Flag = 'S'
2015: AND ITEM.Denom_Raw_Cost IS NOT NULL

Line 2607: FROM PA_TASKS TASK,

2603: * between local variable name and the column name in database.
2604: */
2605: CURSOR Burden_Method_Cursor(l_task_id in number) IS
2606: SELECT TYPE.burden_amt_display_method
2607: FROM PA_TASKS TASK,
2608: PA_PROJECTS_ALL PROJ,
2609: PA_PROJECT_TYPES_ALL TYPE
2610: WHERE
2611: TASK.Task_ID = l_task_id

Line 3108: FROM pa_tasks t,

3104: SELECT irs.ind_rate_sch_id,
3105: t.cost_ind_sch_fixed_date
3106: INTO sch_id,
3107: sch_fixed_date
3108: FROM pa_tasks t,
3109: pa_ind_rate_schedules irs
3110: WHERE t.task_id = t_id
3111: AND t.task_id = irs.task_id
3112: AND irs.cost_ovr_sch_flag = 'Y';

Line 3120: FROM pa_tasks t,

3116: SELECT irs.ind_rate_sch_id,
3117: t.rev_ind_sch_fixed_date
3118: INTO sch_id,
3119: sch_fixed_date
3120: FROM pa_tasks t,
3121: pa_ind_rate_schedules irs
3122: WHERE t.task_id = t_id
3123: AND t.task_id = irs.task_id
3124: AND irs.rev_ovr_sch_flag = 'Y';

Line 3132: FROM pa_tasks t,

3128: SELECT irs.ind_rate_sch_id,
3129: t.inv_ind_sch_fixed_date
3130: INTO sch_id,
3131: sch_fixed_date
3132: FROM pa_tasks t,
3133: pa_ind_rate_schedules irs
3134: WHERE t.task_id = t_id
3135: AND t.task_id = irs.task_id
3136: AND irs.inv_ovr_sch_flag = 'Y';

Line 3253: FROM pa_tasks t,

3249: SELECT irs.ind_rate_sch_id,
3250: p.cost_ind_sch_fixed_date
3251: INTO sch_id,
3252: sch_fixed_date
3253: FROM pa_tasks t,
3254: pa_projects_all p,
3255: pa_ind_rate_schedules irs
3256: WHERE t.task_id = t_id
3257: AND t.project_id = p.project_id

Line 3268: FROM pa_tasks t,

3264: SELECT irs.ind_rate_sch_id,
3265: p.rev_ind_sch_fixed_date
3266: INTO sch_id,
3267: sch_fixed_date
3268: FROM pa_tasks t,
3269: pa_projects_all p,
3270: pa_ind_rate_schedules irs
3271: WHERE t.task_id = t_id
3272: AND t.project_id = p.project_id

Line 3283: FROM pa_tasks t,

3279: SELECT irs.ind_rate_sch_id,
3280: p.inv_ind_sch_fixed_date
3281: INTO sch_id,
3282: sch_fixed_date
3283: FROM pa_tasks t,
3284: pa_projects_all p,
3285: pa_ind_rate_schedules irs
3286: WHERE t.task_id = t_id
3287: AND t.project_id = p.project_id

Line 3340: FROM pa_tasks

3336: SELECT cost_ind_rate_sch_id,
3337: cost_ind_sch_fixed_date
3338: INTO sch_id,
3339: sch_fixed_date
3340: FROM pa_tasks
3341: WHERE task_id = t_id;
3342:
3343: ELSIF (schedule_type = 'R') THEN
3344:

Line 3349: FROM pa_tasks

3345: SELECT rev_ind_rate_sch_id,
3346: rev_ind_sch_fixed_date
3347: INTO sch_id,
3348: sch_fixed_date
3349: FROM pa_tasks
3350: WHERE task_id = t_id;
3351:
3352: ELSE
3353:

Line 3358: FROM pa_tasks

3354: SELECT inv_ind_rate_sch_id,
3355: inv_ind_sch_fixed_date
3356: INTO sch_id,
3357: sch_fixed_date
3358: FROM pa_tasks
3359: WHERE task_id = t_id;
3360:
3361: END IF;
3362:

Line 4858: FROM pa_tasks task

4854: FROM pa_expenditure_items_all ei
4855: WHERE cost_ind_compiled_set_id = compiled_set_id
4856: AND EXISTS
4857: (SELECT task_id
4858: FROM pa_tasks task
4859: WHERE task.task_id = ei.task_id
4860: AND task.cost_ind_sch_fixed_date BETWEEN --Bug 5917245 Removed TRUNC
4861: l_start_date AND
4862: NVL(l_end_date, cost_ind_sch_fixed_date))

Line 4866: FROM pa_projects_all p, pa_tasks t

4862: NVL(l_end_date, cost_ind_sch_fixed_date))
4863: AND nvl(ei.net_zero_adjustment_flag,'N') <>'Y'
4864: /******** AND ei.task_id NOT IN
4865: (select t.task_id
4866: FROM pa_projects_all p, pa_tasks t
4867: WHERE t.project_id=p.project_id AND
4868: ei.task_id = t.task_id AND
4869: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4870: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4880: FROM pa_tasks task

4876: FROM pa_expenditure_items_all ei
4877: WHERE rev_ind_compiled_set_id = compiled_set_id
4878: AND EXISTS
4879: (SELECT task_id
4880: FROM pa_tasks task
4881: WHERE task.task_id = ei.task_id
4882: AND (task.rev_ind_sch_fixed_date BETWEEN --Bug 5917245 Removed TRUNC
4883: l_start_date AND
4884: NVL(l_end_date, rev_ind_sch_fixed_date)))

Line 4888: FROM pa_projects_all p, pa_tasks t

4884: NVL(l_end_date, rev_ind_sch_fixed_date)))
4885: AND nvl(ei.net_zero_adjustment_flag ,'N')<>'Y'
4886: /********AND ei.task_id NOT IN
4887: (select t.task_id
4888: FROM pa_projects_all p, pa_tasks t
4889: WHERE t.project_id=p.project_id AND
4890: ei.task_id = t.task_id AND
4891: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4892: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4902: FROM pa_tasks task

4898: FROM pa_expenditure_items_all ei
4899: WHERE inv_ind_compiled_set_id = compiled_set_id
4900: AND EXISTS
4901: (SELECT task_id
4902: FROM pa_tasks task
4903: WHERE task.task_id = ei.task_id
4904: AND (task.inv_ind_sch_fixed_date BETWEEN --Bug 5917245Removed TRUNC
4905: l_start_date AND
4906: NVL(l_end_date, inv_ind_sch_fixed_date)))

Line 4910: FROM pa_projects_all p, pa_tasks t

4906: NVL(l_end_date, inv_ind_sch_fixed_date)))
4907: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4908: /***** AND ei.task_id NOT IN
4909: (select t.task_id
4910: FROM pa_projects_all p, pa_tasks t
4911: WHERE t.project_id=p.project_id AND
4912: ei.task_id = t.task_id AND
4913: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4914: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4928: FROM pa_tasks task

4924: l_start_date AND
4925: NVL(l_end_date, expenditure_item_date)
4926: AND EXISTS
4927: (SELECT task_id
4928: FROM pa_tasks task
4929: WHERE task.task_id = ei.task_id
4930: AND task.cost_ind_sch_fixed_date IS NULL)
4931: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4932: /****** AND ei.task_id NOT IN

Line 4934: FROM pa_projects_all p, pa_tasks t

4930: AND task.cost_ind_sch_fixed_date IS NULL)
4931: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4932: /****** AND ei.task_id NOT IN
4933: (select t.task_id
4934: FROM pa_projects_all p, pa_tasks t
4935: WHERE t.project_id=p.project_id AND
4936: ei.task_id = t.task_id AND
4937: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4938: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4952: FROM pa_tasks task

4948: l_start_date AND
4949: NVL(l_end_date, expenditure_item_date)
4950: AND EXISTS
4951: (SELECT task_id
4952: FROM pa_tasks task
4953: WHERE task.task_id = ei.task_id
4954: AND task.rev_ind_sch_fixed_date IS NULL)
4955: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4956: /****** AND ei.task_id NOT IN

Line 4958: FROM pa_projects_all p, pa_tasks t

4954: AND task.rev_ind_sch_fixed_date IS NULL)
4955: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4956: /****** AND ei.task_id NOT IN
4957: (select t.task_id
4958: FROM pa_projects_all p, pa_tasks t
4959: WHERE t.project_id=p.project_id AND
4960: ei.task_id = t.task_id AND
4961: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4962: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4976: FROM pa_tasks task

4972: l_start_date AND
4973: NVL(l_end_date, expenditure_item_date)
4974: AND EXISTS
4975: (SELECT task_id
4976: FROM pa_tasks task
4977: WHERE task.task_id = ei.task_id
4978: AND task.inv_ind_sch_fixed_date IS NULL)
4979: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4980: /****** AND ei.task_id NOT IN

Line 4982: FROM pa_projects_all p, pa_tasks t

4978: AND task.inv_ind_sch_fixed_date IS NULL)
4979: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4980: /****** AND ei.task_id NOT IN
4981: (select t.task_id
4982: FROM pa_projects_all p, pa_tasks t
4983: WHERE t.project_id=p.project_id AND
4984: ei.task_id = t.task_id AND
4985: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
4986: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5000: FROM pa_projects_all p, pa_tasks t

4996: l_start_date AND NVL(l_end_date, expenditure_item_date)
4997: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4998: /****** AND ei.task_id NOT IN
4999: (select t.task_id
5000: FROM pa_projects_all p, pa_tasks t
5001: WHERE t.project_id=p.project_id AND
5002: ei.task_id = t.task_id AND
5003: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5004: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5018: FROM pa_projects_all p, pa_tasks t

5014: NVL(l_end_date, expenditure_item_date)
5015: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5016: /*****AND ei.task_id NOT IN
5017: (select t.task_id
5018: FROM pa_projects_all p, pa_tasks t
5019: WHERE t.project_id=p.project_id AND
5020: ei.task_id = t.task_id AND
5021: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5022: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5036: FROM pa_projects_all p, pa_tasks t

5032: NVL(l_end_date, expenditure_item_date)
5033: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5034: /***** AND ei.task_id NOT IN
5035: (select t.task_id
5036: FROM pa_projects_all p, pa_tasks t
5037: WHERE t.project_id=p.project_id AND
5038: ei.task_id = t.task_id AND
5039: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915 */
5040: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5052: pa_tasks t1

5048: AND EXISTS
5049: (SELECT t1.task_id
5050: FROM pa_project_types_all pt,
5051: pa_projects_all p,
5052: pa_tasks t1
5053: WHERE pt.project_type = p.project_type
5054: /* AND nvl(pt.org_id, -99) = nvl(p.org_id, -99) Bug 5374745 */
5055: AND pt.org_id = p.org_id -- bug 5374745
5056: AND p.project_id = t1.project_id

Line 5066: FROM pa_projects_all p, pa_tasks t

5062: AND pt.capital_cost_type_code = 'B')
5063: AND nvl(ei.net_zero_adjustment_flag,'N') <>'Y'
5064: /**** AND ei.task_id NOT IN
5065: (select t.task_id
5066: FROM pa_projects_all p, pa_tasks t
5067: WHERE t.project_id=p.project_id AND
5068: ei.task_id = t.task_id AND
5069: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5070: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5085: pa_tasks t1

5081: AND EXISTS
5082: (SELECT /*+ no_unnest */ t1.task_id --Bug 12811820
5083: FROM pa_project_types_all pt,
5084: pa_projects_all p,
5085: pa_tasks t1
5086: WHERE pt.project_type = p.project_type
5087: /* AND nvl(pt.org_id, -99) = nvl(p.org_id, -99) bug 5374745 */
5088: AND pt.org_id = p.org_id -- bug 5374745
5089: AND p.project_id = t1.project_id

Line 5097: FROM pa_projects_all p, pa_tasks t

5093: AND pt.capital_cost_type_code = 'B')
5094: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5095: /***** AND ei.task_id NOT IN
5096: (select t.task_id
5097: FROM pa_projects_all p, pa_tasks t
5098: WHERE t.project_id=p.project_id AND
5099: ei.task_id = t.task_id AND
5100: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5101: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5116: pa_tasks t1

5112: AND EXISTS
5113: (SELECT /*+ no_unnest */ t1.task_id --Bug 12811820
5114: FROM pa_project_types_all pt,
5115: pa_projects_all p,
5116: pa_tasks t1
5117: WHERE pt.project_type = p.project_type
5118: /* AND nvl(pt.org_id, -99) = nvl(p.org_id, -99) Bug 5374745 */
5119: AND pt.org_id = p.org_id -- bug 5374745
5120: AND p.project_id = t1.project_id

Line 5127: FROM pa_projects_all p, pa_tasks t

5123: AND pt.capital_cost_type_code = 'B')
5124: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5125: /****** AND ei.task_id NOT IN
5126: (select t.task_id
5127: FROM pa_projects_all p, pa_tasks t
5128: WHERE t.project_id=p.project_id AND
5129: ei.task_id = t.task_id AND
5130: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5131: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5149: pa_tasks task,

5145: IS
5146: SELECT expenditure_item_id
5147: FROM pa_expenditure_items_all ei,
5148: pa_system_linkages syslink,
5149: pa_tasks task,
5150: pa_projects_all proj
5151: WHERE ei.tp_ind_compiled_set_id = compiled_set_id
5152: AND ei.system_linkage_function = syslink.function
5153: AND task.task_id = ei.task_id

Line 5179: FROM pa_tasks task, pa_system_linkages syslink /2933915 : ,pa_projects_all proj :Join with pa_projects is not required here /

5175: FROM PA_EXPENDITURE_ITEMS_ALL EI
5176: WHERE tp_ind_compiled_set_id = compiled_set_id
5177: AND EXISTS
5178: (SELECT task_id
5179: FROM pa_tasks task, pa_system_linkages syslink /*2933915 : ,pa_projects_all proj :Join with pa_projects is not required here */
5180: WHERE task.task_id = ei.task_id
5181: AND ei.system_linkage_function = syslink.function
5182: /*AND task.project_id = proj.project_id 2933915*/
5183: AND task.project_id = ei.project_id /*2933915*/

Line 5201: /* pa_tasks task -- Commented for Bug#3585192 */

5197: CURSOR ei14_cursor
5198: IS
5199: SELECT expenditure_item_id
5200: FROM pa_expenditure_items_all ei
5201: /* pa_tasks task -- Commented for Bug#3585192 */
5202: /* pa_projects_all proj :2933915 :Redundant join and hence can be removed */
5203: WHERE tp_ind_compiled_set_id = compiled_set_id
5204: AND ei.expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5205: l_start_date AND

Line 5308: FROM pa_tasks task

5304: burden_cost = NULL
5305: WHERE cost_ind_compiled_set_id = compiled_set_id
5306: AND EXISTS
5307: (SELECT task_id
5308: FROM pa_tasks task
5309: WHERE task.task_id = ei.task_id
5310: AND task.cost_ind_sch_fixed_date BETWEEN
5311: l_start_date AND
5312: NVL(l_end_date, cost_ind_sch_fixed_date))

Line 5316: FROM pa_projects_all p, pa_tasks t

5312: NVL(l_end_date, cost_ind_sch_fixed_date))
5313: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5314: /****** AND ei.task_id NOT IN
5315: (select t.task_id
5316: FROM pa_projects_all p, pa_tasks t
5317: WHERE t.project_id=p.project_id AND
5318: ei.task_id = t.task_id AND
5319: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5320: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/

Line 5395: FROM pa_tasks task

5391: program_update_date = SYSDATE
5392: WHERE rev_ind_compiled_set_id = compiled_set_id
5393: AND EXISTS
5394: (SELECT task_id
5395: FROM pa_tasks task
5396: WHERE task.task_id = ei.task_id
5397: AND task.rev_ind_sch_fixed_date BETWEEN --Bug#5917245 Removed TRUNC
5398: l_start_date AND
5399: NVL(l_end_date, rev_ind_sch_fixed_date))

Line 5403: FROM pa_projects_all p, pa_tasks t

5399: NVL(l_end_date, rev_ind_sch_fixed_date))
5400: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5401: /****2933915 AND ei.task_id NOT IN
5402: (select t.task_id
5403: FROM pa_projects_all p, pa_tasks t
5404: WHERE t.project_id=p.project_id AND
5405: ei.task_id = t.task_id AND
5406: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/
5407: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5463: FROM pa_tasks task

5459: program_update_date = SYSDATE
5460: WHERE inv_ind_compiled_set_id = compiled_set_id
5461: AND EXISTS
5462: (SELECT task_id
5463: FROM pa_tasks task
5464: WHERE task.task_id = ei.task_id
5465: AND task.inv_ind_sch_fixed_date BETWEEN --Bug#5917245 Removed TRUNC
5466: l_start_date AND
5467: NVL(l_end_date, inv_ind_sch_fixed_date))

Line 5471: FROM pa_projects_all p, pa_tasks t

5467: NVL(l_end_date, inv_ind_sch_fixed_date))
5468: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5469: /***** AND ei.task_id NOT IN
5470: (select t.task_id
5471: FROM pa_projects_all p, pa_tasks t
5472: WHERE t.project_id=p.project_id AND
5473: ei.task_id = t.task_id AND
5474: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5475: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5531: pa_tasks t1

5527: AND EXISTS
5528: (SELECT t1.task_id
5529: FROM pa_project_types_all pt,
5530: pa_projects_all p,
5531: pa_tasks t1
5532: WHERE pt.project_type = p.project_type
5533: AND nvl(pt.org_id, -99) = nvl(p.org_id, -99)
5534: AND p.project_id = t1.project_id
5535: AND TRUNC(t1.cost_ind_sch_fixed_date) BETWEEN

Line 5544: FROM pa_projects_all p, pa_tasks t

5540: AND pt.capital_cost_type_code = 'B')
5541: AND nvl(ei.net_zero_adjustment_flag,'N') <>'Y'
5542: /**** AND ei.task_id NOT IN
5543: (select t.task_id
5544: FROM pa_projects_all p, pa_tasks t
5545: WHERE t.project_id=p.project_id AND
5546: ei.task_id = t.task_id AND
5547: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
5548: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5623: FROM pa_tasks task

5619: AND ei.expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5620: l_start_date AND NVL(l_end_date, ei.expenditure_item_date)
5621: AND EXISTS
5622: (SELECT task_id
5623: FROM pa_tasks task
5624: WHERE task.task_id = ei.task_id
5625: AND task.cost_ind_sch_fixed_date IS NULL)
5626: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5627: /***** AND ei.task_id NOT IN

Line 5629: FROM pa_projects_all p, pa_tasks t

5625: AND task.cost_ind_sch_fixed_date IS NULL)
5626: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5627: /***** AND ei.task_id NOT IN
5628: (select t.task_id
5629: FROM pa_projects_all p, pa_tasks t
5630: WHERE t.project_id=p.project_id AND
5631: ei.task_id = t.task_id AND
5632: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5633: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5709: FROM pa_tasks task

5705: l_start_date AND
5706: NVL(l_end_date, expenditure_item_date)
5707: AND EXISTS
5708: (SELECT task_id
5709: FROM pa_tasks task
5710: WHERE task.task_id = ei.task_id
5711: AND task.rev_ind_sch_fixed_date IS NULL)
5712: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5713: /*** AND ei.task_id NOT IN

Line 5715: FROM pa_projects_all p, pa_tasks t

5711: AND task.rev_ind_sch_fixed_date IS NULL)
5712: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5713: /*** AND ei.task_id NOT IN
5714: (select t.task_id
5715: FROM pa_projects_all p, pa_tasks t
5716: WHERE t.project_id=p.project_id AND
5717: ei.task_id = t.task_id AND
5718: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
5719: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5777: FROM pa_tasks task

5773: l_start_date AND
5774: NVL(l_end_date, expenditure_item_date)
5775: AND EXISTS
5776: (SELECT task_id
5777: FROM pa_tasks task
5778: WHERE task.task_id = ei.task_id
5779: AND task.inv_ind_sch_fixed_date IS NULL)
5780: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5781: /*** AND ei.task_id NOT IN

Line 5783: FROM pa_projects_all p, pa_tasks t

5779: AND task.inv_ind_sch_fixed_date IS NULL)
5780: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5781: /*** AND ei.task_id NOT IN
5782: (select t.task_id
5783: FROM pa_projects_all p, pa_tasks t
5784: WHERE t.project_id=p.project_id AND
5785: ei.task_id = t.task_id AND
5786: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5787: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5851: pa_tasks t1

5847: AND EXISTS
5848: (SELECT t1.task_id
5849: FROM pa_project_types_all pt,
5850: pa_projects_all p,
5851: pa_tasks t1
5852: WHERE pt.project_type = p.project_type
5853: AND nvl(pt.org_id, -99) = nvl(p.org_id, -99)
5854: AND p.project_id = t1.project_id
5855: AND t1.cost_ind_sch_fixed_date is NULL

Line 5862: FROM pa_projects_all p, pa_tasks t

5858: AND pt.capital_cost_type_code = 'B')
5859: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5860: /* AND ei.task_id NOT IN
5861: (select t.task_id
5862: FROM pa_projects_all p, pa_tasks t
5863: WHERE t.project_id=p.project_id AND
5864: ei.task_id = t.task_id AND
5865: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5866: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5887: pa_tasks t1

5883: AND EXISTS
5884: (SELECT t1.task_id
5885: FROM pa_project_types_all pt,
5886: pa_projects_all p,
5887: pa_tasks t1
5888: WHERE pt.project_type = p.project_type
5889: AND nvl(pt.org_id, -99) = nvl(p.org_id, -99)
5890: AND p.project_id = t1.project_id
5891: AND t1.cost_ind_sch_fixed_date is NULL

Line 5898: FROM pa_projects_all p, pa_tasks t

5894: AND pt.capital_cost_type_code = 'B')
5895: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5896: /* AND ei.task_id NOT IN
5897: (select t.task_id
5898: FROM pa_projects_all p, pa_tasks t
5899: WHERE t.project_id=p.project_id AND
5900: ei.task_id = t.task_id AND
5901: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5902: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5989: FROM pa_tasks task, pa_system_linkages syslink /, pa_projects_all proj :Redundant :2933915/

5985: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5986: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5987: AND EXISTS
5988: (SELECT task_id
5989: FROM pa_tasks task, pa_system_linkages syslink /*, pa_projects_all proj :Redundant :2933915*/
5990: WHERE task.task_id = ei.task_id
5991: AND ei.system_linkage_function = syslink.function
5992: /* AND task.project_id = proj.project_id Commented for 2933915*/
5993: AND task.project_id = ei.project_id /*2933915*/

Line 6060: FROM pa_tasks task

6056: l_start_date AND
6057: NVL(l_end_date, ITEM.expenditure_item_date))
6058: AND EXISTS
6059: (SELECT task_id
6060: FROM pa_tasks task
6061: WHERE task.task_id = ITEM.task_id
6062: AND task.cost_ind_sch_fixed_date IS NULL)
6063: /*E.N. Bug4560630*/
6064: AND l_burden_profile ='Y'

Line 6085: FROM pa_tasks task

6081: AND ITEM.cost_ind_compiled_set_id = compiled_set_id
6082: /*S.N. Bug4560630*/
6083: AND EXISTS
6084: (SELECT task_id
6085: FROM pa_tasks task
6086: WHERE task.task_id = ITEM.task_id
6087: AND task.cost_ind_sch_fixed_date BETWEEN
6088: l_start_date AND
6089: NVL(l_end_date, cost_ind_sch_fixed_date))

Line 6140: FROM pa_projects_all p, pa_tasks t

6136: -- bug 8668217 NVL(l_end_date, ei.expenditure_item_date)
6137: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6138: /* AND ei.task_id NOT IN
6139: (select t.task_id
6140: FROM pa_projects_all p, pa_tasks t
6141: WHERE t.project_id=p.project_id AND
6142: ei.task_id = t.task_id AND
6143: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6144: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 6171: FROM pa_projects_all p, pa_tasks t

6167: -- bug 8668217 AND NVL(l_end_date, ei.expenditure_item_date)
6168: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6169: /* AND ei.task_id NOT IN
6170: (select t.task_id
6171: FROM pa_projects_all p, pa_tasks t
6172: WHERE t.project_id=p.project_id AND
6173: ei.task_id = t.task_id AND
6174: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6175: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 6254: FROM pa_projects_all p, pa_tasks t

6250: NVL(l_end_date, expenditure_item_date)
6251: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6252: /***** AND ei.task_id NOT IN
6253: (select t.task_id
6254: FROM pa_projects_all p, pa_tasks t
6255: WHERE t.project_id=p.project_id AND
6256: ei.task_id = t.task_id AND
6257: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6258: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

Line 6278: FROM pa_projects_all p, pa_tasks t

6274: NVL(l_end_date, expenditure_item_date)
6275: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6276: /***** AND ei.task_id NOT IN
6277: (select t.task_id
6278: FROM pa_projects_all p, pa_tasks t
6279: WHERE t.project_id=p.project_id AND
6280: ei.task_id = t.task_id AND
6281: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6282: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

Line 6376: FROM pa_projects_all p, pa_tasks t

6372: AND pt.capital_cost_type_code = 'B')
6373: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6374: /**** AND ei.task_id NOT IN
6375: (select t.task_id
6376: FROM pa_projects_all p, pa_tasks t
6377: WHERE t.project_id=p.project_id AND
6378: ei.task_id = t.task_id AND
6379: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6380: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

Line 6412: FROM pa_projects_all p, pa_tasks t

6408: AND pt.capital_cost_type_code = 'B')
6409: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6410: /**** AND ei.task_id NOT IN
6411: (select t.task_id
6412: FROM pa_projects_all p, pa_tasks t
6413: WHERE t.project_id=p.project_id AND
6414: ei.task_id = t.task_id AND
6415: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6416: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

Line 6496: FROM pa_projects_all p, pa_tasks t

6492: NVL(l_end_date, ei.expenditure_item_date)
6493: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6494: /*** AND ei.task_id NOT IN
6495: (select t.task_id
6496: FROM pa_projects_all p, pa_tasks t
6497: WHERE t.project_id=p.project_id AND
6498: ei.task_id = t.task_id AND
6499: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6500: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/