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 1014: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;

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

Line 5138: uom PAY_INPUT_VALUES_F.UOM%TYPE;

5134: ln_no_of_components NUMBER ;
5135: i INTEGER ;
5136: lv_activity_display_name VARCHAR2(100);
5137: lv_currency VARCHAR2(10);
5138: uom PAY_INPUT_VALUES_F.UOM%TYPE;
5139: return_mask VARCHAR2(100);
5140:
5141: lv_old_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5142: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;

Line 5149: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;

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

Line 6254: pay_input_values_f pv

6250: from
6251: per_all_assignments_f asf,
6252: per_pay_proposals pay,
6253: per_pay_bases pb,
6254: pay_input_values_f pv
6255: where asf.person_id = p_person_id
6256: and asf.assignment_type = 'O'
6257: and asf.business_group_id = p_bg_id
6258: and asf.organization_id = p_org_id