APPS.AHL_PC_HEADER_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 2532: from ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre, ahl_pc_nodes_b pcn

2528:
2529: CURSOR get_mr_for_pc (c_pc_header_id number)
2530: IS
2531: select mrh.mr_header_id, mrh.title, mrh.version_number
2532: from ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre, ahl_pc_nodes_b pcn
2533: where trunc(sysdate) < trunc(nvl(mrh.effective_to, sysdate+1)) and
2534: mrh.mr_header_id = mre.mr_header_id and
2535: mre.pc_node_id = pcn.pc_node_id and
2536: pcn.pc_header_id = c_pc_header_id;