APPS.LNS_LOAN_PUB dependencies on HZ_RELATIONSHIPS

Line 421: l_contact_person_party_id hz_relationships.SUBJECT_ID%TYPE;

417: l_borrower_valid BOOLEAN;
418: l_cust_acct_valid BOOLEAN;
419: l_generate_loan_number VARCHAR2(1);
420: l_total_installments lns_rate_schedules.end_installment_number%TYPE;
421: l_contact_person_party_id hz_relationships.SUBJECT_ID%TYPE;
422: l_loan_id number(15);
423: l_loan_number VARCHAR2(60);
424: l_header_insert_success VARCHAR2(1);
425: l_participant_id NUMBER(15);

Line 604: FROM hz_relationships rel,

600: AND P_Loan_Details_Rec.contact_rel_party_id IS NOT NULL THEN
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