APPS.PAY_PAYKRHCL_XMLP_PKG dependencies on FND_CURRENCIES

Line 63: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

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

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

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

Line 70: FND_CURRENCIES

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