[Home] [Help]
21: ,get_fte_factor(v_assignment_id
22: ,v_effective_date) fte_factor
23: from per_all_assignments_f paf
24: ,per_pay_proposals ppp
25: ,per_pay_bases ppb
26: where ppp.assignment_id = v_assignment_id
27: and ppp.approved = 'Y'
28: and ppp.change_date =
29: (select max(ppp1.change_date)
675: and ((p_appraisal_n_days is not null and rtg1.review_date between (p_effective_date - p_appraisal_n_days) and p_effective_date)
676: or (p_appraisal_n_days is null and rtg1.review_date <= p_effective_date))
677: and nvl(evt1.type, '-X-X-X-') = nvl(l_performance_rating_type, '-X-X-X-')
678: ) perf
679: ,per_pay_bases ppb
680: ,pay_people_groups grp
681: ,per_all_assignments_f paf_prev
682: ,per_pay_proposals ppp_prev
683: ,per_pay_bases ppb_prev
679: ,per_pay_bases ppb
680: ,pay_people_groups grp
681: ,per_all_assignments_f paf_prev
682: ,per_pay_proposals ppp_prev
683: ,per_pay_bases ppb_prev
684: where pil.per_in_ler_id = p_group_per_in_ler_id
685: and paf.assignment_id = pil.assignment_id
686: and p_effective_date between paf.effective_start_date and
687: paf.effective_end_date