APPS.AHL_VWP_RULES_PVT dependencies on AHL_MR_HEADERS_B

Line 2255: FROM ahl_mr_headers_b

2251: AND visit_id = p_visit_id;
2252:
2253: CURSOR c_mr_title(p_mr_id IN NUMBER) IS
2254: SELECT TITLE
2255: FROM ahl_mr_headers_b
2256: WHERE mr_header_id = p_mr_id;
2257:
2258: CURSOR c_task_det(p_visit_task_id NUMBER) IS
2259: SELECT visit_task_id,

Line 3836: FROM AHL_VISIT_TASKS_VL ATSK, AHL_MR_HEADERS_B AMRH

3832:
3833: --cursor to fetch warranty template associated at MR
3834: CURSOR c_mr_template (c_task_id IN NUMBER) IS
3835: SELECT AMRH.WARRANTY_TEMPLATE_ID
3836: FROM AHL_VISIT_TASKS_VL ATSK, AHL_MR_HEADERS_B AMRH
3837: WHERE ATSK.MR_ID = AMRH.MR_HEADER_ID(+)
3838: AND ATSK.VISIT_TASK_ID = c_task_id;
3839:
3840: --cursor to fetch warranty template associated at route