DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 1291: FROM AHL_MR_HEADERS_APP_V

1287: IS
1288: CURSOR check_mr_status( c_mr_header_id NUMBER )
1289: IS
1290: SELECT mr_status_code
1291: FROM AHL_MR_HEADERS_APP_V
1292: WHERE mr_header_id = c_mr_header_id;
1293:
1294: l_mr_status_code varchar2(30);
1295: BEGIN

Line 1605: FROM ahl_mr_headers_app_v

1601:
1602: -- Cursor for getting mr_header_id out of mr_title and mr_version_number
1603: CURSOR header_id_csr_type(p_mr_title IN VARCHAR2, p_mr_version_number IN NUMBER) IS
1604: SELECT mr_header_id
1605: FROM ahl_mr_headers_app_v
1606: WHERE title = p_mr_title
1607: AND version_number = p_mr_version_number
1608: AND mr_status_code<>'TERMINATED'
1609: AND TRUNC(NVL(effective_to,SYSDATE+1))> TRUNC(SYSDATE);