DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PA_TASKS

Line 1433: FROM pa_tasks_expend_v

1429: AND active_flag = 'Y';
1430:
1431: CURSOR check_task_csr IS
1432: SELECT task_id
1433: FROM pa_tasks_expend_v
1434: WHERE project_id = x_project_id and
1435: task_id = x_task_id;
1436: --End of Commenting for Bug 2096440
1437: ****************************************************************************************/

Line 1715: FROM pa_tasks

1711: --
1712: -- The following code added by PVELAMUR to fix bug 888089
1713: SELECT nvl(completion_date,l_payroll_end_date)
1714: INTO l_task_end_date
1715: FROM pa_tasks
1716: WHERE task_id = x_task_id;
1717: -- The above code added by PVELAMUR tp fix the bug 888089
1718: -- The following code added by PVELAMUR to fix bug 900768
1719: SELECT nvl(actual_termination_date,l_payroll_end_date)