APPS.ARP_CALCULATE_DISCOUNT dependencies on AR_TRX_DISCOUNTS_V

Line 778: | view AR_TRX_DISCOUNTS_V.

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

Line 784: | AR_TRX_DISCOUNTS_V to centralize

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

Line 807: FROM ar_trx_discounts_v td

803: CURSOR c_discounts(p_calculated_date in date) IS
804: SELECT
805: td.discount_percent
806: , td.discount_date
807: FROM ar_trx_discounts_v td
808: WHERE
809: td.payment_schedule_id = p_ps_rec.payment_schedule_id
810: AND p_calculated_date <= td.discount_date
811: ORDER BY