APPS.LNS_DISTRIBUTIONS_PUB dependencies on RA_CUSTOMER_TRX

Line 2848: ,ra_customer_trx ra

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
2852: and lines.reference_type = 'RECEIVABLE'

Line 2850: where ra.customer_trx_id = lines.reference_id

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
2852: and lines.reference_type = 'RECEIVABLE'
2853: and lines.end_date is null
2854: and lines.loan_id = p_loan_id

Line 2862: from ra_customer_trx ra

2858: -- assumes only one line is on the loan
2859: cursor c_multiFundTrx(p_loan_id in number)
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

Line 2866: and ra.customer_trx_id = lines.reference_id

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'
2869: and lines.loan_id = p_loan_id
2870: group by lines.loan_id;

Line 3334: from ra_customer_trx_all inv

3330: -- xla team instructions (noela, ayse)
3331: cursor C_ERS_LOAN_RECEIVABLE(p_loan_id number) is
3332: select sum(ael.entered_dr)
3333: ,ael.code_combination_id
3334: from ra_customer_trx_all inv
3335: ,xla_transaction_entities ent
3336: ,xla_ae_headers aeh
3337: ,xla_ae_lines ael
3338: where ent.application_id = 222

Line 3439: ,ra_customer_trx trx

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
3443: and lines.reference_id = trx.customer_trx_id;