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 1558: /* Bug#3461661 : removed join with pa_tasks

1554: from sys.dual
1555: where not exists (
1556: select null
1557: from pa_expenditure_items_all pai
1558: /* Bug#3461661 : removed join with pa_tasks
1559: * ,pa_tasks t
1560: */
1561: ,pa_cost_distribution_lines_all pcd
1562: where

Line 1559: * ,pa_tasks t

1555: where not exists (
1556: select null
1557: from pa_expenditure_items_all pai
1558: /* Bug#3461661 : removed join with pa_tasks
1559: * ,pa_tasks t
1560: */
1561: ,pa_cost_distribution_lines_all pcd
1562: where
1563: /* Bug#3461661 : removed join condition

Line 1850: FROM PA_TASKS PT

1846: OR PP.nl_tp_schedule_id=p_tp_schedule_id
1847: )
1848: OR EXISTS
1849: (SELECT 'Y'
1850: FROM PA_TASKS PT
1851: WHERE PT.labor_tp_schedule_id=p_tp_schedule_id
1852: OR PT.nl_tp_schedule_id=p_tp_schedule_id
1853: );
1854: v_ret_code varchar2(1) ;