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_DISTRIBUTIONS_PUB dependencies on AR_ADJUSTMENTS

Line 3369: from ar_adjustments_all adj

3365: -- xla team instructions (noela, ayse)
3366: cursor C_ERS_LOAN_CLEARING(p_loan_id number) is
3367: select sum(ael.entered_dr)
3368: ,ael.code_combination_id
3369: from ar_adjustments_all adj
3370: ,xla_transaction_entities ent
3371: ,xla_ae_headers aeh
3372: ,xla_ae_lines ael
3373: where ent.application_id = 222

Line 3413: from ar_adjustments adj

3409: -- use this to get all adjustments to be processed for the loan
3410: cursor c_adj_ids (p_loan_id number) is
3411: select adj.adjustment_id
3412: ,adj.adjustment_number
3413: from ar_adjustments adj
3414: ,lns_loan_lines lines
3415: where lines.rec_adjustment_number = adj.adjustment_number
3416: and lines.end_date is null
3417: and lines.reference_type = 'RECEIVABLE'