APPS.OKE_STANDARD_NOTES_PUB dependencies on OKE_K_STANDARD_NOTES_B
Line 720: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B
716: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
717: raise OKE_API.G_EXCEPTION_ERROR;
718: End If;
719: 720: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B 721: WHERE STANDARD_NOTES_ID = p_note_id;
722:
723: SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL
724: WHERE STANDARD_NOTES_ID = p_note_id;