DBA Data[Home] [Help]

APPS.XTR_FPS2_P dependencies on XTR_BANK_ACCOUNTS

Line 315: from XTR_BANK_ACCOUNTS

311: l_acct_nos IN OUT NOCOPY VARCHAR2) is
312: --
313: cursor DEFAULT_ACCOUNT is
314: select ACCOUNT_NUMBER
315: from XTR_BANK_ACCOUNTS
316: where PARTY_CODE = l_company
317: and CURRENCY = l_currency
318: and DEFAULT_ACCT = 'Y';
319: --

Line 785: XTR_BANK_ACCOUNTS b

781: --
782: cursor DFLT_ACCT is
783: select b.BANK_SHORT_CODE,a.ACCOUNT_NO
784: from XTR_STANDING_INSTRUCTIONS a,
785: XTR_BANK_ACCOUNTS b
786: where a.PARTY_CODE = l_party
787: and a.CURRENCY = l_ccy
788: and (a.DEAL_TYPE = l_deal_type
789: or a.DEAL_TYPE is NULL)

Line 806: from XTR_BANK_ACCOUNTS a

802: l_dummy NUMBER;
803: --
804: cursor NO_DFLT_ACCT is
805: select a.BANK_SHORT_CODE,a.ACCOUNT_NUMBER
806: from XTR_BANK_ACCOUNTS a
807: where a.PARTY_CODE = l_party
808: and a.CURRENCY = l_ccy
809: and nvl(a.AUTHORISED,'N') = 'Y'
810: --* bug #1723491, rravunny