DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on PAY_INPUT_VALUES_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 1220: , pay_input_values_f piv

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
1224: AND p_change_date BETWEEN paf.effective_start_date