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 238: ar_system_parameters sys

234: AND segment_attribute_type = 'GL_ACCOUNT'
235: AND id_flex_num in
236: (SELECT chart_of_accounts_id
237: FROM gl_sets_of_books sob,
238: ar_system_parameters sys
239: WHERE sob.set_of_books_id = sys.set_of_books_id);
240:
241: BEGIN
242:

Line 1348: FROM ar_system_parameters

1344: AND end_date <= p_gl_as_of_date
1345: AND EXISTS
1346: (
1347: SELECT set_of_books_id
1348: FROM ar_system_parameters
1349: )
1350: AND NOT EXISTS
1351: (
1352: SELECT 'x'

Line 1466: from ar_system_parameters;

1462: WHERE set_of_books_id = p_set_of_books_id;
1463:
1464: CURSOR system_options IS
1465: select set_of_books_id
1466: from ar_system_parameters;
1467:
1468: BEGIN
1469:
1470: debug('ar_cumulative_balance_report.init(+)');

Line 1494: g_ar_system_parameters := 'ar_system_parameters sys';

1490: END IF;
1491:
1492: IF upper(l_mrc_sob_type_code) = 'P' THEN
1493:
1494: g_ar_system_parameters := 'ar_system_parameters sys';
1495: g_ar_system_parameters_all := 'ar_system_parameters_all sys';
1496: g_ar_adjustments := 'ar_adjustments adj';
1497: g_ar_adjustments_all := 'ar_adjustments_all adj';
1498: g_ar_cash_receipt_history := 'ar_cash_receipt_history crh';

Line 1495: g_ar_system_parameters_all := 'ar_system_parameters_all sys';

1491:
1492: IF upper(l_mrc_sob_type_code) = 'P' THEN
1493:
1494: g_ar_system_parameters := 'ar_system_parameters sys';
1495: g_ar_system_parameters_all := 'ar_system_parameters_all sys';
1496: g_ar_adjustments := 'ar_adjustments adj';
1497: g_ar_adjustments_all := 'ar_adjustments_all adj';
1498: g_ar_cash_receipt_history := 'ar_cash_receipt_history crh';
1499: g_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all crh';

Line 1528: g_ar_system_parameters := 'ar_system_parameters_mrc_v sys';

1524: g_ar_transaction_history_all := 'ar_transaction_history_all br';
1525:
1526: ELSE
1527:
1528: g_ar_system_parameters := 'ar_system_parameters_mrc_v sys';
1529: g_ar_system_parameters_all := 'ar_system_parameters_all_mrc_v sys';
1530: g_ar_adjustments := 'ar_adjustments_mrc_v adj';
1531: g_ar_adjustments_all := 'ar_adjustments_all_mrc_v adj';
1532: g_ar_cash_receipt_history := 'ar_cash_receipt_hist_mrc_v crh';

Line 1529: g_ar_system_parameters_all := 'ar_system_parameters_all_mrc_v sys';

1525:
1526: ELSE
1527:
1528: g_ar_system_parameters := 'ar_system_parameters_mrc_v sys';
1529: g_ar_system_parameters_all := 'ar_system_parameters_all_mrc_v sys';
1530: g_ar_adjustments := 'ar_adjustments_mrc_v adj';
1531: g_ar_adjustments_all := 'ar_adjustments_all_mrc_v adj';
1532: g_ar_cash_receipt_history := 'ar_cash_receipt_hist_mrc_v crh';
1533: g_ar_cash_receipt_history_all := 'ar_cash_receipt_hist_all_mrc_v crh';

Line 1675: ar_system_parameters_all sysparam,

1671: l_functional_currency,
1672: l_chart_of_accounts_id,
1673: l_organization
1674: FROM gl_sets_of_books sob,
1675: ar_system_parameters_all sysparam,
1676: hr_organization_units hou
1677: WHERE sob.set_of_books_id = sysparam.set_of_books_id
1678: AND hou.organization_id = sysparam.org_id
1679: AND sysparam.org_id = p_reporting_entity_id;