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_PROJECTS_ALL

Line 2012: PA_PROJECTS_ALL PROJ,

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
2016: AND (ITEM.Denom_Burdened_Cost IS NULL

Line 2107: FROM pa_projects_all prj, pa_project_types_all prj_type --Bug14158202

2103: -- added bug 8248419 start
2104: CURSOR Cost_Burden_Flag_Cursor (p_project_id Number) IS
2105: SELECT NVL(burden_cost_flag,'N'),
2106: NVL(total_burden_flag,'N')
2107: FROM pa_projects_all prj, pa_project_types_all prj_type --Bug14158202
2108: WHERE prj.project_id = p_project_id
2109: AND prj.project_TYPE = prj_type.project_TYPE;
2110:
2111: l_burden_cost_flag pa_project_types.BURDEN_COST_FLAG%TYPE;

Line 2608: PA_PROJECTS_ALL PROJ,

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
2612: AND TASK.Project_ID = PROJ.Project_ID

Line 3254: pa_projects_all p,

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
3258: AND t.project_id = irs.project_id

Line 3269: pa_projects_all p,

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
3273: AND t.project_id = irs.project_id

Line 3284: pa_projects_all p,

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
3288: AND t.project_id = irs.project_id

Line 4584: pa_projects_all pp

4580:
4581: /*****************************************************************
4582: AND exists (select 1
4583: from pa_project_types_all pt,
4584: pa_projects_all pp
4585: where pp.project_id =ITEM.project_id
4586: AND pp.project_type =pt.project_type
4587: AND pt.burden_amt_display_method in ('D','d')
4588: AND nvl(pt.org_id,-99) =nvl(pp.org_id,-99) )

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 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 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 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 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 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 5051: pa_projects_all p,

5047: WHERE cost_ind_compiled_set_id = compiled_set_id
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

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 5084: pa_projects_all p,

5080: NVL(l_end_date, expenditure_item_date)
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

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 5115: pa_projects_all p,

5111: NVL(l_end_date, expenditure_item_date)
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

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 5150: pa_projects_all proj

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
5154: AND (

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 5202: /* pa_projects_all proj :2933915 :Redundant join and hence can be removed */

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
5206: NVL(l_end_date, ei.expenditure_item_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 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 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 5530: pa_projects_all p,

5526: WHERE cost_ind_compiled_set_id = compiled_set_id
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

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 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 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 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 5850: pa_projects_all p,

5846: /* NVL(l_end_date, expenditure_item_date) bug 8668217 */
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

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 5886: pa_projects_all p,

5882: NVL(l_end_date, expenditure_item_date)*/
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

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 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 6367: pa_projects_all p

6363: -- bug 8668217 NVL(l_end_date, expenditure_item_date)
6364: AND EXISTS
6365: (SELECT 1
6366: FROM pa_project_types_all pt,
6367: pa_projects_all p
6368: WHERE pt.project_type = p.project_type
6369: AND nvl(pt.org_id, -99) = nvl(p.org_id, -99)
6370: AND p.project_id = ei.project_id
6371: AND pt.project_type_class_code = 'CAPITAL'

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 6403: pa_projects_all p

6399: NVL(l_end_date, expenditure_item_date)*/
6400: AND EXISTS
6401: (SELECT 1
6402: FROM pa_project_types_all pt,
6403: pa_projects_all p
6404: WHERE pt.project_type = p.project_type
6405: AND nvl(pt.org_id, -99) = nvl(p.org_id, -99)
6406: AND p.project_id = ei.project_id
6407: AND pt.project_type_class_code = 'CAPITAL'

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*/