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 PSA_TRX_TYPES_ALL

Line 3597: ,psa_trx_types_all psa

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'
3601: and lines.end_date is null

Line 3611: ,psa_trx_types_all psa

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
3615: and lines.end_date is null