APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on AR_PAYMENT_SCHEDULES

Line 64: amount_due_original ar_payment_schedules.amount_due_original%type;

60: trx_line_gl_dist_rev_s number;
61: payment_schedules_s number;
62: rev_ccid number;
63: rec_ccid number;
64: amount_due_original ar_payment_schedules.amount_due_original%type;
65: amount_due_remaining ar_payment_schedules.amount_due_remaining%type;
66: schedule_id number;
67: rec_trx_id number;
68: adjust_ccid number;

Line 65: amount_due_remaining ar_payment_schedules.amount_due_remaining%type;

61: payment_schedules_s number;
62: rev_ccid number;
63: rec_ccid number;
64: amount_due_original ar_payment_schedules.amount_due_original%type;
65: amount_due_remaining ar_payment_schedules.amount_due_remaining%type;
66: schedule_id number;
67: rec_trx_id number;
68: adjust_ccid number;
69: existing_trx_id number;

Line 171: from ar_payment_schedules aps,

167: aps.trx_date --Added for Bug 3018578
168: -- Added extra column to get the Trx_date(invoice_data) March 30, 1999 BG
169: -- rct.trx_date
170: -- bug 992498 commented out rct.trx_date
171: from ar_payment_schedules aps,
172: fv_invoice_finance_chrgs fifc,
173: fv_finance_charge_controls fcc,
174: fv_finance_charge_history fch,
175: ra_customer_trx rct,

Line 207: from ar_payment_schedules aps,

203: where last_accrual_date = trunc(sysdate);
204:
205: cursor c_last_run_sob(cv_sob_id fv_ar_controls.payment_schedule_id%TYPE) is
206: select fac.last_accrual_date
207: from ar_payment_schedules aps,
208: fv_ar_controls fac,
209: ra_customer_trx rct
210: where aps.payment_schedule_id = fac.payment_schedule_id
211: and rct.customer_trx_id = aps.customer_trx_id

Line 266: from ar_payment_schedules

262: ct_id := customer_trx_id;
263:
264: select sum(amount_due_remaining)
265: into amt_due
266: from ar_payment_schedules
267: where customer_trx_id = ct_id
268: and class = 'INV';
269:
270: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 616: from ar_payment_schedules

612: v_customer_trx_id := customer_trx_id;
613:
614: select count(*)
615: into v_pay_schedule_cnt
616: from ar_payment_schedules
617: where customer_trx_id = v_customer_trx_id;
618:
619: IF v_pay_schedule_cnt > 1 THEN
620: -- this is a split term

Line 1040: existing_pay_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

1036:
1037: procedure adjust_existing_dm(dollars in number) is
1038: l_module_name VARCHAR2(200) ;
1039:
1040: existing_pay_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
1041: dt_exists varchar2(1);
1042: v_adjustment_number_o number;
1043: v_adjustment_id_o number;
1044: v_adjustment_number number;

Line 1093: from ar_payment_schedules

1089: statement_no := 'A.A';
1090:
1091: select payment_schedule_id
1092: into existing_pay_schedule_id
1093: from ar_payment_schedules
1094: where customer_trx_id = existing_trx_id
1095: and class = 'DM';
1096: -- finding the payment_schedule_id for the existing dm.
1097: