DBA Data[Home] [Help]

APPS.PA_PROJ_TSK_UTILS dependencies on PA_PROJECTS_ALL

Line 1329: FROM pa_projects_all -- Modified pa_projects to pa_projects_all for bug#3512486

1325: cursor c1 is
1326: SELECT 1
1327: FROM sys.dual
1328: where exists (SELECT NULL
1329: FROM pa_projects_all -- Modified pa_projects to pa_projects_all for bug#3512486
1330: where project_id = (select project_id from pa_tasks where task_id=X_TASK_ID)
1331: and CC_TAX_TASK_ID IN
1332: (SELECT TASK_ID
1333: FROM PA_TASKS

Line 1344: FROM pa_projects_all

1340: cursor c2 is
1341: SELECT 1
1342: FROM sys.dual
1343: where exists (SELECT NULL
1344: FROM pa_projects_all
1345: where project_id = x_proj_id
1346: and CC_TAX_TASK_ID = x_task_id);
1347: c2_rec c2%rowtype;
1348: