DBA Data[Home] [Help]

APPS.PA_TASK_UTILS dependencies on PA_PROJECT_TYPES_ALL

Line 393: cursor p1 is select 1 from pa_project_types_all

389: /* Commented the cursor for bug#3512486
390: cursor p1 is select 1 from pa_project_types
391: where burden_sum_dest_task_id = x_task_id;*/
392: /* Added the below cursor for bug#3512486*/
393: cursor p1 is select 1 from pa_project_types_all
394: where burden_sum_dest_task_id = x_task_id
395: and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
396: FROM pa_projects_all
397: where project_id = (select project_id from pa_tasks where task_id=x_task_id));