APPS.AHL_PC_HEADER_PVT dependencies on AHL_MR_EFFECTIVITIES

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;

Line 2548: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,

2544: -- SATHAPLI::Bug# 6504069, 26-Mar-2008
2545: -- cursor to get all the applicable MRs for a given PC header id
2546: CURSOR get_mr_for_pc_csr (p_pc_header_id NUMBER) IS
2547: SELECT mrh.mr_header_id, mre.mr_effectivity_id
2548: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,
2549: ahl_pc_nodes_b pcn
2550: WHERE mrh.mr_header_id = mre.mr_header_id
2551: AND mre.pc_node_id = pcn.pc_node_id
2552: AND pcn.pc_header_id = p_pc_header_id