APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_DUPLICATE_PROFILES_B

Line 4599: FROM BNE_DUPLICATE_PROFILES_B

4595: VV_COUNT NUMBER;
4596: BEGIN
4597: VV_COUNT := 0;
4598: FOR I IN (SELECT APPLICATION_ID, DUP_PROFILE_CODE
4599: FROM BNE_DUPLICATE_PROFILES_B
4600: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4601: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4602: LOOP
4603: VV_COUNT := VV_COUNT + DELETE_DUP_PROFILE(I.APPLICATION_ID, I.DUP_PROFILE_CODE);

Line 4630: FROM BNE_DUPLICATE_PROFILES_B

4626: VV_COUNT NUMBER;
4627: BEGIN
4628: SELECT COUNT(*)
4629: INTO VV_COUNT
4630: FROM BNE_DUPLICATE_PROFILES_B
4631: WHERE APPLICATION_ID = P_APPLICATION_ID
4632: AND DUP_PROFILE_CODE = P_DUP_PROFILE_CODE;
4633:
4634: IF VV_COUNT = 0

Line 4639: DELETE FROM BNE_DUPLICATE_PROFILES_B

4635: THEN
4636: RETURN(0);
4637: END IF;
4638:
4639: DELETE FROM BNE_DUPLICATE_PROFILES_B
4640: WHERE APPLICATION_ID = P_APPLICATION_ID
4641: AND DUP_PROFILE_CODE = P_DUP_PROFILE_CODE;
4642:
4643: DELETE FROM BNE_DUPLICATE_PROFILES_TL