[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'
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(+)
489: and pb.input_value_id = ivf.input_value_id
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
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
1267: AND p_change_date BETWEEN paf.effective_start_date
1268: AND paf.effective_end_date
1322: ,p_change_date IN DATE)
1323: IS
1324: SELECT ppb.pay_annualization_factor
1325: , ppp.proposed_salary_n
1326: FROM per_pay_bases ppb
1327: , per_assignments_f paf
1328: , per_pay_proposals ppp
1329: WHERE paf.assignment_id = p_assign_id
1330: AND p_change_date BETWEEN paf.effective_start_date