APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 2148: AHL_MR_HEADERS_APP_V mr

2144: AND nvl(VT.status_code,'x') <> 'DELETED'
2145: and VT.visit_task_id not in (
2146: select VST.visit_task_id
2147: from ahl_visit_tasks_b VST,
2148: AHL_MR_HEADERS_APP_V mr
2149: where vst.mr_id = mr.mr_header_id
2150: and vst.visit_id =p_visit_id
2151: AND nvl(VST.status_code,'x') <> 'DELETED'
2152: and mr.billing_item_id is not null