APPS.XTR_WRAPPER_API_P dependencies on XTR_PARTY_INFO

Line 369: from XTR_PARTY_INFO xp -- BUG 2811315

365:
366:
367: cursor GET_AUTH_COMPANY is
368: select xp.PARTY_CODE COMPANY_CODE
369: from XTR_PARTY_INFO xp -- BUG 2811315
370: where xp.legal_entity_id = P_ORG_ID -- bug 3862743
371: and xp.authorised = 'Y';
372:
373:

Line 376: from XTR_PARTY_INFO xp

372:
373:
374: cursor GET_COMPANY is
375: select xp.PARTY_CODE COMPANY_CODE
376: from XTR_PARTY_INFO xp
377: where xp.legal_entity_id = P_ORG_ID; -- bug 3862743
378:
379: cursor FIND_AP_ACCT_ID is
380: select ce_bank_account_id from

Line 388: xtr_party_info p

384:
385: Cursor CUR_AUTH_ACCT IS
386: select ce_bank_account_id from
387: xtr_bank_accounts b,
388: xtr_party_info p
389: where b.ce_bank_account_id is not null
390: and ce_bank_account_id = P_ce_bank_account_id
391: and p.party_code = b.party_code
392: and p.party_type = b.party_type

Line 400: xtr_party_info p

396:
397: Cursor CUR_UNAUTH_ACCT IS
398: select ce_bank_account_id,account_number from
399: xtr_bank_accounts b,
400: xtr_party_info p
401: where b.ce_bank_account_id is not null
402: and ce_bank_account_id = P_ce_bank_account_id
403: and p.party_code = b.party_code
404: and p.party_type = b.party_type

Line 515: v_cross_ref XTR_PARTY_INFO.cross_ref_to_other_party%TYPE;

511: new_bal_ledger NUMBER;
512: new_bal_cashflow NUMBER;
513: new_bal_intcalc NUMBER;
514: new_bal_ledger_hce NUMBER;
515: v_cross_ref XTR_PARTY_INFO.cross_ref_to_other_party%TYPE;
516: v_dummy_num NUMBER;
517: int_rate NUMBER;
518: roundfac NUMBER;
519: yr_basis NUMBER;

Line 547: xtr_party_info p

543: --
544: Cursor CUR_ACCT_NO IS
545: select account_number from
546: xtr_bank_accounts b,
547: xtr_party_info p
548: where b.ce_bank_account_id is not null
549: and ce_bank_account_id = P_ce_bank_account_id
550: and p.party_code = b.party_code
551: and p.party_type = b.party_type

Line 611: from XTR_PARTY_INFO xp

607: where PARTY_CODE = l_comp;
608: --
609: cursor GET_COMPANY is
610: select xp.PARTY_CODE COMPANY_CODE
611: from XTR_PARTY_INFO xp
612: where xp.legal_entity_id = P_ORG_ID; -- bug 3862743
613:
614:
615: -- Added for Interest Override

Line 1081: l_company XTR_PARTY_INFO.PARTY_CODE%TYPE;

1077: P_ERROR_MSG OUT NOCOPY VARCHAR2) is
1078:
1079:
1080: l_dummy NUMBER;
1081: l_company XTR_PARTY_INFO.PARTY_CODE%TYPE;
1082: l_auth_flag VARCHAR2(1);
1083: l_acct_no XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
1084: l_dummy_ap_acct NUMBER;
1085:

Line 1098: from XTR_PARTY_INFO xp

1094: and ce_bank_account_id is not null;
1095:
1096: cursor GET_COMPANY is -- (2) To check for valid company ORG_ID
1097: select xp.PARTY_CODE COMPANY_CODE
1098: from XTR_PARTY_INFO xp
1099: where xp.legal_entity_id = P_ORG_ID; -- bug 3862743
1100:
1101:
1102: cursor CHK_USER_ACCESS is -- (3) To check for user access to company

Line 1111: xtr_party_info p

1107: Cursor CHK_AUTH_ACCT IS -- (4) To check for ORG_ID and AP_BANK_ID combination
1108: select b.authorised, -- (5) To check for Authorised Account
1109: b.account_number
1110: from xtr_bank_accounts b,
1111: xtr_party_info p
1112: where b.ce_bank_account_id = P_ce_bank_account_id
1113: and b.ce_bank_account_id is not null
1114: and b.currency = P_CURRENCY
1115: and p.party_code = b.party_code

Line 1887: from XTR_PARTY_INFO

1883: -------------------------------------------------------------------------------------------------------------------
1884: FUNCTION A_COMP (l_comp IN VARCHAR2) return boolean is
1885: cursor cur_com is
1886: select 1
1887: from XTR_PARTY_INFO
1888: where party_code = l_comp
1889: and party_type = 'C';
1890: l_dummy NUMBER;
1891: BEGIN