APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_PERSON_INTEREST

Line 10662: FROM hz_person_interest hc

10658: l_end_date DATE;
10659:
10660: CURSOR person_interest_cur (p_person_interest_id IN NUMBER) IS
10661: SELECT 'Y'
10662: FROM hz_person_interest hc
10663: WHERE hc.person_interest_id = p_person_interest_id;
10664:
10665: BEGIN
10666:

Line 10693: FROM HZ_person_interest

10689: l_party_id,
10690: l_status,
10691: l_created_by_module,
10692: l_application_id
10693: FROM HZ_person_interest
10694: WHERE ROWID = p_rowid;
10695: END IF;
10696:
10697:

Line 10841: Bug 3282946. Some teams still insert into hz_person_interest

10837: FROM hz_parties p
10838: WHERE p.party_id = p_person_interest_rec.party_id; /*and
10839: party_type = 'PERSON';*/
10840: /*
10841: Bug 3282946. Some teams still insert into hz_person_interest
10842: for non 'PERSON' type parties.
10843: */
10844:
10845: EXCEPTION