APPS.HR_MEE_VIEWS_GEN dependencies on PAY_GRADE_RULES_F

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 517: from pay_grade_rules_f pgr, per_spinal_points psp, per_spinal_point_steps_f psps

513: ) return varchar2 is
514:
515: cursor c_step_details is
516: select pgr.value , psp.spinal_point
517: from pay_grade_rules_f pgr, per_spinal_points psp, per_spinal_point_steps_f psps
518: where psps.step_id = p_step_id and psps.spinal_point_id=psp.spinal_point_id
519: and pgr.grade_or_spinal_point_id=psps.spinal_point_id and pgr.rate_type='SP'
520: and p_eff_date between pgr.effective_start_date and pgr.effective_end_date
521: and p_eff_date between psps.effective_start_date and psps.effective_end_date;

Line 698: ,per_pay_bases pb, pay_grade_rules_f gr

694: l_rowid ROWID:=NULL;
695: CURSOR c_graderule IS
696: SELECT gr.rowid
697: FROM per_pay_proposals ppp, per_assignments_f paf
698: ,per_pay_bases pb, pay_grade_rules_f gr
699: WHERE ppp.pay_proposal_id = p_pay_proposal_id
700: AND ppp.assignment_id = paf.assignment_id
701: AND ppp.change_date between paf.effective_start_date and paf.effective_end_date
702: AND paf.pay_basis_id = pb.pay_basis_id