APPS.XTR_WRAPPER_API_P dependencies on XTR_PARTY_INFO

Line 170: from XTR_PARTY_INFO xp -- BUG 2811315

166:
167:
168: cursor GET_AUTH_COMPANY is
169: select xp.PARTY_CODE COMPANY_CODE
170: from XTR_PARTY_INFO xp -- BUG 2811315
171: where xp.legal_entity_id = P_ORG_ID -- bug 3862743
172: and xp.authorised = 'Y';
173:
174:

Line 177: from XTR_PARTY_INFO xp

173:
174:
175: cursor GET_COMPANY is
176: select xp.PARTY_CODE COMPANY_CODE
177: from XTR_PARTY_INFO xp
178: where xp.legal_entity_id = P_ORG_ID; -- bug 3862743
179:
180: cursor FIND_AP_ACCT_ID is
181: select ce_bank_account_id from

Line 189: xtr_party_info p

185:
186: Cursor CUR_AUTH_ACCT IS
187: select ce_bank_account_id from
188: xtr_bank_accounts b,
189: xtr_party_info p
190: where b.ce_bank_account_id is not null
191: and ce_bank_account_id = P_ce_bank_account_id
192: and p.party_code = b.party_code
193: and p.party_type = b.party_type

Line 201: xtr_party_info p

197:
198: Cursor CUR_UNAUTH_ACCT IS
199: select ce_bank_account_id,account_number from
200: xtr_bank_accounts b,
201: xtr_party_info p
202: where b.ce_bank_account_id is not null
203: and ce_bank_account_id = P_ce_bank_account_id
204: and p.party_code = b.party_code
205: and p.party_type = b.party_type

Line 316: v_cross_ref XTR_PARTY_INFO.cross_ref_to_other_party%TYPE;

312: new_bal_ledger NUMBER;
313: new_bal_cashflow NUMBER;
314: new_bal_intcalc NUMBER;
315: new_bal_ledger_hce NUMBER;
316: v_cross_ref XTR_PARTY_INFO.cross_ref_to_other_party%TYPE;
317: v_dummy_num NUMBER;
318: int_rate NUMBER;
319: roundfac NUMBER;
320: yr_basis NUMBER;

Line 348: xtr_party_info p

344: --
345: Cursor CUR_ACCT_NO IS
346: select account_number from
347: xtr_bank_accounts b,
348: xtr_party_info p
349: where b.ce_bank_account_id is not null
350: and ce_bank_account_id = P_ce_bank_account_id
351: and p.party_code = b.party_code
352: and p.party_type = b.party_type

Line 412: from XTR_PARTY_INFO xp

408: where PARTY_CODE = l_comp;
409: --
410: cursor GET_COMPANY is
411: select xp.PARTY_CODE COMPANY_CODE
412: from XTR_PARTY_INFO xp
413: where xp.legal_entity_id = P_ORG_ID; -- bug 3862743
414:
415:
416: -- Added for Interest Override

Line 847: l_company XTR_PARTY_INFO.PARTY_CODE%TYPE;

843: P_ERROR_MSG OUT NOCOPY VARCHAR2) is
844:
845:
846: l_dummy NUMBER;
847: l_company XTR_PARTY_INFO.PARTY_CODE%TYPE;
848: l_auth_flag VARCHAR2(1);
849: l_acct_no XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
850: l_dummy_ap_acct NUMBER;
851:

Line 864: from XTR_PARTY_INFO xp

860: and ce_bank_account_id is not null;
861:
862: cursor GET_COMPANY is -- (2) To check for valid company ORG_ID
863: select xp.PARTY_CODE COMPANY_CODE
864: from XTR_PARTY_INFO xp
865: where xp.legal_entity_id = P_ORG_ID; -- bug 3862743
866:
867:
868: cursor CHK_USER_ACCESS is -- (3) To check for user access to company

Line 877: xtr_party_info p

873: Cursor CHK_AUTH_ACCT IS -- (4) To check for ORG_ID and AP_BANK_ID combination
874: select b.authorised, -- (5) To check for Authorised Account
875: b.account_number
876: from xtr_bank_accounts b,
877: xtr_party_info p
878: where b.ce_bank_account_id = P_ce_bank_account_id
879: and b.ce_bank_account_id is not null
880: and b.currency = P_CURRENCY
881: and p.party_code = b.party_code

Line 1653: from XTR_PARTY_INFO

1649: -------------------------------------------------------------------------------------------------------------------
1650: FUNCTION A_COMP (l_comp IN VARCHAR2) return boolean is
1651: cursor cur_com is
1652: select 1
1653: from XTR_PARTY_INFO
1654: where party_code = l_comp
1655: and party_type = 'C';
1656: l_dummy NUMBER;
1657: BEGIN