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 1717: FROM AHL_MR_HEADERS_B

1713: l_activity varchar2(30);
1714: cursor l_check_mr_type_csr (c_mr_header_id IN NUMBER)
1715: is
1716: SELECT TYPE_CODE
1717: FROM AHL_MR_HEADERS_B
1718: WHERE mr_header_id = c_mr_header_id;
1719: begin
1720: open l_check_mr_type_csr(p_mr_header_id);
1721: FETCH l_check_mr_type_csr INTO l_activity;

Line 1738: FROM AHL_MR_HEADERS_B

1734: l_status varchar2(30);
1735: cursor l_check_mr_status_csr (c_mr_header_id IN NUMBER)
1736: is
1737: SELECT mr_status_code
1738: FROM AHL_MR_HEADERS_B
1739: WHERE mr_header_id = c_mr_header_id
1740: AND trunc(nvl( effective_to, sysdate+1 ))>=trunc(sysdate);
1741: begin
1742: open l_check_mr_status_csr(p_mr_header_id);

Line 1766: FROM AHL_MR_HEADERS_B

1762:
1763: CURSOR check_mr_status( c_mr_header_id NUMBER )
1764: IS
1765: SELECT mr_status_code
1766: FROM AHL_MR_HEADERS_B
1767: WHERE mr_header_id = c_mr_header_id;
1768:
1769: BEGIN
1770: x_return_status := FND_API.G_RET_STS_SUCCESS;