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_FAXFACE dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 100: from pa_project_asset_assignments

96: dummy VARCHAR2(10);
97: group_level_task_id NUMBER;
98: cursor c_asset_on_task is
99: select task_id
100: from pa_project_asset_assignments
101: where project_id = x_project_id
102: and task_id = x_task_id ;
103: cursor c_asset_on_top_task is
104: select task_id

Line 105: from pa_project_asset_assignments

101: where project_id = x_project_id
102: and task_id = x_task_id ;
103: cursor c_asset_on_top_task is
104: select task_id
105: from pa_project_asset_assignments
106: where project_id = x_project_id
107: and task_id = x_top_task_id ;
108: cursor c_asset_on_project is
109: select task_id

Line 110: from pa_project_asset_assignments

106: where project_id = x_project_id
107: and task_id = x_top_task_id ;
108: cursor c_asset_on_project is
109: select task_id
110: from pa_project_asset_assignments
111: where project_id = x_project_id ;
112: BEGIN
113: OPEN c_asset_on_task ;
114: FETCH c_asset_on_task into group_level_task_id ;

Line 264: pa_project_asset_assignments paa,

260: SELECT
261: paa.project_asset_id,
262: ppa.asset_category_id
263: FROM
264: pa_project_asset_assignments paa,
265: pa_project_assets ppa
266: WHERE
267: paa.project_id = x_project_id
268: AND ppa.project_asset_type(+) = DECODE(x_line_type,'C','AS-BUILT','RETIREMENT_ADJUSTMENT')

Line 1151: pa_project_asset_assignments paa

1147: paa.project_asset_id
1148: INTO
1149: x_project_asset_id
1150: FROM
1151: pa_project_asset_assignments paa
1152: WHERE
1153: paa.project_id = x_project_id
1154: AND paa.task_id = 0;
1155:

Line 1171: pa_project_asset_assignments paa

1167: paa.project_asset_id
1168: INTO
1169: x_project_asset_id
1170: FROM
1171: pa_project_asset_assignments paa
1172: WHERE
1173: paa.project_id = x_project_id
1174: AND paa.task_id =
1175: (SELECT

Line 2027: pa_project_asset_assignments paa

2023: )
2024: /* end of change for bug 6037734*/
2025: AND EXISTS ( SELECT '1' -- Check for task_id to have asset assignment
2026: FROM pa_project_assets ppa,
2027: pa_project_asset_assignments paa
2028: WHERE paa.project_id = p_project_id
2029: AND paa.task_id = pt.task_id
2030: AND ppa.capital_event_id IS NOT NULL
2031: AND ppa.capital_event_id = NVL(x_capital_event_id, pei.capital_event_id)

Line 2039: pa_project_asset_assignments paa

2035: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
2036: UNION ALL
2037: SELECT '1' -- Check for top_task_id to have asset assignment
2038: FROM pa_project_assets ppa,
2039: pa_project_asset_assignments paa
2040: WHERE paa.project_id = p_project_id
2041: AND paa.task_id = pt.top_task_id
2042: AND ppa.capital_event_id IS NOT NULL
2043: AND ppa.capital_event_id = NVL(x_capital_event_id, pei.capital_event_id)

Line 2051: pa_project_asset_assignments paa

2047: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
2048: UNION ALL
2049: SELECT '1' -- Check for project level Asset Assignments
2050: FROM pa_project_assets ppa,
2051: pa_project_asset_assignments paa
2052: WHERE paa.project_id = p_project_id
2053: AND nvl(paa.task_id,0) = 0
2054: AND ppa.capital_event_id IS NOT NULL
2055: AND ppa.capital_event_id = NVL(x_capital_event_id, pei.capital_event_id)

Line 2062: FROM pa_project_asset_assignments paa

2058: AND ppa.project_asset_id = paa.project_asset_id
2059: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
2060: UNION ALL
2061: SELECT '1' -- Check task_id is a common cost task
2062: FROM pa_project_asset_assignments paa
2063: WHERE paa.project_id = p_project_id
2064: AND task_id = pt.task_id
2065: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
2066: UNION ALL

Line 2068: FROM pa_project_asset_assignments paa

2064: AND task_id = pt.task_id
2065: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
2066: UNION ALL
2067: SELECT '1' -- Check top_task_id is a common cost task
2068: FROM pa_project_asset_assignments paa
2069: WHERE paa.project_id = p_project_id
2070: AND task_id = pt.top_task_id
2071: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
2072: UNION ALL

Line 2074: FROM pa_project_asset_assignments paa

2070: AND task_id = pt.top_task_id
2071: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
2072: UNION ALL
2073: SELECT '1' -- Check project is a common cost project
2074: FROM pa_project_asset_assignments paa
2075: WHERE paa.project_id = p_project_id
2076: AND nvl(task_id,0) = 0
2077: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
2078: )

Line 4445: FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA1,

4441: 'CAPITALIZE') = 'Y' and
4442: ppr.project_type = pt.project_type and
4443: pt.project_type_class_code = 'CAPITAL'
4444: AND NOT EXISTS (SELECT 'X' /* Modified the selprjs cursor for Bug 7128863 start */
4445: FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA1,
4446: PA_PROJECT_ASSET_ASSIGNMENTS PPAA2
4447: WHERE PPAA1.PROJECT_ID = PPR.PROJECT_ID
4448: AND PPAA1.PROJECT_ID = PPAA2.PROJECT_ID
4449: AND ((PPAA1.PROJECT_ID <> 0

Line 4446: PA_PROJECT_ASSET_ASSIGNMENTS PPAA2

4442: ppr.project_type = pt.project_type and
4443: pt.project_type_class_code = 'CAPITAL'
4444: AND NOT EXISTS (SELECT 'X' /* Modified the selprjs cursor for Bug 7128863 start */
4445: FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA1,
4446: PA_PROJECT_ASSET_ASSIGNMENTS PPAA2
4447: WHERE PPAA1.PROJECT_ID = PPR.PROJECT_ID
4448: AND PPAA1.PROJECT_ID = PPAA2.PROJECT_ID
4449: AND ((PPAA1.PROJECT_ID <> 0
4450: AND PPAA1.TASK_ID = 0)