DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on AHL_VISIT_TASKS_B

Line 1846: from ahl_visit_tasks_b vtsk,

1842:
1843: --Added by mpothuku on 12-oct-2007 as until the ER 5758813 is implemented, the visit task dates will not be propagated to projects.
1844: CURSOR get_vst_task_comp_date_csr (c_osp_line_id IN NUMBER) IS
1845: SELECT vtsk.end_date_time
1846: from ahl_visit_tasks_b vtsk,
1847: ahl_osp_order_lines ospl,
1848: ahl_workorders wo
1849: where ospl.osp_order_line_id = c_osp_line_id
1850: and ospl.workorder_id = wo.workorder_id