DBA Data[Home] [Help]

APPS.PSP_ENC_PRE_PROCESS dependencies on PA_PROJECTS_ALL

Line 1233: pa_projects_all ppa

1229: NVL(ppa.completion_date, TO_DATE('4712/12/31', 'YYYY/MM/DD')),
1230: NVL(pt.start_date, TO_DATE('1800/01/01', 'YYYY/MM/DD')),
1231: NVL(pt.completion_date, TO_DATE('4712/12/31', 'YYYY/MM/DD'))
1232: FROM pa_tasks pt,
1233: pa_projects_all ppa
1234: WHERE pt.task_id = p_task_id
1235: AND ppa.project_id = pt.project_id
1236: AND ppa.project_id = p_project_id
1237: AND ppa.project_status_code <> 'CLOSED'