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 2010: --PA_TASKS TASK, /* Bug 3458139 */

2006: nvl(ITEM.net_zero_adjustment_flag,'N') net_zero_adjustment_flag,
2007: TYPE.burden_amt_display_method,
2008: ITEM.adjusted_expenditure_item_id -- Bug 3893837
2009: FROM PA_Expenditure_Items ITEM,
2010: --PA_TASKS TASK, /* Bug 3458139 */
2011: PA_PROJECTS_ALL PROJ,
2012: PA_PROJECT_TYPES_ALL TYPE
2013: WHERE ITEM.Cost_Distributed_Flag = 'S'
2014: AND ITEM.Denom_Raw_Cost IS NOT NULL

Line 2577: FROM PA_TASKS TASK,

2573: * between local variable name and the column name in database.
2574: */
2575: CURSOR Burden_Method_Cursor(l_task_id in number) IS
2576: SELECT TYPE.burden_amt_display_method
2577: FROM PA_TASKS TASK,
2578: PA_PROJECTS_ALL PROJ,
2579: PA_PROJECT_TYPES_ALL TYPE
2580: WHERE
2581: TASK.Task_ID = l_task_id

Line 3078: FROM pa_tasks t,

3074: SELECT irs.ind_rate_sch_id,
3075: t.cost_ind_sch_fixed_date
3076: INTO sch_id,
3077: sch_fixed_date
3078: FROM pa_tasks t,
3079: pa_ind_rate_schedules irs
3080: WHERE t.task_id = t_id
3081: AND t.task_id = irs.task_id
3082: AND irs.cost_ovr_sch_flag = 'Y';

Line 3090: FROM pa_tasks t,

3086: SELECT irs.ind_rate_sch_id,
3087: t.rev_ind_sch_fixed_date
3088: INTO sch_id,
3089: sch_fixed_date
3090: FROM pa_tasks t,
3091: pa_ind_rate_schedules irs
3092: WHERE t.task_id = t_id
3093: AND t.task_id = irs.task_id
3094: AND irs.rev_ovr_sch_flag = 'Y';

Line 3102: FROM pa_tasks t,

3098: SELECT irs.ind_rate_sch_id,
3099: t.inv_ind_sch_fixed_date
3100: INTO sch_id,
3101: sch_fixed_date
3102: FROM pa_tasks t,
3103: pa_ind_rate_schedules irs
3104: WHERE t.task_id = t_id
3105: AND t.task_id = irs.task_id
3106: AND irs.inv_ovr_sch_flag = 'Y';

Line 3223: FROM pa_tasks t,

3219: SELECT irs.ind_rate_sch_id,
3220: p.cost_ind_sch_fixed_date
3221: INTO sch_id,
3222: sch_fixed_date
3223: FROM pa_tasks t,
3224: pa_projects_all p,
3225: pa_ind_rate_schedules irs
3226: WHERE t.task_id = t_id
3227: AND t.project_id = p.project_id

Line 3238: FROM pa_tasks t,

3234: SELECT irs.ind_rate_sch_id,
3235: p.rev_ind_sch_fixed_date
3236: INTO sch_id,
3237: sch_fixed_date
3238: FROM pa_tasks t,
3239: pa_projects_all p,
3240: pa_ind_rate_schedules irs
3241: WHERE t.task_id = t_id
3242: AND t.project_id = p.project_id

Line 3253: FROM pa_tasks t,

3249: SELECT irs.ind_rate_sch_id,
3250: p.inv_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 3310: FROM pa_tasks

3306: SELECT cost_ind_rate_sch_id,
3307: cost_ind_sch_fixed_date
3308: INTO sch_id,
3309: sch_fixed_date
3310: FROM pa_tasks
3311: WHERE task_id = t_id;
3312:
3313: ELSIF (schedule_type = 'R') THEN
3314:

Line 3319: FROM pa_tasks

3315: SELECT rev_ind_rate_sch_id,
3316: rev_ind_sch_fixed_date
3317: INTO sch_id,
3318: sch_fixed_date
3319: FROM pa_tasks
3320: WHERE task_id = t_id;
3321:
3322: ELSE
3323:

Line 3328: FROM pa_tasks

3324: SELECT inv_ind_rate_sch_id,
3325: inv_ind_sch_fixed_date
3326: INTO sch_id,
3327: sch_fixed_date
3328: FROM pa_tasks
3329: WHERE task_id = t_id;
3330:
3331: END IF;
3332:

Line 4828: FROM pa_tasks task

