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.PER_ABSENCE_ATTENDANCES_PKG dependencies on PER_ASSIGNMENTS_F

Line 2015: per_assignments_f asg

2011: --
2012: cursor c4 is
2013: select 1
2014: from hr_positions_f pp,
2015: per_assignments_f asg
2016: where asg.person_id = p_psn_id
2017: and nvl(p_dstart,nvl(p_proj_start,p_sess)) between
2018: asg.effective_start_date and asg.effective_end_date
2019: and pp.position_id = asg.position_id

Line 2285: per_assignments_f a

2281: t.start_date,
2282: t.end_date
2283: from per_time_periods t,
2284: pay_element_entries_f e,
2285: per_assignments_f a
2286: where a.person_id = p_per_id
2287: and a.primary_flag = 'Y'
2288: and p_sdstart between a.effective_start_date and a.effective_end_date
2289: and e.assignment_id = a.assignment_id

Line 2403: from per_assignments_f asg,

2399: select asg.assignment_id,
2400: l.element_link_id,
2401: asg.payroll_id,
2402: 'X'
2403: from per_assignments_f asg,
2404: pay_element_types_f t,
2405: pay_element_links_f l
2406: where l.business_group_id + 0 = p_bgroup_id
2407: and t.element_type_id = p_eltype