[Home] [Help]
2581: || Parameter: p_loan_id => disb_header_id
2582: ||
2583: || Return value: installment number
2584: ||
2585: || Source Tables: LNS_DISB_HEADERS
2586: ||
2587: || Target Tables: NA
2588: ||
2589: || MODIFICATION HISTORY
2606: ,payment_request_date
2607: ,(select max(disbursement_date) from lns_disb_lines
2608: where disb_header_id = c_disb_hdr_id) disbursement_date
2609: ,dh.phase
2610: FROM lns_disb_headers dh, lns_loan_headers_all lhdr
2611: WHERE dh.disb_header_id = c_disb_hdr_id
2612: AND lhdr.loan_id = dh.loan_id;
2613:
2614: begin