eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_WRAPPER_API_P dependencies on XTR_BANK_ACCOUNTS

Line 182: xtr_bank_accounts

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
182: xtr_bank_accounts
183: where ce_bank_account_id = P_ce_bank_account_id
184: and ce_bank_account_id is not null;
185:
186: Cursor CUR_AUTH_ACCT IS

Line 188: xtr_bank_accounts b,

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

Line 200: xtr_bank_accounts b,

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

Line 347: xtr_bank_accounts b,

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

Line 363: from XTR_BANK_ACCOUNTS

359: select
360: PARTY_CODE,CURRENCY,SETOFF,PORTFOLIO_CODE,BANK_CODE,nvl(YEAR_CALC_TYPE,'ACTUAL/ACTUAL')
361: YEAR_CALC_TYPE
362: ,rounding_type, day_count_type -- Added for Interest Override
363: from XTR_BANK_ACCOUNTS
364: where ACCOUNT_NUMBER = acct_no
365: and PARTY_CODE = new_company;
366: --
367: cursor PREV_DETAILS is

Line 748: xtr_bank_balances bb,xtr_bank_accounts ba,

744:
745: cursor cur_reval_insbal IS
746: SELECT max(period_to)
747: FROM
748: xtr_bank_balances bb,xtr_bank_accounts ba,
749: xtr_deal_date_amounts dd,xtr_revaluation_details rd
750: WHERE
751: bb.company_code = p_company_code
752: AND bb.account_number = p_account_number

Line 764: xtr_bank_balances bb,xtr_bank_accounts ba,

760:
761: cursor cur_accrl_insbal IS
762: SELECT max(period_to)
763: FROM
764: xtr_bank_balances bb,xtr_bank_accounts ba,
765: xtr_deal_date_amounts dd,xtr_accrls_amort aa
766: WHERE
767: bb.company_code = p_company_code
768: AND bb.account_number = p_account_number

Line 838: -- account_number in XTR_BANK_ACCOUNTS

834: -- org_id of the company for 'Shared'
835: P_ce_bank_account_id IN NUMBER,
836: -- ce_bank_account_id for 'Shared or 'AP-only'
837: P_ACCOUNT_NUMBER IN VARCHAR2,
838: -- account_number in XTR_BANK_ACCOUNTS
839: P_CURRENCY IN VARCHAR2,-- currency of transaction
840: P_BANK_ACCOUNT_ID OUT NOCOPY NUMBER,
841: --ap_bank_account_id 'Shared' or dummy_bank_account_id 'XTRonly'
842: P_RESULT OUT NOCOPY VARCHAR2,-- 'PASS' or 'FAIL'

Line 849: l_acct_no XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

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

Line 858: from xtr_bank_accounts

854: /*-----------------------------------------------------------------------------------*/
855:
856: cursor FIND_AP_ACCT_ID is -- (1) To check for 'Shared' with this P_AP_BANK_ACCOUNT_ID
857: select 1
858: from xtr_bank_accounts
859: where ce_bank_account_id = P_ce_bank_account_id
860: and ce_bank_account_id is not null;
861:
862: cursor GET_COMPANY is -- (2) To check for valid company ORG_ID

Line 876: from xtr_bank_accounts b,

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

Line 892: from xtr_bank_accounts

888: Cursor CHK_UNIQUE_ACCT IS -- (a) To check for a single authorised account
889: select authorised,
890: party_code,
891: ce_bank_account_id
892: from xtr_bank_accounts
893: where account_number = P_ACCOUNT_NUMBER
894: and currency = P_CURRENCY
895: order by authorised desc; -- so 'Y' comes before 'N'
896:

Line 1718: from xtr_bank_accounts

1714: and party_code = l_intercomp_code;
1715:
1716: cursor get_acct_no (l_bank_id NUMBER, l_ccy VARCHAR2, l_party VARCHAR2) is
1717: select account_number
1718: from xtr_bank_accounts
1719: where party_code = l_party
1720: and currency = l_ccy
1721: and ce_bank_account_id = l_bank_id;
1722:

Line 1790: from xtr_bank_accounts

1786: and product_type is null; -- Condition added Bug 4309871
1787:
1788: cursor get_acct_no (l_bank_id NUMBER, l_ccy VARCHAR2, l_party VARCHAR2) is
1789: select account_number
1790: from xtr_bank_accounts
1791: where party_code = l_party
1792: and currency = l_ccy
1793: and ce_bank_account_id = l_bank_id;
1794:

Line 1795: l_ccy xtr_bank_accounts.currency%TYPE;

1791: where party_code = l_party
1792: and currency = l_ccy
1793: and ce_bank_account_id = l_bank_id;
1794:
1795: l_ccy xtr_bank_accounts.currency%TYPE;
1796:
1797: BEGIN
1798: open get_company (p_cash_pool_id);
1799: fetch get_company into p_company_code, p_currency;