DBA Data[Home] [Help]

APPS.LNS_FEE_ENGINE dependencies on LNS_PRIN_TRX_ACTIVITIES_V

Line 3336: from LNS_PRIN_TRX_ACTIVITIES_V

3332: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N');
3333:
3334: cursor c_prin_overdue(p_loan_id number, p_date date) is
3335: select (ACTUAL_BALANCE - THEORETICAL_BALANCE)
3336: from LNS_PRIN_TRX_ACTIVITIES_V
3337: where loan_id = p_loan_id and
3338: trunc(ACTIVITY_DATE) <= trunc(p_date)
3339: and ACTIVITY_CODE not in ('DISBURSEMENT', 'INVOICE_ADDED')
3340: order by activity_date desc, display_order desc;