eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_PAY_BASES

Line 25: ,per_pay_bases ppb

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)

Line 654: ,per_pay_bases ppb

650: where rtg1.event_id = evt1.event_id (+)
651: and rtg1.review_date <= p_effective_date
652: and nvl(evt1.type, '-X-X-X-') = nvl(l_performance_rating_type, '-X-X-X-')
653: and evt1.event_id = apr.event_id(+)) perf
654: ,per_pay_bases ppb
655: ,pay_people_groups grp
656: ,per_all_assignments_f paf_prev
657: ,per_pay_proposals ppp_prev
658: ,per_pay_bases ppb_prev

Line 658: ,per_pay_bases ppb_prev

654: ,per_pay_bases ppb
655: ,pay_people_groups grp
656: ,per_all_assignments_f paf_prev
657: ,per_pay_proposals ppp_prev
658: ,per_pay_bases ppb_prev
659: where pil.per_in_ler_id = p_group_per_in_ler_id
660: and paf.assignment_id = pil.assignment_id
661: and p_effective_date between paf.effective_start_date and
662: paf.effective_end_date