APPS.HR_MEE_VIEWS_GEN dependencies on PAY_ELEMENT_TYPES_F

Line 231: ,per_pay_proposals ppp, pay_input_values_f ivf, pay_element_types_f petf

227: 0, 1,
228: ppb.pay_annualization_factor) * ppp.proposed_salary_n
229: ,petf.input_currency_code
230: FROM per_pay_bases ppb, per_assignments_f paf
231: ,per_pay_proposals ppp, pay_input_values_f ivf, pay_element_types_f petf
232: WHERE paf.person_id = p_person_id
233: AND paf.primary_flag = 'Y'
234: AND paf.assignment_type = 'E'
235: AND ppb.input_value_id = ivf.input_value_id

Line 441: from pay_input_values_f ivf, pay_element_types_f petf, pay_grade_rules_f gr,

437: cursor c_grade_details is
438:
439: select gr.currency_code, gr.minimum, gr.mid_value, gr.maximum, petf.input_currency_code,
440: pb.grade_annualization_factor, ppp.proposed_salary_n, pb.pay_annualization_factor
441: from pay_input_values_f ivf, pay_element_types_f petf, pay_grade_rules_f gr,
442: per_pay_bases pb, per_assignments_f paf, per_pay_proposals ppp
443: where paf.assignment_id = p_assignment_id
444: AND paf.pay_basis_id = pb.pay_basis_id
445: and paf.assignment_id = ppp.assignment_id(+)

Line 1210: RETURN pay_element_types_f.input_currency_code%TYPE

1206: */
1207:
1208: FUNCTION get_currency(p_assignment_id IN per_assignments_f.assignment_id%TYPE
1209: ,p_change_date IN DATE)
1210: RETURN pay_element_types_f.input_currency_code%TYPE
1211: IS
1212:
1213: lv_result pay_element_types_f.input_currency_code%TYPE;
1214:

Line 1213: lv_result pay_element_types_f.input_currency_code%TYPE;

1209: ,p_change_date IN DATE)
1210: RETURN pay_element_types_f.input_currency_code%TYPE
1211: IS
1212:
1213: lv_result pay_element_types_f.input_currency_code%TYPE;
1214:
1215: CURSOR lc_get_currency(p_assign_id IN per_assignments_f.assignment_id%TYPE
1216: ,p_change_date IN DATE)
1217: IS

Line 1219: FROM pay_element_types_f pet

1215: CURSOR lc_get_currency(p_assign_id IN per_assignments_f.assignment_id%TYPE
1216: ,p_change_date IN DATE)
1217: IS
1218: SELECT pet.input_currency_code
1219: FROM pay_element_types_f pet
1220: , pay_input_values_f piv
1221: , per_pay_bases ppb
1222: , per_assignments_f paf
1223: WHERE paf.assignment_id = p_assign_id

Line 1897: p_curcode pay_element_types_f.input_currency_code%TYPE,

1893:
1894: END get_segment_value;
1895:
1896: FUNCTION get_currency_format(
1897: p_curcode pay_element_types_f.input_currency_code%TYPE,
1898: p_effective_date DATE
1899: )
1900: RETURN VARCHAR2
1901: IS