DBA Data[Home] [Help]

APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on AR_ADJUSTMENTS

Line 96: FROM ar_adjustments

92: BEGIN
93: Errcd := 0;
94: SELECT Sum(Amount)
95: INTO amount_adjusted
96: FROM ar_adjustments
97: WHERE payment_schedule_id = pay_sched_id;
98: EXCEPTION
99: WHEN OTHERS THEN
100: Errcd := SQLCODE;

Line 746: FROM ar_adjustments

742:
743: BEGIN
744: SELECT 1
745: INTO revcode
746: FROM ar_adjustments
747: WHERE payment_schedule_id = ps_rec.applied_payment_schedule_id
748: AND associated_cash_receipt_id = p_cash_receipt_id
749: AND gl_posted_date IS NULL;
750: EXCEPTION

Line 779: PROCEDURE get_adjustment_record(p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,

775: CLOSE pay_sched;
776:
777: END get_interest_reversal_flag;
778:
779: PROCEDURE get_adjustment_record(p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
780: p_user_id IN NUMBER,
781: p_amount IN NUMBER,
782: p_receipt_date IN DATE,
783: p_cash_receipt_id IN NUMBER,