APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on FV_FINANCE_CHARGE_CONTROLS

Line 27: charge_type fv_finance_charge_controls.charge_type%TYPE,

23: TYPE out_rec IS RECORD
24: (
25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,
26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
30: amount_due_original ar_payment_schedules.amount_due_original%TYPE,
31: due_date ar_payment_schedules.due_date%TYPE,

Line 283: p_interval IN fv_finance_charge_controls.accrual_interval%TYPE,

279: p_last_date IN DATE,
280: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
281: p_amount_due_remaining IN OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
282: p_rate_amount IN NUMBER,
283: p_interval IN fv_finance_charge_controls.accrual_interval%TYPE,
284: p_charges OUT NOCOPY NUMBER,
285: p_errbuf OUT NOCOPY VARCHAR2,
286: p_retcode OUT NOCOPY NUMBER
287: )

Line 379: p_interval IN fv_finance_charge_controls.accrual_interval%type,

375:
376: PROCEDURE missed_intervals
377: (
378: p_accrue_as_of_date IN DATE,
379: p_interval IN fv_finance_charge_controls.accrual_interval%type,
380: p_last_accrual_date IN DATE,
381: p_first_late_day IN OUT NOCOPY DATE,
382: p_number_of_periods OUT NOCOPY NUMBER,
383: p_errbuf OUT NOCOPY VARCHAR2,

Line 1586: l_old_charge_id fv_finance_charge_controls.charge_id%TYPE;

1582: l_module_name VARCHAR2(200);
1583: l_location VARCHAR2(200);
1584: l_message VARCHAR2(1024);
1585: l_gl_date DATE;
1586: l_old_charge_id fv_finance_charge_controls.charge_id%TYPE;
1587: l_old_invoice_id ra_customer_trx.customer_trx_id%TYPE;
1588: l_accrue_as_of_date DATE;
1589: l_accrual_date DATE;
1590: l_finance_charges NUMBER;

Line 1691: fv_finance_charge_controls fcc,

1687: NVL(fcc.prorate_charge, 'N') prorate_charge,
1688: fcc.invoice_suffix
1689: FROM ar_payment_schedules aps,
1690: fv_invoice_finance_chrgs fifc,
1691: fv_finance_charge_controls fcc,
1692: fv_finance_charge_history fch,
1693: ra_customer_trx rct,
1694: ra_cust_trx_types rctt,
1695: hz_cust_site_uses_all rsua,

Line 1704: FROM fv_finance_charge_controls)*/

1700: AND aps.status <> 'CL'
1701: AND aps.customer_trx_id = rct.customer_trx_id
1702:
1703: /* AND nvl(rct.interface_header_attribute3,'XX') NOT IN (SELECT charge_type
1704: FROM fv_finance_charge_controls)*/
1705:
1706: AND rct.set_of_books_id = g_set_of_books_id
1707: --bug 9716140
1708: AND (rct.related_customer_trx_id IS NULL OR

Line 2087: fv_finance_charge_controls fcc

2083: CURSOR c1 (c_ledger_id NUMBER) IS
2084: SELECT DISTINCT hzca.cust_Account_id customer_id,
2085: hzca.customer_class_code cust_class_code
2086: FROM hz_cust_accounts hzca,
2087: fv_finance_charge_controls fcc
2088: WHERE fcc.enabled_flag = 'Y'
2089: AND fcc.set_of_books_id = c_ledger_id
2090: AND hzca.status = 'A'
2091: AND EXISTS (SELECT 'x'

Line 2246: fv_finance_charge_controls fcc,

2242: DELETE FROM fv_cust_finance_chrgs WHERE
2243: customer_id IN
2244: (SELECT hzca.cust_account_id
2245: FROM hz_cust_accounts hzca,
2246: fv_finance_charge_controls fcc,
2247: fv_finance_chrg_cust_classes fccc,
2248: fv_finance_charge_grp_dtls fcgd,
2249: fv_finance_charge_grp_hdrs fcgh
2250: WHERE fcc.enabled_flag = 'Y'

Line 2312: fv_finance_charge_controls fcc,

2308: fcgh.finance_charge_group_hdr_id,
2309: fcgd.base_charge_id,
2310: g_request_id
2311: FROM hz_cust_accounts hzca,
2312: fv_finance_charge_controls fcc,
2313: fv_finance_chrg_cust_classes fccc,
2314: fv_finance_charge_grp_dtls fcgd,
2315: fv_finance_charge_grp_hdrs fcgh
2316: WHERE fcc.enabled_flag = 'Y'

Line 2408: FROM fv_finance_charge_controls

2404: WHERE description = 'Accrue Federal Finance Charges'
2405: AND ral.customer_trx_id = ract.customer_trx_id )))
2406:
2407: /* AND NVL(ract.interface_header_attribute3,'XX') NOT IN (SELECT charge_type
2408: FROM fv_finance_charge_controls
2409: WHERE set_of_books_id = g_set_of_books_id)*/
2410:
2411: AND EXISTS (SELECT 'x'
2412: FROM fv_cust_finance_chrgs fcfc

Line 2466: fv_finance_charge_controls fcc,

2462: fcgd.finance_charge_group_dtl_id,
2463: 'Y'
2464: FROM ra_customer_trx ract,
2465: fv_cust_finance_chrgs fcfc,
2466: fv_finance_charge_controls fcc,
2467: ra_cust_trx_types rctt,
2468: fv_finance_charge_grp_dtls fcgd,
2469: fv_finance_charge_grp_hdrs fcgh
2470: WHERE ract.bill_to_customer_id = fcfc.customer_id

Line 2492: FROM fv_finance_charge_controls

2488: AND fcgd.base_charge_id = 0
2489: AND fcgh.ledger_id = g_set_of_books_id
2490:
2491: /* AND NVL(ract.interface_header_attribute3,'XX') NOT IN (SELECT charge_type
2492: FROM fv_finance_charge_controls
2493: WHERE set_of_books_id = g_set_of_books_id)*/
2494:
2495: AND NOT EXISTS (SELECT 'x'
2496: FROM fv_invoice_finance_chrgs fifc