DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PA_TASKS_EXPEND_V

Line 1408: from pa_tasks_expend_v

1404:
1405: -- validation
1406: select distinct 'Y'
1407: into x_valid_flag
1408: from pa_tasks_expend_v
1409: where project_id = x_project_id
1410: and task_id = x_task_id;
1411:
1412: EXCEPTION

Line 1456: pa_tasks_expend_v tsk

1452: select distinct 'Y'
1453: into x_valid_flag
1454: from pa_projects_all prj,
1455: -- pa_tasks tsk Bug 16863607
1456: pa_tasks_expend_v tsk
1457: where
1458: prj.project_id = x_project_id
1459: and prj.project_id = tsk.project_id
1460: and tsk.task_id = x_task_id

Line 1634: pa_tasks_expend_v tsk

1630: select distinct 'Y'
1631: into x_valid_flag
1632: from pa_projects_all prj,
1633: -- pa_tasks tsk Bug 16863607
1634: pa_tasks_expend_v tsk
1635: where prj.project_id = x_project_id
1636: and prj.project_id = tsk.project_id
1637: and tsk.task_id = x_task_id
1638: and nvl(tsk.completion_date,sysdate) >= sysdate;