eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.LNS_PAYOFF_PUB dependencies on LNS_FEE_SCHEDULES

Line 187: from lns_fee_schedules sched

183: is
184: select sched.fee_amount
185: ,fees.fee_name
186: ,sched.fee_installment
187: from lns_fee_schedules sched
188: ,lns_fees fees
189: where sched.loan_id = p_loan_id
190: and sched.fee_id = fees.fee_id
191: and sched.active_flag = 'Y'

Line 805: from lns_fee_schedules sched

801: is
802: select sched.fee_amount
803: ,fees.fee_name
804: ,sched.fee_installment
805: from lns_fee_schedules sched
806: ,lns_fees fees
807: where sched.loan_id = p_loan_id
808: and sched.fee_id = fees.fee_id
809: and sched.active_flag = 'Y'

Line 1470: from lns_fee_schedules sched

1466: cursor c_fees(p_loan_id number, p_phase varchar2, p_installment number) is
1467: select sched.fee_amount
1468: ,fees.fee_name
1469: ,sched.fee_installment
1470: from lns_fee_schedules sched
1471: ,lns_fees fees
1472: where sched.loan_id = p_loan_id
1473: and sched.fee_id = fees.fee_id
1474: and sched.active_flag = 'Y'