APPS.LNS_FEE_ENGINE dependencies on LNS_FEES_ALL

Line 131: ,lns_fees_all fee

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
135: and ass.disb_header_id = p_disb_head_id;

Line 143: ,lns_fees_all fee

139: ,decode(ass.rate_type, 'FIXED', fee.fee, 'VARIABLE', fee.fee/100)
140: ,fee.fee_description
141: ,ass.fee_basis
142: from lns_fee_assignments ass
143: ,lns_fees_all fee
144: where ass.fee_type = 'EVENT_CONVERSION'
145: and loan_id = p_loan_id;
146:
147: -- fee basis for TOTAL_DISB_AMT

Line 611: from lns_fees_all fees

607: ,0
608: ,0
609: ,nvl(fees.fee_editable_flag,'N')
610: ,nvl(fees.fee_waivable_flag,'N')
611: from lns_fees_all fees
612: where fees.fee_id = p_fee_id;
613:
614: begin
615: l_api_name := 'getFeeStructures';

Line 729: ,lns_fees_all fees

725: ,nvl(assgn.end_installment_number,0)
726: ,nvl(fees.fee_editable_flag,'N')
727: ,nvl(fees.fee_waivable_flag,'N')
728: from lns_fee_assignments assgn
729: ,lns_fees_all fees
730: where assgn.loan_id = nvl(p_loan_id, assgn.loan_id)
731: and assgn.fee_id = fees.fee_id
732: and nvl(trunc(assgn.end_date_active), trunc(sysdate) + 1) >= trunc(sysdate)
733: and nvl(trunc(assgn.start_date_active), trunc(sysdate) - 1) <= trunc(sysdate)

Line 862: ,lns_fees_all fees

858: ,dh.disb_header_id
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)

Line 1434: ,lns_fees_all struct

1430: ,sched.fee_amount - nvl(sched.waived_amount, 0)
1431: ,struct.fee_name
1432: ,struct.fee_description
1433: from lns_fee_schedules sched
1434: ,lns_fees_all struct
1435: where disb_header_id = p_disb_header_id
1436: and sched.fee_id = struct.fee_id;
1437:
1438: begin

Line 1629: ,lns_fees_all fee

1625: ,ass.fee
1626: ,fee.fee_category
1627: ,fee.fee_type
1628: from lns_fee_assignments ass
1629: ,lns_fees_all fee
1630: where ass.loan_id = p_loan_id
1631: and fee.fee_id = ass.fee_id
1632: and ass.fee_type = 'EVENT_CONVERSION';
1633: