DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_QUERIES_B

Line 5270: FROM BNE_QUERIES_B

5266: VV_COUNT NUMBER;
5267: BEGIN
5268: SELECT COUNT(*)
5269: INTO VV_COUNT
5270: FROM BNE_QUERIES_B
5271: WHERE APPLICATION_ID = P_APPLICATION_ID
5272: AND QUERY_CODE = P_QUERY_CODE;
5273:
5274: IF VV_COUNT = 0

Line 5279: DELETE FROM BNE_QUERIES_B

5275: THEN
5276: RETURN(0);
5277: END IF;
5278:
5279: DELETE FROM BNE_QUERIES_B
5280: WHERE APPLICATION_ID = P_APPLICATION_ID
5281: AND QUERY_CODE = P_QUERY_CODE;
5282:
5283: DELETE FROM BNE_QUERIES_TL