APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_SYSTEM_PARAMETERS_ALL

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 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 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;