DBA Data[Home] [Help]

APPS.PAY_PYAURECD_XMLP_PKG dependencies on FND_CURRENCIES

Line 273: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

269: RETURN V_LEGISLATION_CODE;
270: END CF_LEGISLATION_CODEFORMULA;
271:
272: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
273: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
274: V_FORMAT_MASK VARCHAR2(100) := NULL;
275: V_FIELD_LENGTH NUMBER(3) := 14;
276: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
277: SELECT

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

272: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
273: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
274: V_FORMAT_MASK VARCHAR2(100) := NULL;
275: V_FIELD_LENGTH NUMBER(3) := 14;
276: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
277: SELECT
278: CURRENCY_CODE
279: FROM
280: FND_CURRENCIES

Line 280: FND_CURRENCIES

276: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
277: SELECT
278: CURRENCY_CODE
279: FROM
280: FND_CURRENCIES
281: WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
282: BEGIN
283: OPEN CURRENCY_FORMAT_MASK(CF_LEGISLATION_CODE);
284: FETCH CURRENCY_FORMAT_MASK