APPS.PA_PROJECT_UTILS dependencies on PA_TASKS

Line 1086: from pa_tasks

1082: end if;
1083:
1084: -- Check task
1085: for task_rec in (select task_id
1086: from pa_tasks
1087: where project_id = x_project_id
1088: and task_id = top_task_id) loop
1089:
1090: pa_task_utils.check_delete_task_ok(

Line 1546: /* Bug#3461661 : removed join with pa_tasks

1542: from sys.dual
1543: where not exists (
1544: select null
1545: from pa_expenditure_items_all pai
1546: /* Bug#3461661 : removed join with pa_tasks
1547: * ,pa_tasks t
1548: */
1549: ,pa_cost_distribution_lines_all pcd
1550: where

Line 1547: * ,pa_tasks t

1543: where not exists (
1544: select null
1545: from pa_expenditure_items_all pai
1546: /* Bug#3461661 : removed join with pa_tasks
1547: * ,pa_tasks t
1548: */
1549: ,pa_cost_distribution_lines_all pcd
1550: where
1551: /* Bug#3461661 : removed join condition

Line 1838: FROM PA_TASKS PT

1834: OR PP.nl_tp_schedule_id=p_tp_schedule_id
1835: )
1836: OR EXISTS
1837: (SELECT 'Y'
1838: FROM PA_TASKS PT
1839: WHERE PT.labor_tp_schedule_id=p_tp_schedule_id
1840: OR PT.nl_tp_schedule_id=p_tp_schedule_id
1841: );
1842: v_ret_code varchar2(1) ;