APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_MR_HEADERS_VL

Line 3819: SELECT EFFECTIVE_TO, application_usg_code FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;

3815: SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_B
3816: WHERE TITLE = p_mr_title AND VERSION_NUMBER = p_version_number;
3817:
3818: CURSOR l_get_effective_to_date(p_mr_header_id IN NUMBER) IS
3819: SELECT EFFECTIVE_TO, application_usg_code FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;
3820:
3821: CURSOR l_get_effective_from_date(p_mr_header_id IN NUMBER) IS
3822: SELECT EFFECTIVE_FROM FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;
3823:

Line 3822: SELECT EFFECTIVE_FROM FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;

3818: CURSOR l_get_effective_to_date(p_mr_header_id IN NUMBER) IS
3819: SELECT EFFECTIVE_TO, application_usg_code FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;
3820:
3821: CURSOR l_get_effective_from_date(p_mr_header_id IN NUMBER) IS
3822: SELECT EFFECTIVE_FROM FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;
3823:
3824: CURSOR l_unit_effectivity_csr(p_header_id IN NUMBER) IS SELECT
3825: EFF.UNIT_EFFECTIVITY_ID,
3826: EFF.CSI_ITEM_INSTANCE_ID,