DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PA_PROJECTS_ALL

Line 1454: from pa_projects_all prj,

1450:
1451: x_progress := '001';
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

Line 1589: from pa_projects_all prj

1585:
1586: x_progress := '001';
1587: select distinct 'Y'
1588: into x_valid_flag
1589: from pa_projects_all prj
1590: where prj.project_id = x_project_id
1591: and nvl(prj.completion_date,sysdate) >= sysdate;
1592:
1593: EXCEPTION

Line 1632: from pa_projects_all prj,

1628: END IF;
1629:
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