DBA Data[Home] [Help]

APPS.OKE_STANDARD_NOTES_PUB dependencies on OKE_K_STANDARD_NOTES_TL

Line 723: SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL

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;
725:
726: If(l_check_num1<1)OR(l_check_num2<1) then
727: raise OKE_API.G_EXCEPTION_ERROR;