APPS.PO_COPYDOC_SUB dependencies on PA_TASKS

Line 1360: from pa_tasks_expend_v

1356:
1357: -- validation
1358: select distinct 'Y'
1359: into x_valid_flag
1360: from pa_tasks_expend_v
1361: where project_id = x_project_id
1362: and task_id = x_task_id;
1363:
1364: EXCEPTION

Line 1407: pa_tasks tsk

1403: x_progress := '001';
1404: select distinct 'Y'
1405: into x_valid_flag
1406: from pa_projects_all prj,
1407: pa_tasks tsk
1408: where
1409: prj.project_id = x_project_id
1410: and prj.project_id = tsk.project_id
1411: and tsk.task_id = x_task_id

Line 1782: from wip_osp_jobs_val_v job, pa_tasks task

1778: and we.entity_type = 6
1779: and wdj.status_type in (3,4,6);
1780: else
1781: select count(*) into x_count
1782: from wip_osp_jobs_val_v job, pa_tasks task
1783: where job.wip_entity_id = x_wip_entity_id
1784: and job.organization_id = x_destination_organization_id
1785: and task.task_id (+) = job.task_id;
1786: end if;