APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_PARTIES_V

Line 189: from xtr_parties_v

185: where user_id = fnd_user_id;
186: --
187: CURSOR GET_SOB_INFO is
188: select set_of_books_id
189: from xtr_parties_v
190: where party_type = 'C'
191: and party_code = p_company_code;
192: --
193: CURSOR GET_SUSPENSE_CCID is

Line 195: from xtr_parties_v a,

191: and party_code = p_company_code;
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';

Line 1092: from xtr_parties_v pty,

1088: cursor COMPANY_INFO is
1089: select substr(sob.currency_code,1,3),
1090: cp.parameter_value_code, -- replaced pty.conversion_type,
1091: dct.user_conversion_type
1092: from xtr_parties_v pty,
1093: xtr_company_parameters cp,
1094: gl_sets_of_books sob,
1095: gl_daily_conversion_types dct
1096: where pty.party_code = in_company

Line 3315: from xtr_parties_v

3311: l_next_bid NUMBER := NULL;
3312:
3313: Cursor USER_COMPANIES is
3314: Select party_code, set_of_books_id
3315: from xtr_parties_v
3316: where party_type = 'C'
3317: and (party_code = nvl(p_company_code, party_code));
3318:
3319: Cursor BATCHES_BY_BID_RANGE (l_company_code IN VARCHAR2) is

Line 3368: xtr_parties_v pty

3364: cursor c_acctg_period(p_journal_date DATE) is
3365: select period_name
3366: from gl_periods per,
3367: gl_sets_of_books sob,
3368: xtr_parties_v pty
3369: where pty.party_code = l_company_code
3370: and sob.set_of_books_id = pty.set_of_books_id
3371: and sob.period_set_name = per.period_set_name
3372: and sob.accounted_period_type = per.period_type