[Home] [Help]
226: null, 1,
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'
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(+)
446: and pb.input_value_id = ivf.input_value_id
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
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
1225: AND paf.effective_end_date
1279: ,p_change_date IN DATE)
1280: IS
1281: SELECT ppb.pay_annualization_factor
1282: , ppp.proposed_salary_n
1283: FROM per_pay_bases ppb
1284: , per_assignments_f paf
1285: , per_pay_proposals ppp
1286: WHERE paf.assignment_id = p_assign_id
1287: AND p_change_date BETWEEN paf.effective_start_date