4824: FROM pa_expenditure_items_all ei
4825: WHERE cost_ind_compiled_set_id = compiled_set_id
4826: AND EXISTS
4827: (SELECT task_id
4828: FROM pa_tasks task
4829: WHERE task.task_id = ei.task_id
4830: AND task.cost_ind_sch_fixed_date BETWEEN --Bug 5917245 Removed TRUNC
4831: l_start_date AND
4832: NVL(l_end_date, cost_ind_sch_fixed_date))

Line 4836: FROM pa_projects_all p, pa_tasks t

4832: NVL(l_end_date, cost_ind_sch_fixed_date))
4833: AND nvl(ei.net_zero_adjustment_flag,'N') <>'Y'
4834: /******** AND ei.task_id NOT IN
4835: (select t.task_id
4836: FROM pa_projects_all p, pa_tasks t
4837: WHERE t.project_id=p.project_id AND
4838: ei.task_id = t.task_id AND
4839: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4840: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4850: FROM pa_tasks task

4846: FROM pa_expenditure_items_all ei
4847: WHERE rev_ind_compiled_set_id = compiled_set_id
4848: AND EXISTS
4849: (SELECT task_id
4850: FROM pa_tasks task
4851: WHERE task.task_id = ei.task_id
4852: AND (task.rev_ind_sch_fixed_date BETWEEN --Bug 5917245 Removed TRUNC
4853: l_start_date AND
4854: NVL(l_end_date, rev_ind_sch_fixed_date)))

Line 4858: FROM pa_projects_all p, pa_tasks t

4854: NVL(l_end_date, rev_ind_sch_fixed_date)))
4855: AND nvl(ei.net_zero_adjustment_flag ,'N')<>'Y'
4856: /********AND ei.task_id NOT IN
4857: (select t.task_id
4858: FROM pa_projects_all p, pa_tasks t
4859: WHERE t.project_id=p.project_id AND
4860: ei.task_id = t.task_id AND
4861: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4862: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4872: FROM pa_tasks task

4868: FROM pa_expenditure_items_all ei
4869: WHERE inv_ind_compiled_set_id = compiled_set_id
4870: AND EXISTS
4871: (SELECT task_id
4872: FROM pa_tasks task
4873: WHERE task.task_id = ei.task_id
4874: AND (task.inv_ind_sch_fixed_date BETWEEN --Bug 5917245Removed TRUNC
4875: l_start_date AND
4876: NVL(l_end_date, inv_ind_sch_fixed_date)))

Line 4880: FROM pa_projects_all p, pa_tasks t

4876: NVL(l_end_date, inv_ind_sch_fixed_date)))
4877: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4878: /***** AND ei.task_id NOT IN
4879: (select t.task_id
4880: FROM pa_projects_all p, pa_tasks t
4881: WHERE t.project_id=p.project_id AND
4882: ei.task_id = t.task_id AND
4883: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4884: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4898: FROM pa_tasks task

4894: l_start_date AND
4895: NVL(l_end_date, expenditure_item_date)
4896: AND EXISTS
4897: (SELECT task_id
4898: FROM pa_tasks task
4899: WHERE task.task_id = ei.task_id
4900: AND task.cost_ind_sch_fixed_date IS NULL)
4901: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4902: /****** AND ei.task_id NOT IN

Line 4904: FROM pa_projects_all p, pa_tasks t

4900: AND task.cost_ind_sch_fixed_date IS NULL)
4901: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4902: /****** AND ei.task_id NOT IN
4903: (select t.task_id
4904: FROM pa_projects_all p, pa_tasks t
4905: WHERE t.project_id=p.project_id AND
4906: ei.task_id = t.task_id AND
4907: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4908: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4922: FROM pa_tasks task

4918: l_start_date AND
4919: NVL(l_end_date, expenditure_item_date)
4920: AND EXISTS
4921: (SELECT task_id
4922: FROM pa_tasks task
4923: WHERE task.task_id = ei.task_id
4924: AND task.rev_ind_sch_fixed_date IS NULL)
4925: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4926: /****** AND ei.task_id NOT IN

Line 4928: FROM pa_projects_all p, pa_tasks t

4924: AND task.rev_ind_sch_fixed_date IS NULL)
4925: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4926: /****** AND ei.task_id NOT IN
4927: (select t.task_id
4928: FROM pa_projects_all p, pa_tasks t
4929: WHERE t.project_id=p.project_id AND
4930: ei.task_id = t.task_id AND
4931: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4932: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4946: FROM pa_tasks task

4942: l_start_date AND
4943: NVL(l_end_date, expenditure_item_date)
4944: AND EXISTS
4945: (SELECT task_id
4946: FROM pa_tasks task
4947: WHERE task.task_id = ei.task_id
4948: AND task.inv_ind_sch_fixed_date IS NULL)
4949: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4950: /****** AND ei.task_id NOT IN

Line 4952: FROM pa_projects_all p, pa_tasks t

4948: AND task.inv_ind_sch_fixed_date IS NULL)
4949: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4950: /****** AND ei.task_id NOT IN
4951: (select t.task_id
4952: FROM pa_projects_all p, pa_tasks t
4953: WHERE t.project_id=p.project_id AND
4954: ei.task_id = t.task_id AND
4955: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
4956: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4970: FROM pa_projects_all p, pa_tasks t

4966: l_start_date AND NVL(l_end_date, expenditure_item_date)
4967: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4968: /****** AND ei.task_id NOT IN
4969: (select t.task_id
4970: FROM pa_projects_all p, pa_tasks t
4971: WHERE t.project_id=p.project_id AND
4972: ei.task_id = t.task_id AND
4973: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
4974: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 4988: FROM pa_projects_all p, pa_tasks t

4984: NVL(l_end_date, expenditure_item_date)
4985: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
4986: /*****AND ei.task_id NOT IN
4987: (select t.task_id
4988: FROM pa_projects_all p, pa_tasks t
4989: WHERE t.project_id=p.project_id AND
4990: ei.task_id = t.task_id AND
4991: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
4992: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5006: FROM pa_projects_all p, pa_tasks t

5002: NVL(l_end_date, expenditure_item_date)
5003: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5004: /***** AND ei.task_id NOT IN
5005: (select t.task_id
5006: FROM pa_projects_all p, pa_tasks t
5007: WHERE t.project_id=p.project_id AND
5008: ei.task_id = t.task_id AND
5009: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915 */
5010: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

