APPS.LNS_REP_UTILS dependencies on LNS_DISB_HEADERS

Line 606: ' lns_disb_headers head ' ||

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

Line 767: ' from lns_disb_headers head, ' ||

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

Line 1495: FROM lns_disb_headers ldih

1491: ) -- end of DISBCOND
1492: )
1493: )
1494: )
1495: FROM lns_disb_headers ldih
1496: ,lns_lookups llkac
1497: WHERE ldih.loan_id = lh.loan_id and
1498: llkac.lookup_code = ldih.activity_code
1499: ), -- end of DISBURSEMENTS

Line 1551: lns_disb_headers ldh,

1547: lns_lookups llkfq,
1548: lns_lookups llkfqf,
1549: lns_lookups llkic,
1550: jtf_rs_resource_extns res,
1551: lns_disb_headers ldh,
1552: lns_loan_products_all_vl product
1553: where
1554: lh.primary_borrower_id = hp.party_id and
1555: --lh.loan_id = pay.loan_id and --Bug5262505