APPS.HR_PAY_RATE_SS dependencies on FND_CURRENCIES_VL

Line 599: FROM FND_CURRENCIES_VL CUR

595:
596: l_proc varchar2(200) := g_package || 'get_precision';
597: CURSOR c_precision IS
598: SELECT CUR.PRECISION
599: FROM FND_CURRENCIES_VL CUR
600: WHERE CUR.CURRENCY_CODE=p_currency_code
601: AND p_date BETWEEN
602: NVL(CUR.START_DATE_ACTIVE,p_date) AND
603: NVL(CUR.END_DATE_ACTIVE,p_date+1);

Line 1015: lv_tmp_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;

1011: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1012: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1013: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
1014: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;
1015: lv_tmp_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;
1016:
1017:
1018: BEGIN
1019:

Line 5150: lv_old_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;

5146: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5147: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5148: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
5149: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;
5150: lv_old_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;
5151: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5152:
5153: BEGIN
5154: