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