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