APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_DUPLICATE_PROFILES_B

Line 4690: FROM BNE_DUPLICATE_PROFILES_B

4686: VV_COUNT NUMBER;
4687: BEGIN
4688: VV_COUNT := 0;
4689: FOR I IN (SELECT APPLICATION_ID, DUP_PROFILE_CODE
4690: FROM BNE_DUPLICATE_PROFILES_B
4691: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4692: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4693: LOOP
4694: VV_COUNT := VV_COUNT + DELETE_DUP_PROFILE(I.APPLICATION_ID, I.DUP_PROFILE_CODE);

Line 4721: FROM BNE_DUPLICATE_PROFILES_B

4717: VV_COUNT NUMBER;
4718: BEGIN
4719: SELECT COUNT(*)
4720: INTO VV_COUNT
4721: FROM BNE_DUPLICATE_PROFILES_B
4722: WHERE APPLICATION_ID = P_APPLICATION_ID
4723: AND DUP_PROFILE_CODE = P_DUP_PROFILE_CODE;
4724:
4725: IF VV_COUNT = 0

Line 4730: DELETE FROM BNE_DUPLICATE_PROFILES_B

4726: THEN
4727: RETURN(0);
4728: END IF;
4729:
4730: DELETE FROM BNE_DUPLICATE_PROFILES_B
4731: WHERE APPLICATION_ID = P_APPLICATION_ID
4732: AND DUP_PROFILE_CODE = P_DUP_PROFILE_CODE;
4733:
4734: DELETE FROM BNE_DUPLICATE_PROFILES_TL