APPS.LNS_LOAN_PUB dependencies on RA_CUST_TRX_TYPES

Line 771: ,RA_CUST_TRX_TYPES_ALL rtyp

767: BEGIN
768: SELECT 'Y'
769: INTO l_dummy
770: FROM ar_lookups alk
771: ,RA_CUST_TRX_TYPES_ALL rtyp
772: WHERE rtyp.CUST_TRX_TYPE_ID = P_Loan_Details_Rec.trx_type_id
773: AND alk.lookup_code = rtyp.type
774: AND alk.lookup_type = 'INV/CM';
775: EXCEPTION

Line 2184: RA_CUST_TRX_TYPES trx_type,

2180: ,p_loan_lines_tbl(l_count).installment_number
2181: FROM
2182: ar_payment_schedules_all pmt_sch,
2183: hz_cust_accounts account,
2184: RA_CUST_TRX_TYPES trx_type,
2185: ar_lookups trx_type_lkup,
2186: ar_lookups trx_class_lkup
2187: WHERE
2188: pmt_sch.class in ('INV','DM') and