DBA Data[Home] [Help]

APPS.LNS_FIN_UTILS dependencies on LNS_DISB_LINES

Line 2607: ,(select max(disbursement_date) from lns_disb_lines

2603: cursor c_disb_details (c_disb_hdr_id NUMBER)
2604: is
2605: SELECT dh.loan_id
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