APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_PARAM_GROUPS_B

Line 5096: FROM BNE_PARAM_GROUPS_B

5092: AND ATTRIBUTE_APP_ID IS NOT NULL
5093: AND ATTRIBUTE_CODE IS NOT NULL
5094: UNION
5095: SELECT ATTRIBUTE_APP_ID, ATTRIBUTE_CODE
5096: FROM BNE_PARAM_GROUPS_B
5097: WHERE APPLICATION_ID = P_APPLICATION_ID
5098: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE
5099: AND ATTRIBUTE_APP_ID IS NOT NULL
5100: AND ATTRIBUTE_CODE IS NOT NULL

Line 5149: DELETE FROM BNE_PARAM_GROUPS_B

5145: DELETE FROM BNE_PARAM_LIST_ITEMS
5146: WHERE APPLICATION_ID = P_APPLICATION_ID
5147: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5148:
5149: DELETE FROM BNE_PARAM_GROUPS_B
5150: WHERE APPLICATION_ID = P_APPLICATION_ID
5151: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5152:
5153: DELETE FROM BNE_PARAM_GROUPS_TL

Line 5226: FROM BNE_PARAM_GROUPS_B

5222: AND NOT EXISTS (SELECT 1 FROM BNE_PARAM_LISTS_B
5223: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5224: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5225: AND NOT EXISTS (SELECT 1
5226: FROM BNE_PARAM_GROUPS_B
5227: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5228: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5229: AND NOT EXISTS (SELECT 1
5230: FROM BNE_PARAM_LIST_ITEMS