DBA Data[Home] [Help]

APPS.LNS_CUSTOM_PUB dependencies on LNS_PRIN_TRX_ACTIVITIES_V

Line 1998: from LNS_PRIN_TRX_ACTIVITIES_V

1994:
1995: -- get last bill date
1996: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
1997: select ACTIVITY_DATE
1998: from LNS_PRIN_TRX_ACTIVITIES_V
1999: where loan_id = p_loan_id
2000: and PAYMENT_NUMBER = p_installment_number
2001: and ACTIVITY_CODE in ('BILLING', 'START');
2002: