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.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on PER_ALL_PEOPLE_F

Line 554: FROM per_all_people_f pap,

550: pap.person_id,
551: paa.supervisor_id,
552: greatest(paa.effective_start_date, P_StartDate) as Start_Date,
553: least(paa.effective_end_date, P_EndDate) as End_Date
554: FROM per_all_people_f pap,
555: per_all_assignments_f paa
556: WHERE pap.person_id = paa.person_id
557: AND pap.person_id = P_EmployeeId
558: AND P_StartDate < paa.effective_end_date

Line 570: FROM per_all_people_f pap,

566: pap.person_id,
567: paa.supervisor_id,
568: greatest(paa.effective_start_date, P_StartDate) as Start_Date,
569: least(paa.effective_end_date, P_EndDate) as End_Date
570: FROM per_all_people_f pap,
571: per_all_assignments_f paa
572: WHERE pap.person_id = paa.person_id
573: AND paa.supervisor_id = P_EmployeeId
574: AND 'MANAGER' = P_QryType

Line 605: FROM per_all_people_f pap,

601: and supervisor_id = paa.supervisor_id
602: AND ( assignment_type = 'E' OR assignment_type = 'C')
603: and prior effective_end_date = ( effective_start_date - 1 )
604: ) max_end_date
605: FROM per_all_people_f pap,
606: per_all_assignments_f paa
607: WHERE pap.person_id = paa.person_id
608: AND ( pap.person_id = P_EmployeeId or ( P_QryType = 'MANAGER' AND paa.supervisor_id = P_EmployeeId ) )
609: AND P_StartDate <= paa.effective_end_date