APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_PERSON_INTEREST
Line 695: FROM HZ_PERSON_INTEREST
691:
692: CURSOR dupcheck IS
693: SELECT
694: PERSON_INTEREST_ID 695: FROM HZ_PERSON_INTEREST 696: WHERE party_id = p_to_fk_id
697: AND (status IS NULL OR status = 'A')
698: AND
699: INTEREST_TYPE_CODE ||
Line 704: FROM HZ_PERSON_INTEREST
700: SUB_INTEREST_TYPE_CODE =
701: (SELECT
702: INTEREST_TYPE_CODE ||
703: SUB_INTEREST_TYPE_CODE 704: FROM HZ_PERSON_INTEREST 705: WHERE person_interest_id = p_from_id);
706:
707: l_record_id NUMBER;
708: BEGIN