603: INTO l_contact_person_party_id
604: FROM hz_relationships rel,
605: hz_parties rel_party,
606: ar_lookups lkup,
607: hz_relationship_types rel_type
608: WHERE rel.party_id = P_Loan_Details_Rec.contact_rel_party_id
609: AND rel.object_id = P_Loan_Details_Rec.primary_borrower_party_id
610: AND rel.relationship_code = rel_type.forward_rel_code
611: AND rel_type.create_party_flag = 'Y'