APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_AM_SCHEDS_V

Line 515: from LNS_AM_SCHEDS_V

511: sum.total_principal_balance <= 0;
512:
513: CURSOR validate_loan_cur(P_LOAN_ID number) IS
514: select nvl(sum(total_remaining_amount),0)
515: from LNS_AM_SCHEDS_V
516: where loan_id = P_LOAN_ID and
517: reversed_code = 'N';
518:
519: BEGIN

Line 744: from LNS_AM_SCHEDS_V

740: LNS_LOAN_HEADERS head
741: where
742: head.loan_status = 'PAIDOFF' and
743: ((select nvl(sum(total_remaining_amount),0)
744: from LNS_AM_SCHEDS_V
745: where loan_id = head.loan_id and
746: reversed_code = 'N') > 0);
747:
748: BEGIN

Line 3279: 'from lns_am_scheds_v payment_history ' ||

3275: 'interest_amount interest_amount, ' ||
3276: 'fee_amount fee_amount, ' ||
3277: 'total_billed_amount total_billed_amount, ' ||
3278: '(PRINCIPAL_PAID + INTEREST_PAID + FEE_PAID) total_payment_amount ' ||
3279: 'from lns_am_scheds_v payment_history ' ||
3280: 'where payment_history.loan_id = loan.loan_id and ' ||
3281: 'nvl(payment_history.PHASE, ''TERM'') = nvl(loan.CURRENT_PHASE, ''TERM'') and ' ||
3282: 'payment_history.reversed_code = ''N'' and ' ||
3283: '(payment_history.payment_number between (payment_summary.next_payment_number - 2) and payment_summary.next_payment_number) and ' ||

Line 6634: from LNS_AM_SCHEDS_V

6630: PAYMENT_NUMBER,
6631: DUE_DATE,
6632: PARENT_AMORTIZATION_ID,
6633: REVERSED_CODE
6634: from LNS_AM_SCHEDS_V
6635: where AMORTIZATION_SCHEDULE_ID = P_AMORTIZATION_ID;
6636:
6637:
6638: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number) IS