DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on FND_CURRENCIES_VL

Line 1274: (SELECT name from fnd_currencies_vl WHERE

1270: AND ENABLED_FLAG = 'Y') STATUS_DESC,
1271: TO_CHAR(AWARDED_DATE,'YYYY-MM-DD'),
1272: FEE,
1273: FEE_CURRENCY,
1274: (SELECT name from fnd_currencies_vl WHERE
1275: CURRENCY_CODE = FEE_CURRENCY
1276: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)
1277: AND ENABLED_FLAG = 'Y') FEE_CURRENCY_DESC,
1278: TRAINING_COMPLETED_AMOUNT,