APPS.LNS_FINANCIALS dependencies on LNS_PRIN_TRX_ACTIVITIES_V

Line 2478: from LNS_PRIN_TRX_ACTIVITIES_V

2474:
2475: -- get last bill date
2476: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
2477: select ACTIVITY_DATE
2478: from LNS_PRIN_TRX_ACTIVITIES_V
2479: where loan_id = p_loan_id
2480: and PAYMENT_NUMBER = p_installment_number
2481: and PARENT_AMORTIZATION_ID is null
2482: and ACTIVITY_CODE in ('BILLING', 'START');

Line 3879: from LNS_PRIN_TRX_ACTIVITIES_V

3875:
3876: -- get last bill date
3877: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
3878: select ACTIVITY_DATE
3879: from LNS_PRIN_TRX_ACTIVITIES_V
3880: where loan_id = p_loan_id
3881: and PAYMENT_NUMBER = p_installment_number
3882: and PARENT_AMORTIZATION_ID is null
3883: and ACTIVITY_CODE in ('BILLING', 'START');

Line 5102: from LNS_PRIN_TRX_ACTIVITIES_V

5098:
5099: -- get last bill date
5100: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
5101: select ACTIVITY_DATE
5102: from LNS_PRIN_TRX_ACTIVITIES_V
5103: where loan_id = p_loan_id
5104: and PAYMENT_NUMBER = p_installment_number
5105: and PARENT_AMORTIZATION_ID is null
5106: and ACTIVITY_CODE in ('BILLING', 'START');

Line 9099: from LNS_PRIN_TRX_ACTIVITIES_V

9095: where h.loan_id = p_loan_id;
9096:
9097: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is
9098: select ACTIVITY_DATE
9099: from LNS_PRIN_TRX_ACTIVITIES_V
9100: where loan_id = p_loan_id
9101: and PAYMENT_NUMBER = p_installment_number
9102: and PARENT_AMORTIZATION_ID is null
9103: and ACTIVITY_CODE in ('BILLING', 'START');

Line 11063: from LNS_PRIN_TRX_ACTIVITIES_V

11059: THEORETICAL_BALANCE,
11060: ACTUAL_BALANCE,
11061: DAYS_LATE,
11062: display_order
11063: from LNS_PRIN_TRX_ACTIVITIES_V
11064: where loan_id = p_loan_id and
11065: trunc(ACTIVITY_DATE) >= trunc(p_start_date) and
11066: trunc(ACTIVITY_DATE) <= trunc(p_end_date) and
11067: ACTIVITY_CODE in ('START', 'DUE', 'DISBURSEMENT', 'INVOICE_ADDED')

Line 11317: from LNS_PRIN_TRX_ACTIVITIES_V

11313: THEORETICAL_BALANCE,
11314: ACTUAL_BALANCE,
11315: DAYS_LATE,
11316: display_order
11317: from LNS_PRIN_TRX_ACTIVITIES_V
11318: where loan_id = p_loan_id and
11319: trunc(ACTIVITY_DATE) >= trunc(p_start_date) and
11320: trunc(ACTIVITY_DATE) < trunc(p_end_date) and
11321: ACTIVITY_CODE not in ('DISBURSEMENT', 'INVOICE_ADDED')

Line 12209: from LNS_PRIN_TRX_ACTIVITIES_V

12205: THEORETICAL_BALANCE,
12206: ACTUAL_BALANCE,
12207: DAYS_LATE,
12208: display_order
12209: from LNS_PRIN_TRX_ACTIVITIES_V
12210: where loan_id = p_loan_id and
12211: payment_number = p_payment_number and
12212: DAYS_LATE < 0 and
12213: ACTIVITY_CODE in ('PMT', 'CM', 'ADJUSTMENT')