APPS.LNS_BILLING_UTIL_PUB dependencies on LNS_PAY_SUM_V

Line 478: | 01-19-2206 scherkas Obsoleted (use LNS_PAY_SUM_V instead)

474: |
475: | MODIFICATION HISTORY
476: | Date Author Description of Changes
477: | 01-01-2004 scherkas Created
478: | 01-19-2206 scherkas Obsoleted (use LNS_PAY_SUM_V instead)
479: |
480: *=======================================================================*/
481: FUNCTION NEXT_PAYMENT_DUE(P_LOAN_ID IN NUMBER, P_LINE_TYPE IN VARCHAR2, P_PAYMENT_NUMBER IN NUMBER) RETURN NUMBER
482: IS

Line 528: | 01-19-2206 scherkas Obsoleted (use LNS_PAY_SUM_V instead)

524: |
525: | MODIFICATION HISTORY
526: | Date Author Description of Changes
527: | 01-01-2004 scherkas Created
528: | 01-19-2206 scherkas Obsoleted (use LNS_PAY_SUM_V instead)
529: |
530: *=======================================================================*/
531: FUNCTION AMOUNT_PAID_YTD(P_LOAN_ID IN NUMBER, P_LINE_TYPE VARCHAR2) RETURN NUMBER
532: IS

Line 1037: from LNS_PAY_SUM_V

1033: +-----------------------------------------------------------------------*/
1034:
1035: CURSOR c_remain_amt(P_LOAN_ID NUMBER) IS
1036: select TOTAL_PRINCIPAL_BALANCE
1037: from LNS_PAY_SUM_V
1038: where loan_id = P_LOAN_ID;
1039: /*
1040: SELECT
1041: (CASE WHEN LnsLoanHeaderEO.loan_status in ('INCOMPLETE','REJECTED','DELETED','PENDING','APPROVED','IN_FUNDING','FUNDING_ERROR','CANCELLED') OR LnsLoanHeaderEO.FUNDED_AMOUNT = 0 THEN LnsLoanHeaderEO.requested_amount