APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 5840: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,

5836: AND status = 'COMPLETE';
5837:
5838: CURSOR get_mr_for_pc_csr (c_pc_header_id NUMBER) IS
5839: SELECT mrh.mr_header_id, mre.mr_effectivity_id
5840: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,
5841: ahl_pc_nodes_b pcn
5842: WHERE mrh.mr_header_id = mre.mr_header_id
5843: AND mre.pc_node_id = pcn.pc_node_id
5844: AND pcn.pc_header_id = c_pc_header_id