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 1093: from xtr_parties_v pty,

1089: cursor COMPANY_INFO is
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

Line 3316: from xtr_parties_v

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

Line 3369: xtr_parties_v pty

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