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 LNS_LOAN_LINES

Line 2839: from lns_loan_lines

2835:
2836: --find out if there is more than one line
2837: cursor c_loan_lines(p_loan_id number) is
2838: select count(1)
2839: from lns_loan_lines
2840: where loan_id = p_loan_id
2841: and reference_type = 'RECEIVABLE'
2842: and end_date is null;
2843:

Line 2847: from lns_loan_lines lines

2843:
2844: -- for loans with more than one line
2845: cursor c_validate_MFAR (p_loan_id number) is
2846: select ra.cust_trx_type_id, nvl(psa.psa_trx_type_id,-1)
2847: from lns_loan_lines lines
2848: ,ra_customer_trx ra
2849: ,psa_trx_types_all psa
2850: where ra.customer_trx_id = lines.reference_id
2851: and psa.psa_trx_type_id (+)= ra.cust_trx_type_id

Line 2864: ,lns_loan_lines lines

2860: is
2861: select nvl(1,0)
2862: from ra_customer_trx ra
2863: ,psa_trx_types_all psa
2864: ,lns_loan_lines lines
2865: where ra.CUST_TRX_TYPE_ID = psa.psa_trx_type_id
2866: and ra.customer_trx_id = lines.reference_id
2867: and lines.end_date is null
2868: and lines.reference_type = 'RECEIVABLE'

Line 3240: || 12-18-2004 raverma look at lns_loan_lines

3236: || 03-16-2004 raverma added in default for multi-fund loans inherit from receivables
3237: || 06-16-2004 raverma changed rules on inheritance for MFAR transactions
3238: || get amounts for MFAR from PSA_MF_BALANCES_VIEW
3239: || 07-26-2004 raverma delete rows before each call to accounting
3240: || 12-18-2004 raverma look at lns_loan_lines
3241: || 12-18-2004 raverma need to get loan class code
3242: || 04-19-2005 raverma establish loan clearing as per bug #4313925
3243: *=======================================================================*/
3244: procedure defaultDistributions(p_api_version IN NUMBER

Line 3357: from lns_loan_lines lines

3353: and xad.assignment_code = xaa.assignment_code
3354: and xad.enabled_flag = 'Y')
3355: and inv.customer_trx_id in
3356: (select reference_id
3357: from lns_loan_lines lines
3358: where reference_type = 'RECEIVABLE'
3359: and end_date is null
3360: and loan_id = p_loan_id)
3361: group by ael.code_combination_id;

Line 3392: from lns_loan_lines lines

3388: and xad.assignment_code = xaa.assignment_code
3389: and xad.enabled_flag = 'Y')
3390: and adj.adjustment_id in
3391: (select rec_adjustment_id
3392: from lns_loan_lines lines
3393: where reference_type = 'RECEIVABLE'
3394: and end_date is null
3395: and loan_id = p_loan_id)
3396: group by ael.code_combination_id;

Line 3414: ,lns_loan_lines lines

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'
3418: and lines.loan_id = p_loan_id;

Line 3424: from lns_loan_lines lines

3420: -- use this to get all receivables to be processed for the loan
3421: cursor c_inv_ids(p_loan_id number) is
3422: select lines.reference_id
3423: ,lines.reference_number
3424: from lns_loan_lines lines
3425: where lines.end_date is null
3426: and lines.reference_type = 'RECEIVABLE'
3427: and lines.loan_id = p_loan_id;
3428:

Line 3438: from lns_loan_lines lines

3434:
3435: -- cursor to get documents and check upgrade status
3436: cursor c_get_loan_documents(p_loan_id number) is
3437: select lines.reference_id, trx.trx_number
3438: from lns_loan_lines lines
3439: ,ra_customer_trx trx
3440: where lines.reference_type = 'RECEIVABLE'
3441: and lines.end_date is null
3442: and lines.loan_id = p_loan_id

Line 3456: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))

3452: and xlt.entity_id = err.entity_id
3453: and xlt.entity_id in (select entity_id from xla_transaction_entities
3454: where application_id = 222
3455: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
3456: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))
3457: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));
3458: -- -----------------------------------------------------------------
3459: cursor c_entities(p_loan_id number) is
3460: select entity_id, entity_code, source_id_int_1, transaction_number

Line 3457: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));

3453: and xlt.entity_id in (select entity_id from xla_transaction_entities
3454: where application_id = 222
3455: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
3456: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))
3457: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));
3458: -- -----------------------------------------------------------------
3459: cursor c_entities(p_loan_id number) is
3460: select entity_id, entity_code, source_id_int_1, transaction_number
3461: from xla_transaction_entities

Line 3464: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id)

3460: select entity_id, entity_code, source_id_int_1, transaction_number
3461: from xla_transaction_entities
3462: where application_id = 222
3463: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
3464: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id)
3465: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));
3466:
3467: begin
3468:

Line 3465: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));

3461: from xla_transaction_entities
3462: where application_id = 222
3463: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
3464: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id)
3465: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));
3466:
3467: begin
3468:
3469: SAVEPOINT defaultDistributions;