APPS.LNS_FEE_ENGINE dependencies on LNS_DISB_HEADERS

Line 130: ,lns_disb_headers head

126: ,decode(ass.rate_type, 'FIXED', fee.fee, 'VARIABLE', fee.fee/100 * head.header_amount)
127: ,fee.fee_description
128: ,ass.fee_basis
129: from lns_fee_assignments ass
130: ,lns_disb_headers head
131: ,lns_fees_all fee
132: where ass.loan_id is null
133: and ass.disb_header_id = head.disb_header_id
134: and fee.fee_id = ass.fee_id

Line 151: ,lns_disb_headers h

147: -- fee basis for TOTAL_DISB_AMT
148: cursor c_totalDisbursed(p_loan_id number) is
149: select sum(l.line_amount)
150: from lns_disb_lines l
151: ,lns_disb_headers h
152: where h.disb_header_id = l.disb_header_id
153: and l.status = 'FULLY_FUNDED'
154: and h.loan_id = p_loan_id;
155: --

Line 863: ,lns_disb_headers dh

859: ,dh.target_date
860: ,dh.header_amount
861: from lns_fee_assignments assgn
862: ,lns_fees_all fees
863: ,lns_disb_headers dh
864: where dh.loan_id = nvl(p_loan_id, dh.loan_id)
865: and dh.disb_header_id = nvl(p_disb_header_id, dh.disb_header_id)
866: and fees.fee_id = nvl(p_fee_id, fees.fee_id)
867: and assgn.fee_id = fees.fee_id

Line 965: from lns_disb_headers

961: where loan_id = p_loan_id;
962:
963: cursor c_disbAmount(p_disb_header_id number) is
964: select header_amount
965: from lns_disb_headers
966: where disb_header_id = p_disb_header_id;
967:
968: l_original_loan_amount number;
969: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;