[Home] [Help]
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
684: where pil.per_in_ler_id = p_group_per_in_ler_id