APPS.LNS_LOAN_PUB dependencies on RA_CUST_TRX_TYPES

Line 680: ,RA_CUST_TRX_TYPES_ALL rtyp

676: BEGIN
677: SELECT 'Y'
678: INTO l_dummy
679: FROM ar_lookups alk
680: ,RA_CUST_TRX_TYPES_ALL rtyp
681: WHERE rtyp.CUST_TRX_TYPE_ID = P_Loan_Details_Rec.trx_type_id
682: AND alk.lookup_code = rtyp.type
683: AND alk.lookup_type = 'INV/CM';
684: EXCEPTION

Line 1048: RA_CUST_TRX_TYPES trx_type,

1044: ,v_installment_number(j)
1045: FROM
1046: ar_payment_schedules_all pmt_sch,
1047: hz_cust_accounts account,
1048: RA_CUST_TRX_TYPES trx_type,
1049: ar_lookups trx_type_lkup,
1050: ar_lookups trx_class_lkup
1051: WHERE
1052: pmt_sch.class in ('INV','DM') and