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 2849: ,psa_trx_types_all psa

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

Line 2863: ,psa_trx_types_all psa

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