1662: WHERE person_id = p_person_id;
1663:
1664: CURSOR c_party_existence(c_party_id IN NUMBER) IS
1665: SELECT hz.party_id 1666: FROM hz_parties hz 1667: WHERE party_type not in ('ORGANIZATION', 'GROUP')
1668: AND hz.party_id = c_party_id
1669: AND not exists ( select person_id
1670: from per_all_people_f per