APPS.PO_COPYDOC_SUB dependencies on PA_TASKS

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 1455: -- pa_tasks tsk Bug 16863607

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
1459: and prj.project_id = tsk.project_id

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 1633: -- pa_tasks tsk Bug 16863607

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
1637: 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;

Line 1927: from wip_osp_jobs_val_v job, pa_tasks task

1923: and we.entity_type = 6
1924: and wdj.status_type in (3,4,6);
1925: else
1926: select count(*) into x_count
1927: from wip_osp_jobs_val_v job, pa_tasks task
1928: where job.wip_entity_id = x_wip_entity_id
1929: and job.organization_id = x_destination_organization_id
1930: and task.task_id (+) = job.task_id;
1931: end if;