APPS.FV_LOCKBOX_FC_PKG dependencies on FV_FINANCE_CHARGE_CONTROLS

Line 18: v_priority fv_finance_charge_controls.priority%TYPE;

14: v_invoice_id ra_customer_trx.customer_trx_id%TYPE;
15: v_temp_id fv_lockbox_ipa_temp.temp_id%TYPE;
16: v_debit_memo_id ra_customer_trx.customer_trx_id%TYPE;
17: v_amount ar_payment_schedules.amount_due_remaining%TYPE;
18: v_priority fv_finance_charge_controls.priority%TYPE;
19: v_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
20: v_appl_inv_id ra_customer_trx.customer_trx_id%TYPE;
21: v_appl_inv_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
22: v_sold_to_customer ar_interim_cash_rcpt_lines_all.sold_to_customer%TYPE;

Line 82: fv_finance_charge_controls fcc

78: fcc.priority,
79: aps.payment_schedule_id
80: from ra_customer_trx rct,
81: ar_payment_schedules aps,
82: fv_finance_charge_controls fcc
83: where rct.related_customer_trx_id = cv_invoice_id
84: and aps.customer_trx_id = rct.customer_trx_id
85: and rct.interface_header_attribute3 = fcc.charge_type
86: and rct.set_of_books_id = fcc.set_of_books_id

Line 97: fv_finance_charge_controls fcc

93: aicr.customer_trx_id,
94: aicr.payment_schedule_id
95: from ar_interim_cash_receipts aicr,
96: ra_customer_trx rct,
97: fv_finance_charge_controls fcc
98: where aicr.batch_id = cv_batch_id
99: and aicr.customer_trx_id is not null
100: and aicr.customer_trx_id = rct.customer_trx_id
101: and rct.interface_header_attribute3 = fcc.charge_type

Line 110: fv_finance_charge_controls fcc

106: aicrl.customer_trx_id,
107: aicrl.payment_schedule_id
108: from ar_interim_cash_rcpt_lines_all aicrl,
109: ra_customer_trx rct,
110: fv_finance_charge_controls fcc
111: where aicrl.batch_id = cv_batch_id
112: and aicrl.customer_trx_id is not null
113: and aicrl.customer_trx_id = rct.customer_trx_id
114: and rct.interface_header_attribute3 = fcc.charge_type