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.

APPS.LNS_PAYOFF_PUB dependencies on LNS_FEES

Line 188: ,lns_fees fees

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'
192: and sched.billed_flag = 'N'

Line 806: ,lns_fees fees

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'
810: and sched.billed_flag = 'N'

Line 1471: ,lns_fees fees

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'
1475: and sched.billed_flag = 'N'