APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_PARAM_GROUPS_B

Line 5187: FROM BNE_PARAM_GROUPS_B

5183: AND ATTRIBUTE_APP_ID IS NOT NULL
5184: AND ATTRIBUTE_CODE IS NOT NULL
5185: UNION
5186: SELECT ATTRIBUTE_APP_ID, ATTRIBUTE_CODE
5187: FROM BNE_PARAM_GROUPS_B
5188: WHERE APPLICATION_ID = P_APPLICATION_ID
5189: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE
5190: AND ATTRIBUTE_APP_ID IS NOT NULL
5191: AND ATTRIBUTE_CODE IS NOT NULL

Line 5240: DELETE FROM BNE_PARAM_GROUPS_B

5236: DELETE FROM BNE_PARAM_LIST_ITEMS
5237: WHERE APPLICATION_ID = P_APPLICATION_ID
5238: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5239:
5240: DELETE FROM BNE_PARAM_GROUPS_B
5241: WHERE APPLICATION_ID = P_APPLICATION_ID
5242: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5243:
5244: DELETE FROM BNE_PARAM_GROUPS_TL

Line 5317: FROM BNE_PARAM_GROUPS_B

5313: AND NOT EXISTS (SELECT 1 FROM BNE_PARAM_LISTS_B
5314: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5315: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5316: AND NOT EXISTS (SELECT 1
5317: FROM BNE_PARAM_GROUPS_B
5318: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5319: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5320: AND NOT EXISTS (SELECT 1
5321: FROM BNE_PARAM_LIST_ITEMS