APPS.FV_1099_TRANSACTION dependencies on AR_ADJUSTMENTS

Line 30: v_apply_date ar_adjustments.apply_date%TYPE;

26: v_country hz_locations.country%TYPE;
27: v_trx_number ra_customer_trx.trx_number%TYPE;
28: v_process_inv_id ra_customer_trx.customer_trx_id%TYPE;
29: v_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
30: v_apply_date ar_adjustments.apply_date%TYPE;
31: v_debit_memo_sum number;
32: v_begin_date date;
33: v_end_date date;
34: v_org_id number;

Line 42: from ar_adjustments

38: v_sob_name varchar2(30);
39:
40: CURSOR debit_memos_c IS
41: select nvl(sum(nvl(amount,0)),0)
42: from ar_adjustments
43: where customer_trx_id in (select customer_trx_id
44: from ra_customer_trx,
45: fv_finance_charge_controls fcc
46: where related_customer_trx_id = v_process_inv_id

Line 61: from ar_adjustments aa,

57: CURSOR all_adjustments_c(p_sob_id number) IS
58: select nvl(sum(nvl(amount,0)),0) sum_adjustments,
59: nvl(related_customer_trx_id, aa.customer_trx_id) id,
60: bill_to_customer_id
61: from ar_adjustments aa,
62: ra_customer_trx rct
63: where (aa.customer_trx_id = rct.customer_trx_id
64: or aa.customer_trx_id in (select customer_trx_id
65: from ra_customer_trx

Line 208: FROM ar_adjustments

204: BEGIN
205:
206: SELECT max(apply_date)
207: INTO v_apply_date
208: FROM ar_adjustments
209: WHERE customer_trx_id = v_process_inv_id;
210:
211: IF v_apply_date is null THEN
212: -- there are only adjustments for a finance charge(s), find

Line 220: FROM ar_adjustments

216: -- invoice only the fc record.)
217: BEGIN
218: SELECT max(apply_date)
219: INTO v_apply_date
220: FROM ar_adjustments
221: WHERE customer_trx_id in (select customer_trx_id
222: from ra_customer_trx
223: where related_customer_trx_id =
224: v_process_inv_id)