DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on AHL_VISIT_TASKS_B

Line 1860: from ahl_visit_tasks_b vtsk,

1856:
1857: --Added by mpothuku on 12-oct-2007 as until the ER 5758813 is implemented, the visit task dates will not be propagated to projects.
1858: CURSOR get_vst_task_comp_date_csr (c_osp_line_id IN NUMBER) IS
1859: SELECT vtsk.end_date_time
1860: from ahl_visit_tasks_b vtsk,
1861: ahl_osp_order_lines ospl,
1862: ahl_workorders wo
1863: where ospl.osp_order_line_id = c_osp_line_id
1864: and ospl.workorder_id = wo.workorder_id