DBA Data[Home] [Help]

APPS.ARP_CALCULATE_DISCOUNT dependencies on RA_TERMS

Line 653: FROM ar_payment_schedules ps, ra_terms t

649: p_ps_rec.invoice_currency_code,
650: p_ps_rec.amount_in_dispute,/*FP 5335376 for Bug 5223829 assign value of dispute*/
651: p_disc_rec.calc_disc_on_lines,
652: p_disc_rec.disc_partial_pmt_flag
653: FROM ar_payment_schedules ps, ra_terms t
654: WHERE ps.payment_schedule_id = l_payment_schedule_id
655: AND ps.term_id = t.term_id(+);
656:
657: EXCEPTION

Line 737: FROM RA_TERMS_LINES_DISCOUNTS tld

733: --
734:
735: SELECT NVL(MAX(discount_percent),0) * 0.01
736: INTO p_disc_rec.best_disc_pct
737: FROM RA_TERMS_LINES_DISCOUNTS tld
738: WHERE
739: tld.term_id = p_ps_rec.term_id
740: AND tld.sequence_num = p_ps_rec.terms_sequence_number;
741:

Line 2346: p_term_id IN ra_terms.term_id%TYPE,

2342: PROCEDURE discounts_cover(
2343: p_mode IN VARCHAR2,
2344: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2345: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2346: p_term_id IN ra_terms.term_id%TYPE,
2347: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2348: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2349: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2350: p_grace_days IN NUMBER,

Line 2600: p_term_id IN ra_terms.term_id%TYPE,

2596: PROCEDURE discounts_cover(
2597: p_mode IN VARCHAR2,
2598: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2600: p_term_id IN ra_terms.term_id%TYPE,
2601: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2602: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2603: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2604: p_grace_days IN NUMBER,