DBA Data[Home] [Help]

APPS.PAY_PYAUPYT_XMLP_PKG dependencies on FND_CURRENCIES

Line 189: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

185: RETURN V_LEGISLATION_CODE;
186: END CF_LEGISLATION_CODEFORMULA;
187:
188: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
189: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
190: V_FORMAT_MASK VARCHAR2(100) := NULL;
191: V_FIELD_LENGTH NUMBER(3) := 30;
192: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
193: SELECT

Line 192: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS

188: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
189: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
190: V_FORMAT_MASK VARCHAR2(100) := NULL;
191: V_FIELD_LENGTH NUMBER(3) := 30;
192: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
193: SELECT
194: CURRENCY_CODE
195: FROM
196: FND_CURRENCIES

Line 196: FND_CURRENCIES

192: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
193: SELECT
194: CURRENCY_CODE
195: FROM
196: FND_CURRENCIES
197: WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
198: BEGIN
199: OPEN CURRENCY_FORMAT_MASK(CF_LEGISLATION_CODE);
200: FETCH CURRENCY_FORMAT_MASK