APPS.LNS_FINANCIALS dependencies on LNS_PRIN_TRX_ACTIVITIES_V

Line 2606: from LNS_PRIN_TRX_ACTIVITIES_V

2602:
2603: -- get last bill date
2604: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
2605: select ACTIVITY_DATE
2606: from LNS_PRIN_TRX_ACTIVITIES_V
2607: where loan_id = p_loan_id
2608: and PAYMENT_NUMBER = p_installment_number
2609: and PARENT_AMORTIZATION_ID is null
2610: and ACTIVITY_CODE in ('BILLING', 'START');

Line 3660: from LNS_PRIN_TRX_ACTIVITIES_V

3656:
3657: -- get last bill date
3658: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
3659: select ACTIVITY_DATE
3660: from LNS_PRIN_TRX_ACTIVITIES_V
3661: where loan_id = p_loan_id
3662: and PAYMENT_NUMBER = p_installment_number
3663: and PARENT_AMORTIZATION_ID is null
3664: and ACTIVITY_CODE in ('BILLING', 'START');

Line 4668: from LNS_PRIN_TRX_ACTIVITIES_V

4664:
4665: -- get last bill date
4666: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
4667: select ACTIVITY_DATE
4668: from LNS_PRIN_TRX_ACTIVITIES_V
4669: where loan_id = p_loan_id
4670: and PAYMENT_NUMBER = p_installment_number
4671: and PARENT_AMORTIZATION_ID is null
4672: and ACTIVITY_CODE in ('BILLING', 'START');

Line 8273: from LNS_PRIN_TRX_ACTIVITIES_V

8269: and t.loan_id = h.loan_id;
8270:
8271: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
8272: select ACTIVITY_DATE
8273: from LNS_PRIN_TRX_ACTIVITIES_V
8274: where loan_id = p_loan_id
8275: and PAYMENT_NUMBER = p_installment_number
8276: and PARENT_AMORTIZATION_ID is null
8277: and ACTIVITY_CODE in ('BILLING', 'START');

Line 9857: from LNS_PRIN_TRX_ACTIVITIES_V

9853: THEORETICAL_BALANCE,
9854: ACTUAL_BALANCE,
9855: DAYS_LATE,
9856: display_order
9857: from LNS_PRIN_TRX_ACTIVITIES_V
9858: where loan_id = p_loan_id and
9859: trunc(ACTIVITY_DATE) >= trunc(p_start_date) and
9860: trunc(ACTIVITY_DATE) < trunc(p_end_date) and
9861: ACTIVITY_CODE in ('START', 'DUE')

Line 10049: from LNS_PRIN_TRX_ACTIVITIES_V

10045: THEORETICAL_BALANCE,
10046: ACTUAL_BALANCE,
10047: DAYS_LATE,
10048: display_order
10049: from LNS_PRIN_TRX_ACTIVITIES_V
10050: where loan_id = p_loan_id and
10051: trunc(ACTIVITY_DATE) >= trunc(p_start_date) and
10052: trunc(ACTIVITY_DATE) < trunc(p_end_date)
10053: order by activity_date, display_order;