APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_AM_SCHEDS_V

Line 522: from LNS_AM_SCHEDS_V

518: (head.REQUESTED_AMOUNT + nvl(head.ADD_REQUESTED_AMOUNT, 0)) = sum.TOTAL_PRIN_PAID_TODATE;
519:
520: CURSOR validate_loan_cur(P_LOAN_ID number) IS
521: select nvl(sum(total_remaining_amount),0)
522: from LNS_AM_SCHEDS_V
523: where loan_id = P_LOAN_ID and
524: reversed_code = 'N';
525:
526: BEGIN

Line 751: from LNS_AM_SCHEDS_V

747: LNS_LOAN_HEADERS head
748: where
749: head.loan_status = 'PAIDOFF' and
750: ((select nvl(sum(total_remaining_amount),0)
751: from LNS_AM_SCHEDS_V
752: where loan_id = head.loan_id and
753: reversed_code = 'N') > 0);
754:
755: BEGIN

Line 3550: 'from lns_am_scheds_v payment_history ' ||

3546: 'interest_amount interest_amount, ' ||
3547: 'fee_amount fee_amount, ' ||
3548: 'total_billed_amount total_billed_amount, ' ||
3549: '(PRINCIPAL_PAID + INTEREST_PAID + FEE_PAID) total_payment_amount ' ||
3550: 'from lns_am_scheds_v payment_history ' ||
3551: 'where payment_history.loan_id = loan.loan_id and ' ||
3552: 'nvl(payment_history.PHASE, ''TERM'') = nvl(loan.CURRENT_PHASE, ''TERM'') and ' ||
3553: 'payment_history.reversed_code = ''N'' and ' ||
3554: '(payment_history.payment_number between (PAY_SUM.next_payment_number - 2) and PAY_SUM.next_payment_number) and ' ||

Line 7261: from LNS_AM_SCHEDS_V

7257: PAYMENT_NUMBER,
7258: DUE_DATE,
7259: PARENT_AMORTIZATION_ID,
7260: REVERSED_CODE
7261: from LNS_AM_SCHEDS_V
7262: where AMORTIZATION_SCHEDULE_ID = P_AMORTIZATION_ID;
7263:
7264:
7265: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number) IS