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.PERFRPHR dependencies on PER_ALL_ASSIGNMENTS_F

Line 86: FROM per_all_assignments_f asg,

82: p_include_suspended IN VARCHAR2) RETURN NUMBER IS
83: --
84: CURSOR c_get_total IS
85: SELECT COUNT(asg.assignment_id)
86: FROM per_all_assignments_f asg,
87: per_assignment_status_types ast,
88: per_person_types_v pt,
89: per_all_people_f peo
90: WHERE asg.establishment_id IN (SELECT hr2.organization_id

Line 120: FROM per_all_assignments_f asg2,

116: AND p_effective_date >= peo.effective_start_date
117: AND p_effective_date <= peo.effective_end_date
118: AND (LEAST(asg.effective_end_date,peo.effective_end_date) > p_effective_date
119: OR EXISTS (SELECT null
120: FROM per_all_assignments_f asg2,
121: per_assignment_status_types ast2,
122: per_person_types_v pt2,
123: per_all_people_f peo2
124: WHERE asg2.establishment_id IN (SELECT hr2.organization_id

Line 318: per_all_assignments_f ass,

314: hr_locations_all loc,
315: hr_ALL_ORGANIZATION_UNITS OU1,
316: HR_ORGANIZATION_INFORMATION OI1,
317: per_assignment_extra_info ext,
318: per_all_assignments_f ass,
319: per_all_people_f peo
320: WHERE adr.person_id(+) = peo.person_id
321: AND adr.primary_flag(+) = 'Y'
322: AND con.contract_id(+) = ass.contract_id

Line 424: per_all_assignments_f ass,

420: hr_locations_all loc,
421: hr_ALL_ORGANIZATION_UNITS OU1,
422: HR_ORGANIZATION_INFORMATION OI1,
423: per_assignment_extra_info ext,
424: per_all_assignments_f ass,
425: per_all_people_f peo
426: WHERE adr.person_id(+) = peo.person_id
427: AND adr.primary_flag(+) = 'Y'
428: AND con.contract_id(+) = ass.contract_id