APPS.HR_MEE_VIEWS_GEN dependencies on PAY_GRADE_RULES_F

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

556: ) return varchar2 is
557:
558: cursor c_step_details is
559: select pgr.value , psp.spinal_point
560: from pay_grade_rules_f pgr, per_spinal_points psp, per_spinal_point_steps_f psps
561: where psps.step_id = p_step_id and psps.spinal_point_id=psp.spinal_point_id
562: and pgr.grade_or_spinal_point_id=psps.spinal_point_id and pgr.rate_type='SP'
563: and p_eff_date between pgr.effective_start_date and pgr.effective_end_date
564: and p_eff_date between psps.effective_start_date and psps.effective_end_date;

Line 741: ,per_pay_bases pb, pay_grade_rules_f gr

737: l_rowid ROWID:=NULL;
738: CURSOR c_graderule IS
739: SELECT gr.rowid
740: FROM per_pay_proposals ppp, per_assignments_f paf
741: ,per_pay_bases pb, pay_grade_rules_f gr
742: WHERE ppp.pay_proposal_id = p_pay_proposal_id
743: AND ppp.assignment_id = paf.assignment_id
744: AND ppp.change_date between paf.effective_start_date and paf.effective_end_date
745: AND paf.pay_basis_id = pb.pay_basis_id