APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_MR_HEADERS_VL

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

4129: SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_B
4130: WHERE TITLE = p_mr_title AND VERSION_NUMBER = p_version_number;
4131:
4132: CURSOR l_get_effective_to_date(p_mr_header_id IN NUMBER) IS
4133: SELECT EFFECTIVE_TO, application_usg_code FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;
4134:
4135: CURSOR l_get_effective_from_date(p_mr_header_id IN NUMBER) IS
4136: SELECT EFFECTIVE_FROM FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;
4137:

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

4132: CURSOR l_get_effective_to_date(p_mr_header_id IN NUMBER) IS
4133: SELECT EFFECTIVE_TO, application_usg_code FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;
4134:
4135: CURSOR l_get_effective_from_date(p_mr_header_id IN NUMBER) IS
4136: SELECT EFFECTIVE_FROM FROM AHL_MR_HEADERS_VL WHERE MR_HEADER_ID = p_mr_header_id;
4137:
4138: CURSOR l_unit_effectivity_csr(p_header_id IN NUMBER,p_mr_effective_to_date IN DATE) IS SELECT
4139: EFF.UNIT_EFFECTIVITY_ID,
4140: EFF.CSI_ITEM_INSTANCE_ID,