APPS.LNS_DISTRIBUTIONS_PUB dependencies on RA_CUSTOMER_TRX

Line 3596: ,ra_customer_trx ra

3592: -- for loans with more than one line
3593: cursor c_validate_MFAR (p_loan_id number) is
3594: select ra.cust_trx_type_id, nvl(psa.psa_trx_type_id,-1)
3595: from lns_loan_lines lines
3596: ,ra_customer_trx ra
3597: ,psa_trx_types_all psa
3598: where ra.customer_trx_id = lines.reference_id
3599: and psa.psa_trx_type_id (+)= ra.cust_trx_type_id
3600: and lines.reference_type = 'RECEIVABLE'

Line 3598: where ra.customer_trx_id = lines.reference_id

3594: select ra.cust_trx_type_id, nvl(psa.psa_trx_type_id,-1)
3595: from lns_loan_lines lines
3596: ,ra_customer_trx ra
3597: ,psa_trx_types_all psa
3598: where ra.customer_trx_id = lines.reference_id
3599: and psa.psa_trx_type_id (+)= ra.cust_trx_type_id
3600: and lines.reference_type = 'RECEIVABLE'
3601: and lines.end_date is null
3602: and lines.loan_id = p_loan_id

Line 3610: from ra_customer_trx ra

3606: -- assumes only one line is on the loan
3607: cursor c_multiFundTrx(p_loan_id in number)
3608: is
3609: select nvl(1,0)
3610: from ra_customer_trx ra
3611: ,psa_trx_types_all psa
3612: ,lns_loan_lines lines
3613: where ra.CUST_TRX_TYPE_ID = psa.psa_trx_type_id
3614: and ra.customer_trx_id = lines.reference_id

Line 3614: and ra.customer_trx_id = lines.reference_id

3610: from ra_customer_trx ra
3611: ,psa_trx_types_all psa
3612: ,lns_loan_lines lines
3613: where ra.CUST_TRX_TYPE_ID = psa.psa_trx_type_id
3614: and ra.customer_trx_id = lines.reference_id
3615: and lines.end_date is null
3616: and lines.reference_type = 'RECEIVABLE'
3617: and lines.loan_id = p_loan_id
3618: group by lines.loan_id;

Line 4163: from ra_customer_trx_all inv

4159: -- xla team instructions (noela, ayse)
4160: cursor C_ERS_LOAN_RECEIVABLE(p_loan_id number) is
4161: select sum(lline.requested_amount)
4162: ,ael.code_combination_id
4163: from ra_customer_trx_all inv
4164: ,xla_transaction_entities ent
4165: ,xla_ae_headers aeh
4166: ,xla_ae_lines ael
4167: ,lns_loan_lines lline

Line 4276: ,ra_customer_trx trx

4272: -- cursor to get documents and check upgrade status
4273: cursor c_get_loan_documents(p_loan_id number) is
4274: select lines.reference_id, trx.trx_number
4275: from lns_loan_lines lines
4276: ,ra_customer_trx trx
4277: where lines.reference_type = 'RECEIVABLE'
4278: and lines.end_date is null
4279: and lines.loan_id = p_loan_id
4280: and lines.reference_id = trx.customer_trx_id;

Line 6561: ,ra_customer_trx trx

6557: -- cursor to get documents and check upgrade status
6558: cursor c_get_line_documents(p_loan_line_id number) is
6559: select lines.reference_id, trx.trx_number
6560: from lns_loan_lines lines
6561: ,ra_customer_trx trx
6562: where lines.reference_type = 'RECEIVABLE'
6563: and lines.end_date is null
6564: and lines.loan_line_id = p_loan_line_id
6565: and lines.reference_id = trx.customer_trx_id;

Line 6625: from ra_customer_trx_all inv

6621:
6622: cursor C_ERS_LOAN_RECEIVABLE(p_loan_line_id number) is
6623: select sum(ael.entered_dr)
6624: ,ael.code_combination_id
6625: from ra_customer_trx_all inv
6626: ,xla_transaction_entities ent
6627: ,xla_ae_headers aeh
6628: ,xla_ae_lines ael
6629: where ent.application_id = 222