DBA Data[Home] [Help]

APPS.PA_TASK_UTILS dependencies on PA_PROJECT_TYPES_ALL

Line 579: cursor p1 is select 1 from pa_project_types_all

575: /* Commented the cursor for bug#3512486
576: cursor p1 is select 1 from pa_project_types
577: where burden_sum_dest_task_id = x_task_id;*/
578: /* Added the below cursor for bug#3512486*/
579: cursor p1 is select 1 from pa_project_types_all
580: where burden_sum_dest_task_id = x_task_id
581: and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
582: FROM pa_projects_all
583: where project_id = (select project_id from pa_tasks where task_id=x_task_id));