Line 5022: pa_tasks t1

5018: AND EXISTS
5019: (SELECT t1.task_id
5020: FROM pa_project_types_all pt,
5021: pa_projects_all p,
5022: pa_tasks t1
5023: WHERE pt.project_type = p.project_type
5024: /* AND nvl(pt.org_id, -99) = nvl(p.org_id, -99) Bug 5374745 */
5025: AND pt.org_id = p.org_id -- bug 5374745
5026: AND p.project_id = t1.project_id

Line 5036: FROM pa_projects_all p, pa_tasks t

5032: AND pt.capital_cost_type_code = 'B')
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 5055: pa_tasks t1

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

Line 5067: FROM pa_projects_all p, pa_tasks t

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

Line 5086: pa_tasks t1

5082: AND EXISTS
5083: (SELECT t1.task_id
5084: FROM pa_project_types_all pt,
5085: pa_projects_all p,
5086: pa_tasks t1
5087: WHERE pt.project_type = p.project_type
5088: /* AND nvl(pt.org_id, -99) = nvl(p.org_id, -99) Bug 5374745 */
5089: AND pt.org_id = p.org_id -- bug 5374745
5090: 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 5119: pa_tasks task,

5115: IS
5116: SELECT expenditure_item_id
5117: FROM pa_expenditure_items_all ei,
5118: pa_system_linkages syslink,
5119: pa_tasks task,
5120: pa_projects_all proj
5121: WHERE ei.tp_ind_compiled_set_id = compiled_set_id
5122: AND ei.system_linkage_function = syslink.function
5123: AND task.task_id = ei.task_id

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

5145: FROM PA_EXPENDITURE_ITEMS_ALL EI
5146: WHERE tp_ind_compiled_set_id = compiled_set_id
5147: AND EXISTS
5148: (SELECT task_id
5149: FROM pa_tasks task, pa_system_linkages syslink /*2933915 : ,pa_projects_all proj :Join with pa_projects is not required here */
5150: WHERE task.task_id = ei.task_id
5151: AND ei.system_linkage_function = syslink.function
5152: /*AND task.project_id = proj.project_id 2933915*/
5153: AND task.project_id = ei.project_id /*2933915*/

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

5167: CURSOR ei14_cursor
5168: IS
5169: SELECT expenditure_item_id
5170: FROM pa_expenditure_items_all ei
5171: /* pa_tasks task -- Commented for Bug#3585192 */
5172: /* pa_projects_all proj :2933915 :Redundant join and hence can be removed */
5173: WHERE tp_ind_compiled_set_id = compiled_set_id
5174: AND ei.expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5175: l_start_date AND

Line 5278: FROM pa_tasks task

5274: burden_cost = NULL
5275: WHERE cost_ind_compiled_set_id = compiled_set_id
5276: AND EXISTS
5277: (SELECT task_id
5278: FROM pa_tasks task
5279: WHERE task.task_id = ei.task_id
5280: AND task.cost_ind_sch_fixed_date BETWEEN
5281: l_start_date AND
5282: NVL(l_end_date, cost_ind_sch_fixed_date))

Line 5286: FROM pa_projects_all p, pa_tasks t

5282: NVL(l_end_date, cost_ind_sch_fixed_date))
5283: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5284: /****** AND ei.task_id NOT IN
5285: (select t.task_id
5286: FROM pa_projects_all p, pa_tasks t
5287: WHERE t.project_id=p.project_id AND
5288: ei.task_id = t.task_id AND
5289: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5290: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/

Line 5365: FROM pa_tasks task

5361: program_update_date = SYSDATE
5362: WHERE rev_ind_compiled_set_id = compiled_set_id
5363: AND EXISTS
5364: (SELECT task_id
5365: FROM pa_tasks task
5366: WHERE task.task_id = ei.task_id
5367: AND task.rev_ind_sch_fixed_date BETWEEN --Bug#5917245 Removed TRUNC
5368: l_start_date AND
5369: NVL(l_end_date, rev_ind_sch_fixed_date))

Line 5373: FROM pa_projects_all p, pa_tasks t

5369: NVL(l_end_date, rev_ind_sch_fixed_date))
5370: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5371: /****2933915 AND ei.task_id NOT IN
5372: (select t.task_id
5373: FROM pa_projects_all p, pa_tasks t
5374: WHERE t.project_id=p.project_id AND
5375: ei.task_id = t.task_id AND
5376: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/
5377: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5433: FROM pa_tasks task

5429: program_update_date = SYSDATE
5430: WHERE inv_ind_compiled_set_id = compiled_set_id
5431: AND EXISTS
5432: (SELECT task_id
5433: FROM pa_tasks task
5434: WHERE task.task_id = ei.task_id
5435: AND task.inv_ind_sch_fixed_date BETWEEN --Bug#5917245 Removed TRUNC
5436: l_start_date AND
5437: NVL(l_end_date, inv_ind_sch_fixed_date))

Line 5441: FROM pa_projects_all p, pa_tasks t

5437: NVL(l_end_date, inv_ind_sch_fixed_date))
5438: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5439: /***** AND ei.task_id NOT IN
5440: (select t.task_id
5441: FROM pa_projects_all p, pa_tasks t
5442: WHERE t.project_id=p.project_id AND
5443: ei.task_id = t.task_id AND
5444: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5445: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5501: pa_tasks t1

5497: AND EXISTS
5498: (SELECT t1.task_id
5499: FROM pa_project_types_all pt,
5500: pa_projects_all p,
5501: pa_tasks t1
5502: WHERE pt.project_type = p.project_type
5503: AND nvl(pt.org_id, -99) = nvl(p.org_id, -99)
5504: AND p.project_id = t1.project_id
5505: AND TRUNC(t1.cost_ind_sch_fixed_date) BETWEEN

Line 5514: FROM pa_projects_all p, pa_tasks t

5510: AND pt.capital_cost_type_code = 'B')
5511: AND nvl(ei.net_zero_adjustment_flag,'N') <>'Y'
5512: /**** AND ei.task_id NOT IN
5513: (select t.task_id
5514: FROM pa_projects_all p, pa_tasks t
5515: WHERE t.project_id=p.project_id AND
5516: ei.task_id = t.task_id AND
5517: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
5518: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5593: FROM pa_tasks task

5589: AND ei.expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5590: l_start_date AND NVL(l_end_date, ei.expenditure_item_date)
5591: AND EXISTS
5592: (SELECT task_id
5593: FROM pa_tasks task
5594: WHERE task.task_id = ei.task_id
5595: AND task.cost_ind_sch_fixed_date IS NULL)
5596: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5597: /***** AND ei.task_id NOT IN

Line 5599: FROM pa_projects_all p, pa_tasks t

5595: AND task.cost_ind_sch_fixed_date IS NULL)
5596: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5597: /***** AND ei.task_id NOT IN
5598: (select t.task_id
5599: FROM pa_projects_all p, pa_tasks t
5600: WHERE t.project_id=p.project_id AND
5601: ei.task_id = t.task_id AND
5602: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5603: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5679: FROM pa_tasks task

5675: l_start_date AND
5676: NVL(l_end_date, expenditure_item_date)
5677: AND EXISTS
5678: (SELECT task_id
5679: FROM pa_tasks task
5680: WHERE task.task_id = ei.task_id
5681: AND task.rev_ind_sch_fixed_date IS NULL)
5682: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5683: /*** AND ei.task_id NOT IN

Line 5685: FROM pa_projects_all p, pa_tasks t

5681: AND task.rev_ind_sch_fixed_date IS NULL)
5682: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5683: /*** AND ei.task_id NOT IN
5684: (select t.task_id
5685: FROM pa_projects_all p, pa_tasks t
5686: WHERE t.project_id=p.project_id AND
5687: ei.task_id = t.task_id AND
5688: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
5689: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5747: FROM pa_tasks task

5743: l_start_date AND
5744: NVL(l_end_date, expenditure_item_date)
5745: AND EXISTS
5746: (SELECT task_id
5747: FROM pa_tasks task
5748: WHERE task.task_id = ei.task_id
5749: AND task.inv_ind_sch_fixed_date IS NULL)
5750: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5751: /*** AND ei.task_id NOT IN

Line 5753: FROM pa_projects_all p, pa_tasks t

5749: AND task.inv_ind_sch_fixed_date IS NULL)
5750: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5751: /*** AND ei.task_id NOT IN
5752: (select t.task_id
5753: FROM pa_projects_all p, pa_tasks t
5754: WHERE t.project_id=p.project_id AND
5755: ei.task_id = t.task_id AND
5756: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5757: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 5818: pa_tasks t1

5814: AND EXISTS
5815: (SELECT t1.task_id
5816: FROM pa_project_types_all pt,
5817: pa_projects_all p,
5818: pa_tasks t1
5819: WHERE pt.project_type = p.project_type
5820: AND nvl(pt.org_id, -99) = nvl(p.org_id, -99)
5821: AND p.project_id = t1.project_id
5822: AND t1.cost_ind_sch_fixed_date is NULL

Line 5829: FROM pa_projects_all p, pa_tasks t

5825: AND pt.capital_cost_type_code = 'B')
5826: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5827: /* AND ei.task_id NOT IN
5828: (select t.task_id
5829: FROM pa_projects_all p, pa_tasks t
5830: WHERE t.project_id=p.project_id AND
5831: ei.task_id = t.task_id AND
5832: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5833: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

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

5914: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5915: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5916: AND EXISTS
5917: (SELECT task_id
5918: FROM pa_tasks task, pa_system_linkages syslink /*, pa_projects_all proj :Redundant :2933915*/
5919: WHERE task.task_id = ei.task_id
5920: AND ei.system_linkage_function = syslink.function
5921: /* AND task.project_id = proj.project_id Commented for 2933915*/
5922: AND task.project_id = ei.project_id /*2933915*/

Line 6007: FROM pa_projects_all p, pa_tasks t

6003: l_start_date AND NVL(l_end_date, ei.expenditure_item_date)
6004: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6005: /* AND ei.task_id NOT IN
6006: (select t.task_id
6007: FROM pa_projects_all p, pa_tasks t
6008: WHERE t.project_id=p.project_id AND
6009: ei.task_id = t.task_id AND
6010: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6011: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

Line 6087: FROM pa_projects_all p, pa_tasks t

6083: NVL(l_end_date, expenditure_item_date)
6084: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6085: /***** AND ei.task_id NOT IN
6086: (select t.task_id
6087: FROM pa_projects_all p, pa_tasks t
6088: WHERE t.project_id=p.project_id AND
6089: ei.task_id = t.task_id AND
6090: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6091: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

Line 6174: pa_tasks t1

6170: AND EXISTS
6171: (SELECT t1.task_id
6172: FROM pa_project_types_all pt,
6173: pa_projects_all p,
6174: pa_tasks t1
6175: WHERE pt.project_type = p.project_type
6176: AND nvl(pt.org_id, -99) = nvl(p.org_id, -99)
6177: AND p.project_id = t1.project_id
6178: AND t1.task_id = ei.task_id

Line 6184: FROM pa_projects_all p, pa_tasks t

6180: AND pt.capital_cost_type_code = 'B')
6181: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6182: /**** AND ei.task_id NOT IN
6183: (select t.task_id
6184: FROM pa_projects_all p, pa_tasks t
6185: WHERE t.project_id=p.project_id AND
6186: ei.task_id = t.task_id AND
6187: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6188: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

Line 6269: FROM pa_projects_all p, pa_tasks t

6265: NVL(l_end_date, ei.expenditure_item_date)
6266: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
6267: /*** AND ei.task_id NOT IN
6268: (select t.task_id
6269: FROM pa_projects_all p, pa_tasks t
6270: WHERE t.project_id=p.project_id AND
6271: ei.task_id = t.task_id AND
6272: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6273: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/