DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on PA_TASKS

Line 806: SELECT TASK_NUMBER FROM PA_TASKS WHERE TASK_ID = x_id;

802: WHERE Visit_Task_Id = x_id;
803:
804: -- To find project task nubmer for project's task
805: CURSOR c_proj_task (x_id IN NUMBER) IS
806: SELECT TASK_NUMBER FROM PA_TASKS WHERE TASK_ID = x_id;
807:
808: -- Added by Senthil for 11.5.10 enhancements.
809: CURSOR c_workorders (p_visit_id IN NUMBER, p_visit_task_id IN NUMBER)
810: IS