APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 1311: FROM AHL_MR_HEADERS_APP_V

1307: IS
1308: CURSOR check_mr_status( c_mr_header_id NUMBER )
1309: IS
1310: SELECT mr_status_code
1311: FROM AHL_MR_HEADERS_APP_V
1312: WHERE mr_header_id = c_mr_header_id;
1313:
1314: l_mr_status_code varchar2(30);
1315: BEGIN

Line 1664: FROM ahl_mr_headers_app_v

1660:
1661: -- Cursor for getting mr_header_id out of mr_title and mr_version_number
1662: CURSOR header_id_csr_type(p_mr_title IN VARCHAR2, p_mr_version_number IN NUMBER) IS
1663: SELECT mr_header_id
1664: FROM ahl_mr_headers_app_v
1665: WHERE title = p_mr_title
1666: AND version_number = p_mr_version_number
1667: AND mr_status_code<>'TERMINATED'
1668: AND TRUNC(NVL(effective_to,SYSDATE+1))> TRUNC(SYSDATE);