APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_SYSTEM_PARAMETERS

Line 104: g_ar_system_parameters VARCHAR2(40) DEFAULT NULL;

100: INDEX BY BINARY_INTEGER;
101:
102: TYPE ref_cur IS REF CURSOR;
103:
104: g_ar_system_parameters VARCHAR2(40) DEFAULT NULL;
105: g_ar_system_parameters_all VARCHAR2(40) DEFAULT NULL;
106: g_ar_adjustments VARCHAR2(40) DEFAULT NULL;
107: g_ar_adjustments_all VARCHAR2(40) DEFAULT NULL;
108: g_ar_cash_receipt_history VARCHAR2(40) DEFAULT NULL;

Line 105: g_ar_system_parameters_all VARCHAR2(40) DEFAULT NULL;

101:
102: TYPE ref_cur IS REF CURSOR;
103:
104: g_ar_system_parameters VARCHAR2(40) DEFAULT NULL;
105: g_ar_system_parameters_all VARCHAR2(40) DEFAULT NULL;
106: g_ar_adjustments VARCHAR2(40) DEFAULT NULL;
107: g_ar_adjustments_all VARCHAR2(40) DEFAULT NULL;
108: g_ar_cash_receipt_history VARCHAR2(40) DEFAULT NULL;
109: g_ar_cash_receipt_history_all VARCHAR2(40) DEFAULT NULL;

Line 264: ar_system_parameters sys

260: AND segment_attribute_type = 'GL_ACCOUNT'
261: AND id_flex_num in
262: (SELECT chart_of_accounts_id
263: FROM gl_sets_of_books sob,
264: ar_system_parameters sys
265: WHERE sob.set_of_books_id = sys.set_of_books_id);
266:
267: BEGIN
268:

Line 1377: FROM ar_system_parameters

1373: AND end_date <= p_gl_as_of_date
1374: AND EXISTS
1375: (
1376: SELECT set_of_books_id
1377: FROM ar_system_parameters
1378: )
1379: AND NOT EXISTS
1380: (
1381: SELECT 'x'

Line 1495: from ar_system_parameters;

1491: WHERE set_of_books_id = p_set_of_books_id;
1492:
1493: CURSOR system_options IS
1494: select set_of_books_id
1495: from ar_system_parameters;
1496:
1497: BEGIN
1498:
1499: debug('ar_cumulative_balance_report.init(+)');

Line 1523: g_ar_system_parameters := 'ar_system_parameters sys';

1519: END IF;
1520:
1521: IF upper(l_mrc_sob_type_code) = 'P' THEN
1522:
1523: g_ar_system_parameters := 'ar_system_parameters sys';
1524: g_ar_system_parameters_all := 'ar_system_parameters_all sys';
1525: g_ar_adjustments := 'ar_adjustments adj';
1526: g_ar_adjustments_all := 'ar_adjustments_all adj';
1527: g_ar_cash_receipt_history := 'ar_cash_receipt_history crh';

Line 1524: g_ar_system_parameters_all := 'ar_system_parameters_all sys';

1520:
1521: IF upper(l_mrc_sob_type_code) = 'P' THEN
1522:
1523: g_ar_system_parameters := 'ar_system_parameters sys';
1524: g_ar_system_parameters_all := 'ar_system_parameters_all sys';
1525: g_ar_adjustments := 'ar_adjustments adj';
1526: g_ar_adjustments_all := 'ar_adjustments_all adj';
1527: g_ar_cash_receipt_history := 'ar_cash_receipt_history crh';
1528: g_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all crh';

Line 1557: g_ar_system_parameters := 'ar_system_parameters_mrc_v sys';

1553: g_ar_transaction_history_all := 'ar_transaction_history_all br';
1554:
1555: ELSE
1556:
1557: g_ar_system_parameters := 'ar_system_parameters_mrc_v sys';
1558: g_ar_system_parameters_all := 'ar_system_parameters_all_mrc_v sys';
1559: g_ar_adjustments := 'ar_adjustments_mrc_v adj';
1560: g_ar_adjustments_all := 'ar_adjustments_all_mrc_v adj';
1561: g_ar_cash_receipt_history := 'ar_cash_receipt_hist_mrc_v crh';

Line 1558: g_ar_system_parameters_all := 'ar_system_parameters_all_mrc_v sys';

1554:
1555: ELSE
1556:
1557: g_ar_system_parameters := 'ar_system_parameters_mrc_v sys';
1558: g_ar_system_parameters_all := 'ar_system_parameters_all_mrc_v sys';
1559: g_ar_adjustments := 'ar_adjustments_mrc_v adj';
1560: g_ar_adjustments_all := 'ar_adjustments_all_mrc_v adj';
1561: g_ar_cash_receipt_history := 'ar_cash_receipt_hist_mrc_v crh';
1562: g_ar_cash_receipt_history_all := 'ar_cash_receipt_hist_all_mrc_v crh';

Line 1704: ar_system_parameters_all sysparam,

1700: l_functional_currency,
1701: l_chart_of_accounts_id,
1702: l_organization
1703: FROM gl_sets_of_books sob,
1704: ar_system_parameters_all sysparam,
1705: hr_organization_units hou
1706: WHERE sob.set_of_books_id = sysparam.set_of_books_id
1707: AND hou.organization_id = sysparam.org_id
1708: AND sysparam.org_id = p_reporting_entity_id;