APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_PC_NODES_B

Line 5841: ahl_pc_nodes_b pcn

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