DBA Data[Home] [Help]

APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on FV_FINANCE_CHARGE_CONTROLS_ALL

Line 1383: FROM fv_finance_charge_controls_all

1379:
1380: --1A3 Accruals
1381: BEGIN
1382: SELECT DISTINCT 'x' INTO dummy
1383: FROM fv_finance_charge_controls_all
1384: WHERE set_of_books_id = vp_sob_id
1385: AND charge_type = recs.created_from ;
1386:
1387: amt_accruals := amt_accruals + recs.amount_due_original;

Line 1398: FROM fv_finance_charge_controls_all

1394:
1395: -- 1A9 Interest and Late Charges
1396: BEGIN
1397: SELECT DISTINCT 'x' INTO dummy
1398: FROM fv_finance_charge_controls_all
1399: WHERE set_of_books_id = vp_sob_id
1400: AND charge_type = recs.created_from
1401: AND category<> 'A';
1402:

Line 1419: from fv_finance_charge_controls_all

1415: --1A5 Adjustments
1416:
1417: BEGIN
1418: SELECT distinct 'Y' into fc_flag
1419: from fv_finance_charge_controls_all
1420: where charge_type = adj_recs.created_from;
1421:
1422: EXCEPTION
1423: when no_data_found then

Line 1469: from fv_finance_charge_controls_all

1465: --1A9 Interest and Late Charges
1466:
1467: BEGIN
1468: select distinct 'Y' into fc_flag
1469: from fv_finance_charge_controls_all
1470: where set_of_books_id = vp_sob_id
1471: AND charge_type = recs.created_from
1472: AND category <> 'A';
1473: EXCEPTIOn