APPS.ARP_CALCULATE_DISCOUNT dependencies on AR_TRX_DISCOUNTS_V

Line 782: | view AR_TRX_DISCOUNTS_V.

778: |
779: |
780: | NOTES
781: | Note that this routine has changed from the original and requires
782: | view AR_TRX_DISCOUNTS_V.
783: | This view should be defined in file arvrdisc.sql
784: |
785: | MODIFICATION HISTORY -
786: | 5/24/1995 Created by Shiv Ragunat

Line 788: | AR_TRX_DISCOUNTS_V to centralize

784: |
785: | MODIFICATION HISTORY -
786: | 5/24/1995 Created by Shiv Ragunat
787: | 1/29/1996 Harri Kaukovuo Changed routine to use view
788: | AR_TRX_DISCOUNTS_V to centralize
789: | discount calculation.
790: | 3/28/1996 H.Kaukovuo Finished the changes.
791: +===========================================================================*/
792:

Line 811: FROM ar_trx_discounts_v td

807: CURSOR c_discounts(p_calculated_date in date) IS
808: SELECT
809: td.discount_percent
810: , td.discount_date
811: FROM ar_trx_discounts_v td
812: WHERE
813: td.payment_schedule_id = p_ps_rec.payment_schedule_id
814: AND p_calculated_date <= td.discount_date
815: ORDER BY