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_FMP_COMMON_PVT dependencies on AHL_MR_HEADERS_B

Line 1776: FROM AHL_MR_HEADERS_B

1772: l_activity varchar2(30);
1773: cursor l_check_mr_type_csr (c_mr_header_id IN NUMBER)
1774: is
1775: SELECT TYPE_CODE
1776: FROM AHL_MR_HEADERS_B
1777: WHERE mr_header_id = c_mr_header_id;
1778: begin
1779: open l_check_mr_type_csr(p_mr_header_id);
1780: FETCH l_check_mr_type_csr INTO l_activity;

Line 1797: FROM AHL_MR_HEADERS_B

1793: l_status varchar2(30);
1794: cursor l_check_mr_status_csr (c_mr_header_id IN NUMBER)
1795: is
1796: SELECT mr_status_code
1797: FROM AHL_MR_HEADERS_B
1798: WHERE mr_header_id = c_mr_header_id
1799: AND trunc(nvl( effective_to, sysdate+1 ))>=trunc(sysdate);
1800: begin
1801: open l_check_mr_status_csr(p_mr_header_id);

Line 1825: FROM AHL_MR_HEADERS_B

1821:
1822: CURSOR check_mr_status( c_mr_header_id NUMBER )
1823: IS
1824: SELECT mr_status_code
1825: FROM AHL_MR_HEADERS_B
1826: WHERE mr_header_id = c_mr_header_id;
1827:
1828: BEGIN
1829: x_return_status := FND_API.G_RET_STS_SUCCESS;