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

Line 2013: PA_PROJECT_TYPES_ALL TYPE

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

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 2111: l_burden_cost_flag pa_project_types.BURDEN_COST_FLAG%TYPE;

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;
2112: l_total_burden_flag pa_project_types.TOTAL_BURDEN_FLAG%TYPE;
2113: l_cost_burden_distributed_flag pa_Expenditure_Items.cost_burden_distributed_flag%TYPE;
2114: -- bug 8248419 end
2115:

Line 2112: l_total_burden_flag pa_project_types.TOTAL_BURDEN_FLAG%TYPE;

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;
2112: l_total_burden_flag pa_project_types.TOTAL_BURDEN_FLAG%TYPE;
2113: l_cost_burden_distributed_flag pa_Expenditure_Items.cost_burden_distributed_flag%TYPE;
2114: -- bug 8248419 end
2115:
2116: BEGIN

Line 2609: PA_PROJECT_TYPES_ALL TYPE

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

Line 4583: from pa_project_types_all pt,

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

Line 5050: FROM pa_project_types_all pt,

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

Line 5083: FROM pa_project_types_all pt,

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

Line 5114: FROM pa_project_types_all pt,

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

Line 5529: FROM pa_project_types_all pt,

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

Line 5849: FROM pa_project_types_all pt,

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

Line 5885: FROM pa_project_types_all pt,

5881: l_start_date AND bug 8668217
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)

Line 6366: FROM pa_project_types_all pt,

6362: l_start_date AND l_end_date
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

Line 6402: FROM pa_project_types_all pt,

6398: l_start_date AND
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