APPS.LNS_LOAN_PUB dependencies on HZ_PARTIES

Line 534: FROM hz_parties hzp

530: ELSE
531: BEGIN
532: SELECT 'Y'
533: INTO l_dummy
534: FROM hz_parties hzp
535: WHERE hzp.party_id = P_Loan_Details_Rec.primary_borrower_party_id
536: AND hzp.party_type = l_product_rec.party_type
537: AND hzp.status = 'A';
538: l_borrower_valid := TRUE;

Line 605: hz_parties rel_party,

601: BEGIN
602: SELECT rel.subject_id
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