APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_COMPANY_PARAMETERS

Line 88: l_param_value XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := NULL;

84: ----------------------------------------------------------------------------- */
85:
86: FUNCTION GET_CLOSED_PERIOD_PARAM (in_company in varchar2) RETURN VARCHAR2 IS
87:
88: l_param_value XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := NULL;
89:
90: Begin
91: Select parameter_value_code into l_param_value
92: from xtr_company_parameters

Line 92: from xtr_company_parameters

88: l_param_value XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := NULL;
89:
90: Begin
91: Select parameter_value_code into l_param_value
92: from xtr_company_parameters
93: where company_code = in_company
94: and parameter_code = 'ACCNT_CLPER';
95:
96: Return (l_param_value);

Line 196: xtr_company_parameters b

192: --
193: CURSOR GET_SUSPENSE_CCID is
194: select parameter_value_code -- replaced a.suspense_ccid
195: from xtr_parties_v a,
196: xtr_company_parameters b
197: where a.party_code = p_company_code
198: and a.party_code = b.company_code
199: and b.parameter_code = 'ACCNT_SUSAC';
200: --

Line 1094: xtr_company_parameters cp,

1090: select substr(sob.currency_code,1,3),
1091: cp.parameter_value_code, -- replaced pty.conversion_type,
1092: dct.user_conversion_type
1093: from xtr_parties_v pty,
1094: xtr_company_parameters cp,
1095: gl_sets_of_books sob,
1096: gl_daily_conversion_types dct
1097: where pty.party_code = in_company
1098: and cp.company_code = pty.party_code

Line 3307: l_closed_param_code XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE;

3303: l_errbuf VARCHAR2(255) := NULL;
3304: l_retcode NUMBER := 0;
3305: l_sub_errbuf VARCHAR2(255) := NULL;
3306: l_sub_retcode NUMBER := 0;
3307: l_closed_param_code XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE;
3308: l_company_code XTR_PARTY_INFO.party_code%TYPE;
3309: l_sob_id XTR_PARTY_INFO.set_of_books_id%TYPE;
3310: l_cutoff_date DATE := NULL;
3311: l_next_open_start DATE := NULL;