APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on CE_BANK_ACCOUNTS

Line 473: p_conc_acct_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,

469: ------------------------------------------------------------------------------------------------------------------
470: PROCEDURE MAINTAIN_SETOFFS(
471: p_party_code IN VARCHAR2,
472: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,
473: p_conc_acct_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
474: p_calc_date IN DATE) is
475: --
476: -- This procedure calculates the setoff account balances
477: -- after the latest balances are uploaded from the bank_bal table

Line 508: l_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;

504: l_prv_accrual_int NUMBER;
505: l_accrual_int NUMBER;
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;

Line 955: l_bank_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;

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;
956: --
957: cursor PREV_DETAILS is
958: select a.BALANCE_DATE,NVL(a.STATEMENT_BALANCE,0)+NVL(a.BALANCE_ADJUSTMENT,0) INT_BAL,a.ACCUM_INT_CFWD,a.INTEREST_RATE,A.ACCRUAL_INTEREST,
959: a.rounding_type, a.day_count_type -- Added for Interest Override

Line 1017: l_conc_acct_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;

1013: l_oldest_date DATE;
1014: l_original_amount NUMBER;
1015: l_prv_prv_day_count_type VARCHAR2(1);
1016: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;
1017: l_conc_acct_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
1018: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
1019: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
1020: --
1021: begin