DBA Data[Home] [Help]

APPS.XTR_XTRCFACC_XMLP_PKG dependencies on XTR_BANK_ACCOUNTS_V

Line 19: SELECT nvl(round(OPENING_BALANCE,0),0)/amt_unit2 INTO OPEN_BAL FROM XTR_BANK_ACCOUNTS_V where PARTY_CODE = COMPANY_p and CURRENCY = CCY_p and ACCOUNT_NUMBER = ACCT_NOS_P;

15:
16: FUNCTION OPEN_BAL1FORMULA(ACCT_NOS_P in varchar2,ccy_p in varchar2,COMPANY_p in varchar2)RETURN VARCHAR2 IS
17: BEGIN
18:
19: SELECT nvl(round(OPENING_BALANCE,0),0)/amt_unit2 INTO OPEN_BAL FROM XTR_BANK_ACCOUNTS_V where PARTY_CODE = COMPANY_p and CURRENCY = CCY_p and ACCOUNT_NUMBER = ACCT_NOS_P;
20:
21: RETURN ('');
22: END OPEN_BAL1FORMULA;
23: