DBA Data[Home] [Help]

APPS.XTR_XTRCFCCY_XMLP_PKG dependencies on XTR_BANK_ACCOUNTS_V

Line 17: SELECT NVL(round(sum(NVL(B.OPENING_BALANCE,0)),0),0)/amt_unit2 INTO OPEN_BAL FROM XTR_BANK_ACCOUNTS_V B where B.PARTY_CODE = COMPANY_P and B.CURRENCY = CCY_p;

13: END ROLLING_BALFORMULA;
14:
15: FUNCTION OPEN_BAL1FORMULA(ccy_p in varchar2,COMPANY_p in varchar2) RETURN VARCHAR2 IS
16: BEGIN
17: SELECT NVL(round(sum(NVL(B.OPENING_BALANCE,0)),0),0)/amt_unit2 INTO OPEN_BAL FROM XTR_BANK_ACCOUNTS_V B where B.PARTY_CODE = COMPANY_P and B.CURRENCY = CCY_p;
18: RETURN ('');
19: END OPEN_BAL1FORMULA;
20:
21: FUNCTION OPEN_BALFORMULA RETURN NUMBER IS