DBA Data[Home] [Help]

APPS.AHL_VWP_MR_CST_PR_PVT dependencies on AHL_MR_HEADERS_VL

Line 1303: -- AnRaj: Changed the query to remove the use of AHL_MR_HEADERS_VL

1299: task_name
1300: from AHL_SEARCH_VISIT_TASK_V
1301: Where TASK_ID=C_VISIT_TASK_ID;
1302: */
1303: -- AnRaj: Changed the query to remove the use of AHL_MR_HEADERS_VL
1304: -- Bug Number : 5208387
1305: Cursor c_task_info(c_visit_task_id in number)
1306: Is
1307: select mrb.title mr_name,

Line 1331: ahl_mr_headers_vl mrh,

1327: mrh.description mr_description,
1328: visit_task_number task_number,
1329: visit_task_name task_name
1330: from ahl_visit_tasks_vl tsk,
1331: ahl_mr_headers_vl mrh,
1332: AHL_VISITS_VL AVTS
1333: where MRH.MR_HEADER_ID = TSK.MR_ID
1334: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'
1335: AND AVTS.VISIT_ID = TSK.VISIT_ID