eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_PC_HEADER_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 2688: from ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre, ahl_pc_nodes_b pcn

2684:
2685: CURSOR get_mr_for_pc (c_pc_header_id number)
2686: IS
2687: select mrh.mr_header_id, mrh.title, mrh.version_number
2688: from ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre, ahl_pc_nodes_b pcn
2689: where trunc(sysdate) < trunc(nvl(mrh.effective_to, sysdate+1)) and
2690: mrh.mr_header_id = mre.mr_header_id and
2691: mre.pc_node_id = pcn.pc_node_id and
2692: pcn.pc_header_id = c_pc_header_id;

Line 2706: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,

2702:
2703: -- AJPRASAN:: Bug #9596384 : Removed the comment to enable cursor definition
2704: CURSOR get_mr_for_pc_csr (p_pc_header_id NUMBER) IS
2705: SELECT mrh.mr_header_id, mre.mr_effectivity_id
2706: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,
2707: ahl_pc_nodes_b pcn
2708: WHERE mrh.mr_header_id = mre.mr_header_id
2709: AND mre.pc_node_id = pcn.pc_node_id
2710: AND pcn.pc_header_id = p_pc_header_id