APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_PC_NODES_B

Line 5415: ahl_pc_nodes_b pcn

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
5419: AND TRUNC(NVL(mrh.effective_to, SYSDATE+1)) > TRUNC(SYSDATE);