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_ACCOUNT_BAL_MAINT_P dependencies on XTR_BANK_ACCOUNTS

Line 34: from XTR_BANK_ACCOUNTS

30: */
31:
32: cursor RATE_BASIS is
33: select nvl(INTEREST_CALCULATION_BASIS,'STEP')
34: from XTR_BANK_ACCOUNTS
35: where ACCOUNT_NUMBER = l_acct
36: and PARTY_CODE = L_PARTY_CODE
37: and CURRENCY = L_CURRENCY;
38: --

Line 241: from XTR_BANK_ACCOUNTS

237: --
238: cursor ACCT_DETAILS is
239: select PARTY_CODE,CURRENCY,PORTFOLIO_CODE,BANK_CODE,nvl(YEAR_CALC_TYPE,'ACTUAL/ACTUAL') year_calc_type,
240: rounding_type, day_count_type
241: from XTR_BANK_ACCOUNTS
242: where ACCOUNT_NUMBER = acct_no
243: and PARTY_CODE = new_company;
244: --
245: cursor NEW_BALANCE is

Line 510: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

506: l_yr_type VARCHAR2(20);
507:
508: l_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
509:
510: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
511: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
512: l_notl_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
513: l_notl_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
514: l_notl_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;

Line 511: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;

507:
508: l_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
509:
510: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
511: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
512: l_notl_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
513: l_notl_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
514: l_notl_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
515: l_notl_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;

Line 512: l_notl_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;

508: l_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
509:
510: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
511: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
512: l_notl_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
513: l_notl_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
514: l_notl_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
515: l_notl_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
516: l_notl_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;

Line 513: l_notl_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;

509:
510: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
511: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
512: l_notl_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
513: l_notl_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
514: l_notl_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
515: l_notl_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
516: l_notl_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
517:

Line 514: l_notl_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;

510: l_account_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
511: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
512: l_notl_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
513: l_notl_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
514: l_notl_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
515: l_notl_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
516: l_notl_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
517:
518: --

Line 515: l_notl_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;

511: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
512: l_notl_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
513: l_notl_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
514: l_notl_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
515: l_notl_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
516: l_notl_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
517:
518: --
519:

Line 516: l_notl_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;

512: l_notl_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
513: l_notl_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;
514: l_notl_year_calc_type XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE;
515: l_notl_rounding_type XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE;
516: l_notl_day_count_type XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE;
517:
518: --
519:
520: cursor SEL_SETOFF_ACCT is

Line 542: FROM XTR_BANK_ACCOUNTS

538: cursor NOTIONAL_ACCT_NO IS
539: SELECT account_number, party_code, bank_code,
540: currency, nvl(year_calc_type, 'ACTUAL/ACTUAL'),
541: rounding_type, day_count_type
542: FROM XTR_BANK_ACCOUNTS
543: WHERE cashpool_id = p_cashpool_id;
544:
545: cursor RNDING is
546: select ROUNDING_FACTOR,YEAR_BASIS

Line 852: update XTR_BANK_ACCOUNTS

848:
849: end if;
850: END LOOP;
851: -- AW 6/1/99
852: update XTR_BANK_ACCOUNTS
853: set INTEREST_RATE = l_rate,
854: UPDATED_ON = sysdate,
855: UPDATED_BY = l_updated_by
856: --where ACCOUNT_NUMBER = l_setoff||'-'||l_bank_code

Line 945: from XTR_bank_accounts

941:
942: cursor get_yr_type is
943: select nvl(YEAR_CALC_TYPE,'ACTUAL/ACTUAL'),
944: Nvl(rounding_type,'R'),Nvl(day_count_type,'L'), ce_bank_account_id -- Added for Interest Override
945: from XTR_bank_accounts
946: where ACCOUNT_NUMBER = P_ACCOUNT_NUMBER
947: and PARTY_CODE = P_PARTY_CODE;
948: -- Modified the cursor R12 Removed the reference to ap_bank_account_id, dummy_bank_account_id
949: cursor chk_setoff is

Line 951: from XTR_bank_accounts

947: and PARTY_CODE = P_PARTY_CODE;
948: -- Modified the cursor R12 Removed the reference to ap_bank_account_id, dummy_bank_account_id
949: cursor chk_setoff is
950: select SETOFF_ACCOUNT_YN, ce_bank_account_id
951: from XTR_bank_accounts
952: where ACCOUNT_NUMBER = P_ACCOUNT_NUMBER
953: and PARTY_CODE = P_PARTY_CODE;
954: l_setoff_acct_yn varchar2(1);
955: l_bank_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;

Line 1009: l_ce_bank_account_id XTR_BANK_ACCOUNTS.CE_BANK_ACCOUNT_ID%TYPE;

1005: WHERE user_id = FND_GLOBAL.USER_ID;
1006:
1007: l_rounding_type VARCHAR2(1);
1008: l_day_count_type VARCHAR2(1);
1009: l_ce_bank_account_id XTR_BANK_ACCOUNTS.CE_BANK_ACCOUNT_ID%TYPE;
1010: l_prv_rounding_type VARCHAR2(1);
1011: l_prv_day_count_type VARCHAR2(1);
1012: l_first_trans_flag VARCHAR2(1);
1013: l_oldest_date DATE;

Line 1163: update XTR_BANK_ACCOUNTS

1159: open chk_setoff ;
1160: fetch chk_setoff into l_setoff_acct_yn, l_bank_account_id;
1161: close chk_setoff;
1162: if l_calc_date is not null and nvl(l_setoff_acct_yn,'N')<>'Y' then
1163: update XTR_BANK_ACCOUNTS
1164: set OPENING_BALANCE = l_open_bal,
1165: OPENING_BAL_HCE = round(l_open_bal/l_hce_rate,roundfac),
1166: STATEMENT_DATE = l_calc_date,
1167: INTEREST_RATE = l_this_rate,

Line 1219: update XTR_BANK_ACCOUNTS

1215: end if;
1216: close DEAL_NUM;
1217: elsif l_calc_date is null and nvl(l_setoff_acct_yn,'N')<>'Y' then
1218: -- AW 6/16 Update bank accounts if all balances rows are deleted.
1219: update XTR_BANK_ACCOUNTS
1220: set OPENING_BALANCE = 0,
1221: OPENING_BAL_HCE = 0,
1222: STATEMENT_DATE = null,
1223: INTEREST_RATE = null,