APPS.HR_PAY_RATE_SS dependencies on FND_CURRENCIES

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 948: lv_currency_symbol fnd_currencies.symbol%type default null;

944: ln_quartile number default null;
945: ln_comparatio number default null;
946: lv_last_pay_change varchar2(200) default null;
947: lv_flsa_status hr_lookups.meaning%type default null;
948: lv_currency_symbol fnd_currencies.symbol%type default null;
949: ln_precision number default null;
950: ln_pay_proposal_id per_pay_proposals.pay_proposal_id%type ;
951: ln_current_salary number default null;
952: ln_proposal_ovn per_pay_proposals.object_version_number%type;

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: