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 1038: lv_tmp_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;

1034: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1035: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1036: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
1037: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;
1038: lv_tmp_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;
1039:
1040:
1041: BEGIN
1042:

Line 5311: lv_old_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;

5307: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5308: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5309: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
5310: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;
5311: lv_old_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;
5312: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5313: lv_old_fte_factor number default null;
5314: l_factor number default null;
5315: