APPS.LNS_PAYOFF_PUB dependencies on AR_LOOKUPS

Line 989: from ar_lookups

985: fetch c_lastInterestAmount into l_last_interest;
986: close c_lastInterestAmount;
987:
988: select meaning into l_credit_name
989: from ar_lookups
990: where lookup_type = 'INV/CM'
991: and lookup_code = 'CM';
992:
993: -- interest document (credit)

Line 1491: ar_lookups trx_type_lkup

1487: lines.INSTALLMENT_NUMBER
1488: from lns_loan_lines lines,
1489: RA_CUSTOMER_TRX_ALL cust_trx,
1490: RA_CUST_TRX_TYPES trx_type,
1491: ar_lookups trx_type_lkup
1492: where lines.status = 'APPROVED'
1493: and lines.REFERENCE_ID <> -1
1494: and lines.LOAN_ID = P_LOAN_ID
1495: and cust_trx.customer_trx_id = lines.reference_id