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.

APPS.AHL_RA_NR_PROFILE_PVT dependencies on AHL_MR_HEADERS_V

Line 1764: FROM ahl_mr_headers_v mh

1760:
1761: CURSOR get_mr_title(c_mr_title VARCHAR2)
1762: IS
1763: SELECT DISTINCT mh.title
1764: FROM ahl_mr_headers_v mh
1765: WHERE SYSDATE BETWEEN mh.effective_from AND NVL(mh.effective_to,SYSDATE+1)
1766: AND mh.title NOT IN (SELECT mr_title FROM ahl_nr_profile_headers)
1767: AND mh.title = c_mr_title;
1768:

Line 1772: FROM ahl_mr_headers_v mh

1768:
1769: CURSOR get_valid_mr_title(c_mr_title VARCHAR2)
1770: IS
1771: SELECT DISTINCT mh.title
1772: FROM ahl_mr_headers_v mh
1773: WHERE SYSDATE BETWEEN mh.effective_from AND NVL(mh.effective_to,SYSDATE+1)
1774: AND mh.title = c_mr_title;
1775:
1776: CURSOR check_duplicate(c_mr_title VARCHAR2)

Line 1812: FROM ahl_mr_headers_v mh

1808:
1809: CURSOR get_delete_mr_title(c_mr_title VARCHAR2)
1810: IS
1811: SELECT max(mh.version_number)
1812: FROM ahl_mr_headers_v mh
1813: WHERE mh.title = c_mr_title;
1814:
1815: l_api_name CONSTANT VARCHAR2(30) := 'process_nr_profile';
1816: