DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PA_TASKS

Line 1436: FROM pa_tasks_expend_v

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

Line 1718: FROM pa_tasks

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