APPS.LNS_REP_UTILS dependencies on LNS_DISB_LINES

Line 668: ' from lns_disb_lines line, ' ||

664: ',le.NAME LEGAL_ENTITY_NAME ' ||
665: ',lh.product_id ' ||
666: ',product.loan_product_name loan_product ' ||
667: ',nvl((select sum(line.line_amount) ' ||
668: ' from lns_disb_lines line, ' ||
669: ' lns_disb_headers head ' ||
670: ' where head.loan_id = lh.LOAN_ID and ' ||
671: ' head.disb_header_id = line.disb_header_id and ' ||
672: ' line.status = ''FULLY_FUNDED''), 0) disbursed_amount ' ||

Line 829: ' (select to_char(max(DISBURSEMENT_DATE),''YYYY-MM-DD'') from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID) DISBURSEMENT_DATE ' ||

825: ' head.HEADER_PERCENT, ' ||
826: ' head.HEADER_AMOUNT, ' ||
827: ' fund_status.meaning status, ' ||
828: ' fund_act.meaning activity_name, ' ||
829: ' (select to_char(max(DISBURSEMENT_DATE),''YYYY-MM-DD'') from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID) DISBURSEMENT_DATE ' ||
830: ' from lns_disb_headers head, ' ||
831: ' lns_lookups fund_status, ' ||
832: ' lns_lookups fund_act ' ||
833: ' where head.loan_id = lh.loan_id and ' ||

Line 1510: from lns_disb_lines ldl

1506: )
1507: )
1508: )
1509: )
1510: from lns_disb_lines ldl
1511: ,hz_parties party
1512: ,IBY_PAYMENT_METHODS_TL ibypm
1513: where ldl.disb_header_id = ldih.disb_header_id
1514: and party.party_id = ldl.payee_party_id and