DBA Data[Home] [Help]

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