APPS.PA_ALTERNATE_TASK_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 383: FROM pa_resource_assignments r

379: SELECT 'Y' validation_success /* If cursor returns a record, deletion is not allowed */
380: FROM DUAL
381: WHERE EXISTS (
382: SELECT 1
383: FROM pa_resource_assignments r
384: WHERE r.task_id = (select proj_element_id from pa_alternate_tasks where alt_task_id = c_Alt_Task_Id)
385: AND r.cbs_element_id = (select cbs_element_id from pa_alternate_tasks where alt_task_id = c_Alt_Task_Id)
386: );
387: