DBA Data[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB dependencies on RA_CUSTOMER_TRX_ALL

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 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