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 484: from pay_input_values_f ivf, pay_element_types_f petf, pay_grade_rules_f gr,

480: cursor c_grade_details is
481:
482: select gr.currency_code, gr.minimum, gr.mid_value, gr.maximum, petf.input_currency_code,
483: pb.grade_annualization_factor, ppp.proposed_salary_n, pb.pay_annualization_factor
484: from pay_input_values_f ivf, pay_element_types_f petf, pay_grade_rules_f gr,
485: per_pay_bases pb, per_assignments_f paf, per_pay_proposals ppp
486: where paf.assignment_id = p_assignment_id
487: AND paf.pay_basis_id = pb.pay_basis_id
488: and paf.assignment_id = ppp.assignment_id(+)

Line 1253: RETURN pay_element_types_f.input_currency_code%TYPE

1249: */
1250:
1251: FUNCTION get_currency(p_assignment_id IN per_assignments_f.assignment_id%TYPE
1252: ,p_change_date IN DATE)
1253: RETURN pay_element_types_f.input_currency_code%TYPE
1254: IS
1255:
1256: lv_result pay_element_types_f.input_currency_code%TYPE;
1257:

Line 1256: lv_result pay_element_types_f.input_currency_code%TYPE;

1252: ,p_change_date IN DATE)
1253: RETURN pay_element_types_f.input_currency_code%TYPE
1254: IS
1255:
1256: lv_result pay_element_types_f.input_currency_code%TYPE;
1257:
1258: CURSOR lc_get_currency(p_assign_id IN per_assignments_f.assignment_id%TYPE
1259: ,p_change_date IN DATE)
1260: IS

Line 1262: FROM pay_element_types_f pet

1258: CURSOR lc_get_currency(p_assign_id IN per_assignments_f.assignment_id%TYPE
1259: ,p_change_date IN DATE)
1260: IS
1261: SELECT pet.input_currency_code
1262: FROM pay_element_types_f pet
1263: , pay_input_values_f piv
1264: , per_pay_bases ppb
1265: , per_assignments_f paf
1266: WHERE paf.assignment_id = p_assign_id

Line 1940: p_curcode pay_element_types_f.input_currency_code%TYPE,

1936:
1937: END get_segment_value;
1938:
1939: FUNCTION get_currency_format(
1940: p_curcode pay_element_types_f.input_currency_code%TYPE,
1941: p_effective_date DATE
1942: )
1943: RETURN VARCHAR2
1944: IS