APPS.LNS_REP_UTILS dependencies on LNS_DISB_HEADERS

Line 669: ' lns_disb_headers head ' ||

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 ' ||
673: ',nvl(lh.CURRENT_PHASE, ''TERM'') current_phase ' ||

Line 830: ' from lns_disb_headers head, ' ||

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 ' ||
834: ' fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||

Line 1589: FROM lns_disb_headers ldih

1585: ) -- end of DISBCOND
1586: )
1587: )
1588: )
1589: FROM lns_disb_headers ldih
1590: ,lns_lookups llkac
1591: WHERE ldih.loan_id = lh.loan_id and
1592: llkac.lookup_code = ldih.activity_code
1593: ), -- end of DISBURSEMENTS

Line 1655: lns_disb_headers ldh,

1651: lns_lookups llkfq,
1652: lns_lookups llkfqf,
1653: lns_lookups llkic,
1654: jtf_rs_resource_extns res,
1655: lns_disb_headers ldh,
1656: lns_loan_products_all_vl product
1657: where
1658: lh.primary_borrower_id = hp.party_id and
1659: --lh.loan_id = pay.loan_id and --Bug5262505