APPS.XTR_EXP_SUMM_P dependencies on XTR_BANK_ACCOUNTS

Line 57: from XTR_BANK_ACCOUNTS

53: decode(DEAL_TYPE,'FX',nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),'FXO',nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),NULL);
54: --
55: cursor GET_ACCT_BALS is
56: select sum(nvl(OPENING_BALANCE,0)),count(ACCOUNT_NUMBER)
57: from XTR_BANK_ACCOUNTS
58: where PARTY_CODE = l_company
59: and CURRENCY like nvl(sel_ccy,'%')
60: and nvl(PORTFOLIO_CODE,'%') like nvl(upper(l_portfolio),'%')
61: and nvl(SETOFF_ACCOUNT_YN,'N') <> 'Y';

Line 516: from XTR_BANK_ACCOUNTS

512: decode(DEAL_TYPE,'FX',AMOUNT_DATE,'FXO',AMOUNT_DATE,NULL);
513: --
514: cursor GET_ACCT_BALS is
515: select currency,sum(nvl(OPENING_BALANCE,0)),count(ACCOUNT_NUMBER)
516: from XTR_BANK_ACCOUNTS
517: where PARTY_CODE = l_company
518: and CURRENCY like upper(nvl(sel_ccy,'%'))
519: and nvl(PORTFOLIO_CODE,'%') like nvl(upper(l_portfolio),'%')
520: and nvl(SETOFF_ACCOUNT_YN,'N') <> 'Y'