APPS.PAY_PYAUSGC_XMLP_PKG dependencies on FND_CURRENCIES

Line 65: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

61: RETURN V_LEGISLATION_CODE;
62: END CF_LEGISLATION_CODEFORMULA;
63:
64: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
65: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
66: V_FORMAT_MASK VARCHAR2(100) := NULL;
67: V_FIELD_LENGTH NUMBER(3) := 15;
68: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
69: SELECT

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

64: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
65: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
66: V_FORMAT_MASK VARCHAR2(100) := NULL;
67: V_FIELD_LENGTH NUMBER(3) := 15;
68: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
69: SELECT
70: CURRENCY_CODE
71: FROM
72: FND_CURRENCIES

Line 72: FND_CURRENCIES

68: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
69: SELECT
70: CURRENCY_CODE
71: FROM
72: FND_CURRENCIES
73: WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
74: BEGIN
75: OPEN CURRENCY_FORMAT_MASK(CF_LEGISLATION_CODE);
76: FETCH CURRENCY_FORMAT_MASK