APPS.LNS_REP_UTILS dependencies on LNS_DISB_LINES

Line 605: ' from lns_disb_lines line, ' ||

601: ',le.NAME LEGAL_ENTITY_NAME ' ||
602: ',lh.product_id ' ||
603: ',product.loan_product_name loan_product ' ||
604: ',nvl((select sum(line.line_amount) ' ||
605: ' from lns_disb_lines line, ' ||
606: ' lns_disb_headers head ' ||
607: ' where head.loan_id = lh.LOAN_ID and ' ||
608: ' head.disb_header_id = line.disb_header_id and ' ||
609: ' line.status = ''FULLY_FUNDED''), 0) disbursed_amount ' ||

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

762: ' head.HEADER_PERCENT, ' ||
763: ' head.HEADER_AMOUNT, ' ||
764: ' fund_status.meaning status, ' ||
765: ' fund_act.meaning activity_name, ' ||
766: ' (select to_char(max(DISBURSEMENT_DATE),''MM/DD/YYYY'') from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID) DISBURSEMENT_DATE ' ||
767: ' from lns_disb_headers head, ' ||
768: ' lns_lookups fund_status, ' ||
769: ' lns_lookups fund_act ' ||
770: ' where head.loan_id = lh.loan_id and ' ||

Line 1416: from lns_disb_lines ldl

1412: )
1413: )
1414: )
1415: )
1416: from lns_disb_lines ldl
1417: ,hz_parties party
1418: ,IBY_PAYMENT_METHODS_TL ibypm
1419: where ldl.disb_header_id = ldih.disb_header_id
1420: and party.party_id = ldl.payee_party_id and