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

951: ln_quartile number default null;
952: ln_comparatio number default null;
953: lv_last_pay_change varchar2(200) default null;
954: lv_flsa_status hr_lookups.meaning%type default null;
955: lv_currency_symbol fnd_currencies.symbol%type default null;
956: ln_precision number default null;
957: ln_pay_proposal_id per_pay_proposals.pay_proposal_id%type ;
958: ln_current_salary number default null;
959: ln_proposal_ovn per_pay_proposals.object_version_number%type;

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: