APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 5414: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,

5410: AND status = 'COMPLETE';
5411:
5412: CURSOR get_mr_for_pc_csr (c_pc_header_id NUMBER) IS
5413: SELECT mrh.mr_header_id, mre.mr_effectivity_id
5414: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,
5415: ahl_pc_nodes_b pcn
5416: WHERE mrh.mr_header_id = mre.mr_header_id
5417: AND mre.pc_node_id = pcn.pc_node_id
5418: AND pcn.pc_header_id = c_pc_header_id