APPS.FA_LEASE_SCHEDULE_PVT dependencies on FA_LEASE_PAYMENTS

Line 620: FROM FA_LEASE_PAYMENTS

616: FOR UPDATE OF PRESENT_VALUE;
617:
618: CURSOR C_PAYMENT IS
619: SELECT START_DATE,PAYMENT_AMOUNT,NUMBER_OF_PAYMENTS
620: FROM FA_LEASE_PAYMENTS
621: WHERE PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID
622: ORDER BY PAYMENT_LINE_NUMBER
623: FOR UPDATE OF ROW_PRESENT_VALUE;
624:

Line 633: -- CALCULATE ROW_PRESENT VLAUE FOR EACH ROW IN FA_LEASE_PAYMENTS AND

629:
630: BEGIN
631:
632: --------------------------------------------------------------------
633: -- CALCULATE ROW_PRESENT VLAUE FOR EACH ROW IN FA_LEASE_PAYMENTS AND
634: -- SUM ALL THE ROW_PRESENT VALUE FOR FA_LEASE_SHCEDULE.PRESENT_VALUE
635: --------------------------------------------------------------------
636:
637: FOR SCHEDULE_REC IN C_SCHEDULE LOOP

Line 712: UPDATE FA_LEASE_PAYMENTS

708: END IF;
709:
710: L_ROW_PRESENT_VALUE := ROUND(L_ROW_PRESENT_VALUE,
711: P_CURRENCY_PRECISION);
712: UPDATE FA_LEASE_PAYMENTS
713: SET ROW_PRESENT_VALUE = L_ROW_PRESENT_VALUE
714: WHERE CURRENT OF C_PAYMENT;
715: L_TOTAL_ROW_PRESENT_VALUE := L_TOTAL_ROW_PRESENT_VALUE + L_ROW_PRESENT_VALUE;
716:

Line 956: FROM FA_LEASE_PAYMENTS

952: SELECT
953: START_DATE,
954: NUMBER_OF_PAYMENTS,
955: PAYMENT_AMOUNT
956: FROM FA_LEASE_PAYMENTS
957: WHERE PAYMENT_SCHEDULE_ID=P_PAYMENT_SCHEDULE_ID
958: ORDER BY PAYMENT_LINE_NUMBER;
959:
960: CURSOR C IS