APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_PERSON_INTEREST

Line 10665: FROM hz_person_interest hc

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

Line 10696: FROM HZ_person_interest

10692: l_party_id,
10693: l_status,
10694: l_created_by_module,
10695: l_application_id
10696: FROM HZ_person_interest
10697: WHERE ROWID = p_rowid;
10698: END IF;
10699:
10700:

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

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