DBA Data[Home] [Help]

APPS.PSP_ENC_PRE_PROCESS dependencies on PA_TASKS

Line 1232: FROM pa_tasks pt,

1228: NVL(ppa.start_date, TO_DATE('1800/01/01', 'YYYY/MM/DD')),
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

Line 1249: pa_tasks pt

1245: FROM gms_awards_all gaw, --6957888
1246: gms_summary_project_fundings gspf,
1247: gms_installments gi,
1248: gms_budget_versions gbv,
1249: pa_tasks pt
1250: WHERE gaw.award_id = p_award_id
1251: AND gbv.project_id = p_project_id
1252: AND pt.task_id = p_task_id
1253: AND gbv.budget_status_code = 'B'