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.

[Home] [Help]

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 237: pa_project_asset_assignments paa,

233: SELECT
234: paa.project_asset_id,
235: ppa.asset_category_id
236: FROM
237: pa_project_asset_assignments paa,
238: pa_project_assets ppa
239: WHERE
240: paa.project_id = x_project_id
241: AND ppa.project_asset_type(+) = DECODE(x_line_type,'C','AS-BUILT','RETIREMENT_ADJUSTMENT')

Line 1093: pa_project_asset_assignments paa

1089: paa.project_asset_id
1090: INTO
1091: x_project_asset_id
1092: FROM
1093: pa_project_asset_assignments paa
1094: WHERE
1095: paa.project_id = x_project_id
1096: AND paa.task_id = 0;
1097:

Line 1113: pa_project_asset_assignments paa

1109: paa.project_asset_id
1110: INTO
1111: x_project_asset_id
1112: FROM
1113: pa_project_asset_assignments paa
1114: WHERE
1115: paa.project_id = x_project_id
1116: AND paa.task_id =
1117: (SELECT

Line 1791: pa_project_asset_assignments paa

1787: )
1788: /* end of change for bug 6037734*/
1789: AND EXISTS ( SELECT '1' -- Check for task_id to have asset assignment
1790: FROM pa_project_assets ppa,
1791: pa_project_asset_assignments paa
1792: WHERE paa.project_id = p_project_id
1793: AND paa.task_id = pt.task_id
1794: AND ppa.capital_event_id IS NOT NULL
1795: AND ppa.capital_event_id = NVL(x_capital_event_id, pei.capital_event_id)

Line 1803: pa_project_asset_assignments paa

1799: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
1800: UNION ALL
1801: SELECT '1' -- Check for top_task_id to have asset assignment
1802: FROM pa_project_assets ppa,
1803: pa_project_asset_assignments paa
1804: WHERE paa.project_id = p_project_id
1805: AND paa.task_id = pt.top_task_id
1806: AND ppa.capital_event_id IS NOT NULL
1807: AND ppa.capital_event_id = NVL(x_capital_event_id, pei.capital_event_id)

Line 1815: pa_project_asset_assignments paa

1811: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
1812: UNION ALL
1813: SELECT '1' -- Check for project level Asset Assignments
1814: FROM pa_project_assets ppa,
1815: pa_project_asset_assignments paa
1816: WHERE paa.project_id = p_project_id
1817: AND nvl(paa.task_id,0) = 0
1818: AND ppa.capital_event_id IS NOT NULL
1819: AND ppa.capital_event_id = NVL(x_capital_event_id, pei.capital_event_id)

Line 1826: FROM pa_project_asset_assignments paa

1822: AND ppa.project_asset_id = paa.project_asset_id
1823: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
1824: UNION ALL
1825: SELECT '1' -- Check task_id is a common cost task
1826: FROM pa_project_asset_assignments paa
1827: WHERE paa.project_id = p_project_id
1828: AND task_id = pt.task_id
1829: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
1830: UNION ALL

Line 1832: FROM pa_project_asset_assignments paa

1828: AND task_id = pt.task_id
1829: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
1830: UNION ALL
1831: SELECT '1' -- Check top_task_id is a common cost task
1832: FROM pa_project_asset_assignments paa
1833: WHERE paa.project_id = p_project_id
1834: AND task_id = pt.top_task_id
1835: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
1836: UNION ALL

Line 1838: FROM pa_project_asset_assignments paa

1834: AND task_id = pt.top_task_id
1835: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
1836: UNION ALL
1837: SELECT '1' -- Check project is a common cost project
1838: FROM pa_project_asset_assignments paa
1839: WHERE paa.project_id = p_project_id
1840: AND nvl(task_id,0) = 0
1841: AND DECODE(paa.project_asset_id, 0,p_common_tasks_flag, 'N') = 'Y'
1842: )

Line 4061: FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA1,

4057: 'CAPITALIZE') = 'Y' and
4058: ppr.project_type = pt.project_type and
4059: pt.project_type_class_code = 'CAPITAL'
4060: AND NOT EXISTS (SELECT 'X' /* Modified the selprjs cursor for Bug 7128863 start */
4061: FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA1,
4062: PA_PROJECT_ASSET_ASSIGNMENTS PPAA2
4063: WHERE PPAA1.PROJECT_ID = PPR.PROJECT_ID
4064: AND PPAA1.PROJECT_ID = PPAA2.PROJECT_ID
4065: AND ((PPAA1.PROJECT_ID <> 0

Line 4062: PA_PROJECT_ASSET_ASSIGNMENTS PPAA2

4058: ppr.project_type = pt.project_type and
4059: pt.project_type_class_code = 'CAPITAL'
4060: AND NOT EXISTS (SELECT 'X' /* Modified the selprjs cursor for Bug 7128863 start */
4061: FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA1,
4062: PA_PROJECT_ASSET_ASSIGNMENTS PPAA2
4063: WHERE PPAA1.PROJECT_ID = PPR.PROJECT_ID
4064: AND PPAA1.PROJECT_ID = PPAA2.PROJECT_ID
4065: AND ((PPAA1.PROJECT_ID <> 0
4066: AND PPAA1.TASK_ID = 0)