APPS.HR_PAY_RATE_SS dependencies on PAY_INPUT_VALUES_F

Line 39: per_pay_bases pb, pay_input_values_f ivf

35:
36: Cursor c1 (p_aid number, p_date date) IS
37: select ivf.element_type_id
38: from per_all_assignments_f paf,
39: per_pay_bases pb, pay_input_values_f ivf
40: where paf.assignment_id = p_aid
41: --and paf.assignment_type = 'E'
42: and pb.pay_basis_id = paf.pay_basis_id
43: and pb.input_value_id = ivf.input_value_id

Line 1037: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;

1033: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%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

Line 5299: uom PAY_INPUT_VALUES_F.UOM%TYPE;

5295: ln_no_of_components NUMBER ;
5296: i INTEGER ;
5297: lv_activity_display_name VARCHAR2(100);
5298: lv_currency VARCHAR2(10);
5299: uom PAY_INPUT_VALUES_F.UOM%TYPE;
5300: return_mask VARCHAR2(100);
5301:
5302: lv_old_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5303: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;

Line 5310: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;

5306: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%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;

Line 6556: pay_input_values_f pv

6552: from
6553: per_all_assignments_f asf,
6554: per_pay_proposals pay,
6555: per_pay_bases pb,
6556: pay_input_values_f pv
6557: where asf.person_id = p_person_id
6558: and asf.assignment_type = 'O'
6559: and asf.business_group_id = p_bg_id
6560: and asf.organization_id = p_org_id