APPS.LNS_DISTRIBUTIONS_PUB dependencies on HZ_PARTIES

Line 7945: select party_name from hz_parties party where party_id = P_BORROWER_ID;

7941: | Cursor Declarations |
7942: +-----------------------------------------------------------------------*/
7943: /* query for borrower name */
7944: CURSOR borrower_cur(P_BORROWER_ID number) IS
7945: select party_name from hz_parties party where party_id = P_BORROWER_ID;
7946:
7947: /* query for loan number */
7948: CURSOR loan_cur(P_LOAN_ID number) IS
7949: select loan_number from lns_loan_headers where loan_id = P_LOAN_ID;

Line 8168: hz_parties party

8164: ,loan.last_payment_number
8165: ,decode(loan.current_phase, 'OPEN', to_char(loan.open_loan_start_date,'YYYY-MM-DD'), to_char(loan.loan_start_date,'YYYY-MM-DD'))
8166: FROM
8167: lns_loan_headers loan,
8168: hz_parties party
8169: WHERE party.party_id = loan.PRIMARY_BORROWER_ID
8170: AND loan.loan_id = C_LOAN_ID;
8171:
8172: