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_B

Line 49: FROM ahl_mr_headers_b mrh, ahl_nr_profile_headers nph

45:
46: CURSOR get_profile_ident_seqs(c_mr_header_id NUMBER)
47: IS
48: SELECT nph.nr_profile_header_id, nph.ident_seq_third , nph.ident_seq_fourth
49: FROM ahl_mr_headers_b mrh, ahl_nr_profile_headers nph
50: WHERE mrh.title = nph.mr_title
51: AND mrh.mr_header_id = c_mr_header_id
52: AND nph.status_code = 'COMPLETE';
53:

Line 386: FROM ahl_mr_headers_b mrh, ahl_nr_profile_headers nph

382:
383: CURSOR get_profile_ident_seqs(c_mr_header_id NUMBER)
384: IS
385: SELECT nph.nr_profile_header_id, nph.ident_seq_third , nph.ident_seq_fourth
386: FROM ahl_mr_headers_b mrh, ahl_nr_profile_headers nph
387: WHERE mrh.title = nph.mr_title
388: AND mrh.mr_header_id = c_mr_header_id
389: AND nph.status_code = 'COMPLETE';
390: