APPS.PA_PROJ_TSK_UTILS dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 1806: FROM pa_project_asset_assignments

1802: cursor c1 is
1803: SELECT 1
1804: FROM sys.dual
1805: WHERE EXISTS (SELECT NULL
1806: FROM pa_project_asset_assignments
1807: WHERE project_id = x_project_id);
1808:
1809: /*Added for bug 6063643*/
1810: Cursor c2 is

Line 1814: and exists (select null from pa_project_asset_assignments

1810: Cursor c2 is
1811: select 1 from pa_tasks
1812: where task_id = x_task_id
1813: and wbs_level > 1
1814: and exists (select null from pa_project_asset_assignments
1815: where task_id = x_task_id
1816: and project_asset_id <> 0); /* Added for bug 6245714 */
1817:
1818: /*Commented for bug6063643

Line 1824: FROM pa_project_asset_assignments

1820: cursor c2 is
1821: SELECT 1
1822: FROM sys.dual
1823: where exists (SELECT NULL
1824: FROM pa_project_asset_assignments
1825: where project_id = x_proj_id
1826: AND TASK_ID IN
1827: (SELECT TASK_ID
1828: FROM PA_TASKS

Line 1838: FROM pa_project_asset_assignments

1834: /* cursor c2 is
1835: SELECT 1
1836: FROM sys.dual
1837: where exists (SELECT NULL
1838: FROM pa_project_asset_assignments
1839: where project_id = x_proj_id
1840: AND TASK_ID IN
1841: (SELECT TASK_ID
1842: FROM PA_TASKS

Line 1853: FROM pa_project_asset_assignments

1849: cursor c3 is
1850: SELECT 1
1851: FROM sys.dual
1852: where exists (SELECT NULL
1853: FROM pa_project_asset_assignments
1854: where project_id = x_proj_id
1855: AND TASK_ID = x_task_id);
1856: c3_rec c3%rowtype;
1857: begin