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 2011: PA_PROJECTS_ALL PROJ,

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

Line 2578: PA_PROJECTS_ALL PROJ,

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

Line 3224: pa_projects_all p,

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

Line 3239: pa_projects_all p,

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

Line 3254: pa_projects_all p,

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

Line 4554: pa_projects_all pp

4550:
4551: /*****************************************************************
4552: AND exists (select 1
4553: from pa_project_types_all pt,
4554: pa_projects_all pp
4555: where pp.project_id =ITEM.project_id
4556: AND pp.project_type =pt.project_type
4557: AND pt.burden_amt_display_method in ('D','d')
4558: AND nvl(pt.org_id,-99) =nvl(pp.org_id,-99) )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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