APPS.XTR_WRAPPER_API_P dependencies on XTR_BANK_ACCOUNTS

Line 381: xtr_bank_accounts

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
381: xtr_bank_accounts
382: where ce_bank_account_id = P_ce_bank_account_id
383: and ce_bank_account_id is not null;
384:
385: Cursor CUR_AUTH_ACCT IS

Line 387: xtr_bank_accounts b,

383: and ce_bank_account_id is not null;
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

Line 399: xtr_bank_accounts b,

395: and b.authorised = 'Y';
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

Line 546: xtr_bank_accounts b,

542:
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

Line 562: from XTR_BANK_ACCOUNTS

558: select
559: PARTY_CODE,CURRENCY,SETOFF,PORTFOLIO_CODE,BANK_CODE,nvl(YEAR_CALC_TYPE,'ACTUAL/ACTUAL')
560: YEAR_CALC_TYPE
561: ,rounding_type, day_count_type -- Added for Interest Override
562: from XTR_BANK_ACCOUNTS
563: where ACCOUNT_NUMBER = acct_no
564: and PARTY_CODE = new_company;
565: --
566: cursor PREV_DETAILS is

Line 947: xtr_bank_balances bb,xtr_bank_accounts ba,

943: --bug 7631275 starts
944: /*cursor cur_reval_insbal IS
945: SELECT max(period_to)
946: FROM
947: xtr_bank_balances bb,xtr_bank_accounts ba,
948: xtr_deal_date_amounts dd,xtr_revaluation_details rd
949: WHERE
950: bb.company_code = p_company_code
951: AND bb.account_number = p_account_number

Line 963: xtr_bank_accounts ba,

959:
960: cursor cur_reval_insbal IS
961: select max(period_to)
962: FROM
963: xtr_bank_accounts ba,
964: xtr_deal_date_amounts dd,
965: xtr_revaluation_details rd
966: WHERE ba.currency = p_currency_code
967: AND ba.currency = dd.currency

Line 980: xtr_bank_balances bb,xtr_bank_accounts ba,

976:
977: /*cursor cur_accrl_insbal IS
978: SELECT max(period_to)
979: FROM
980: xtr_bank_balances bb,xtr_bank_accounts ba,
981: xtr_deal_date_amounts dd,xtr_accrls_amort aa
982: WHERE
983: bb.company_code = p_company_code
984: AND bb.account_number = p_account_number

Line 996: xtr_bank_accounts ba,

992:
993: cursor cur_accrl_insbal IS
994: select max(period_to)
995: FROM
996: xtr_bank_accounts ba,
997: xtr_deal_date_amounts dd,
998: xtr_accrls_amort aa
999: WHERE ba.currency = p_currency_code
1000: AND ba.currency = dd.currency

Line 1072: -- account_number in XTR_BANK_ACCOUNTS

1068: -- org_id of the company for 'Shared'
1069: P_ce_bank_account_id IN NUMBER,
1070: -- ce_bank_account_id for 'Shared or 'AP-only'
1071: P_ACCOUNT_NUMBER IN VARCHAR2,
1072: -- account_number in XTR_BANK_ACCOUNTS
1073: P_CURRENCY IN VARCHAR2,-- currency of transaction
1074: P_BANK_ACCOUNT_ID OUT NOCOPY NUMBER,
1075: --ap_bank_account_id 'Shared' or dummy_bank_account_id 'XTRonly'
1076: P_RESULT OUT NOCOPY VARCHAR2,-- 'PASS' or 'FAIL'

Line 1083: l_acct_no XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

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:
1086: /*-----------------------------------------------------------------------------------*/
1087: /* To check for ORG_ID and AP_BANK_ACCOUNT_ID combination */

Line 1092: from xtr_bank_accounts

1088: /*-----------------------------------------------------------------------------------*/
1089:
1090: cursor FIND_AP_ACCT_ID is -- (1) To check for 'Shared' with this P_AP_BANK_ACCOUNT_ID
1091: select 1
1092: from xtr_bank_accounts
1093: where ce_bank_account_id = P_ce_bank_account_id
1094: and ce_bank_account_id is not null;
1095:
1096: cursor GET_COMPANY is -- (2) To check for valid company ORG_ID

Line 1110: from xtr_bank_accounts b,

1106:
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

Line 1126: from xtr_bank_accounts

1122: Cursor CHK_UNIQUE_ACCT IS -- (a) To check for a single authorised account
1123: select authorised,
1124: party_code,
1125: ce_bank_account_id
1126: from xtr_bank_accounts
1127: where account_number = P_ACCOUNT_NUMBER
1128: and currency = P_CURRENCY
1129: order by authorised desc; -- so 'Y' comes before 'N'
1130:

Line 1952: from xtr_bank_accounts

1948: and party_code = l_intercomp_code;
1949:
1950: cursor get_acct_no (l_bank_id NUMBER, l_ccy VARCHAR2, l_party VARCHAR2) is
1951: select account_number
1952: from xtr_bank_accounts
1953: where party_code = l_party
1954: and currency = l_ccy
1955: and ce_bank_account_id = l_bank_id;
1956:

Line 2024: from xtr_bank_accounts

2020: and product_type is null; -- Condition added Bug 4309871
2021:
2022: cursor get_acct_no (l_bank_id NUMBER, l_ccy VARCHAR2, l_party VARCHAR2) is
2023: select account_number
2024: from xtr_bank_accounts
2025: where party_code = l_party
2026: and currency = l_ccy
2027: and ce_bank_account_id = l_bank_id;
2028:

Line 2029: l_ccy xtr_bank_accounts.currency%TYPE;

2025: where party_code = l_party
2026: and currency = l_ccy
2027: and ce_bank_account_id = l_bank_id;
2028:
2029: l_ccy xtr_bank_accounts.currency%TYPE;
2030:
2031: BEGIN
2032: open get_company (p_cash_pool_id);
2033: fetch get_company into p_company_code, p_currency;