APPS.LNS_FEE_ENGINE dependencies on LNS_DISB_HEADERS

Line 137: ,lns_disb_headers head

133: ,ass.fee_basis
134: ,nvl(ass.begin_installment_number, 0) -- fix for bug 8928398
135: ,nvl(ass.phase, 'TERM')
136: from lns_fee_assignments ass
137: ,lns_disb_headers head
138: ,lns_fees_all fee
139: where ass.loan_id is null
140: and ass.disb_header_id = head.disb_header_id
141: and fee.fee_id = ass.fee_id

Line 159: ,lns_disb_headers h

155: -- fee basis for TOTAL_DISB_AMT
156: cursor c_totalDisbursed(p_loan_id number) is
157: select sum(l.line_amount)
158: from lns_disb_lines l
159: ,lns_disb_headers h
160: where h.disb_header_id = l.disb_header_id
161: and l.status = 'FULLY_FUNDED'
162: and h.loan_id = p_loan_id;
163: --

Line 893: ,lns_disb_headers dh

889: ,dh.header_amount
890: ,nvl(assgn.phase, 'TERM')
891: from lns_fee_assignments assgn
892: ,lns_fees_all fees
893: ,lns_disb_headers dh
894: where dh.loan_id = nvl(p_loan_id, dh.loan_id)
895: and dh.disb_header_id = nvl(p_disb_header_id, dh.disb_header_id)
896: and fees.fee_id = nvl(p_fee_id, fees.fee_id)
897: and assgn.fee_id = fees.fee_id

Line 999: from lns_disb_headers

995: where loan_id = p_loan_id;
996:
997: cursor c_disbAmount(p_disb_header_id number) is
998: select header_amount
999: from lns_disb_headers
1000: where disb_header_id = p_disb_header_id;
1001:
1002: cursor c_from_installment(c_fee_id number, c_disb_header_id number, c_phase varchar2) is
1003: select nvl(BEGIN_INSTALLMENT_NUMBER,0)