APPS.ARP_CALCULATE_DISCOUNT dependencies on RA_TERMS

Line 649: FROM ar_payment_schedules ps, ra_terms t

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

Line 733: FROM RA_TERMS_LINES_DISCOUNTS tld

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

Line 2337: p_term_id IN ra_terms.term_id%TYPE,

2333: PROCEDURE discounts_cover(
2334: p_mode IN VARCHAR2,
2335: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2336: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2337: p_term_id IN ra_terms.term_id%TYPE,
2338: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2339: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2340: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2341: p_grace_days IN NUMBER,

Line 2579: p_term_id IN ra_terms.term_id%TYPE,

2575: PROCEDURE discounts_cover(
2576: p_mode IN VARCHAR2,
2577: p_invoice_currency_code IN ar_cash_receipts.currency_code%TYPE,
2578: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2579: p_term_id IN ra_terms.term_id%TYPE,
2580: p_terms_sequence_number IN ar_payment_schedules.terms_sequence_number%TYPE,
2581: p_trx_date IN ar_payment_schedules.trx_date%TYPE,
2582: p_apply_date IN ar_cash_receipts.receipt_date%TYPE,
2583: p_grace_days IN NUMBER,