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_PROJECT_TYPES_ALL

Line 2012: PA_PROJECT_TYPES_ALL TYPE

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
2016: OR

Line 2579: PA_PROJECT_TYPES_ALL TYPE

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
2583: AND PROJ.Project_Type = TYPE.Project_Type

Line 4553: from pa_project_types_all pt,

4549: )
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')

Line 5020: FROM pa_project_types_all pt,

5016: FROM pa_expenditure_items_all ei
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 */

Line 5053: FROM pa_project_types_all pt,

5049: l_start_date AND
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 */

Line 5084: FROM pa_project_types_all pt,

5080: l_start_date AND
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 */

Line 5499: FROM pa_project_types_all pt,

5495: program_update_date = SYSDATE
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)

Line 5816: FROM pa_project_types_all pt,

5812: l_start_date AND
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)

Line 6172: FROM pa_project_types_all pt,

6168: l_start_date AND
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)