[Home] [Help]
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
142: and ass.disb_header_id = p_disb_head_id;
146: ,decode(ass.rate_type, 'FIXED', nvl(ass.fee,fee.fee), 'VARIABLE', nvl(ass.fee,fee.fee)/100)
147: ,fee.fee_description
148: ,ass.fee_basis
149: from lns_fee_assignments ass
150: ,lns_fees_all fee
151: where ass.fee_type = 'EVENT_CONVERSION'
152: and ass.fee_id = fee.fee_id
153: and loan_id = c_loan_id;
154:
578: ,0
579: ,0
580: ,nvl(fees.fee_editable_flag,'N')
581: ,nvl(fees.fee_waivable_flag,'N')
582: from lns_fees_all fees
583: where fees.fee_id = p_fee_id;
584:
585: begin
586: l_api_name := 'getFeeStructures';
715: ,assgn.disb_header_id
716: ,nvl(assgn.phase, 'TERM')
717: ,nvl(assgn.CUSTOM_PROCEDURE, fees.CUSTOM_PROCEDURE)
718: from lns_fee_assignments assgn
719: ,lns_fees_all fees
720: where assgn.loan_id = nvl(p_loan_id, assgn.loan_id)
721: and assgn.fee_id = fees.fee_id
722: and nvl(trunc(assgn.end_date_active), trunc(sysdate) + 1) >= trunc(sysdate)
723: and nvl(trunc(assgn.start_date_active), trunc(sysdate) - 1) <= trunc(sysdate)
888: ,dh.target_date
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)
1584: ,struct.fee_name
1585: ,struct.fee_description
1586: ,sched.phase
1587: from lns_fee_schedules sched
1588: ,lns_fees_all struct
1589: where disb_header_id = c_disb_header_id
1590: and sched.fee_id = struct.fee_id
1591: and nvl(sched.phase, 'TERM') = c_phase;
1592: