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