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 568: FROM per_all_people_f pap,

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

Line 584: FROM per_all_people_f pap,

580: pap.person_id,
581: paa.supervisor_id,
582: greatest(paa.effective_start_date, P_StartDate) as Start_Date,
583: least(paa.effective_end_date, P_EndDate) as End_Date
584: FROM per_all_people_f pap,
585: per_all_assignments_f paa
586: WHERE pap.person_id = paa.person_id
587: AND paa.supervisor_id = P_EmployeeId
588: AND 'MANAGER' = P_QryType

Line 619: FROM per_all_people_f pap,

615: and supervisor_id = paa.supervisor_id
616: AND ( assignment_type = 'E' OR assignment_type = 'C')
617: and prior effective_end_date = ( effective_start_date - 1 )
618: ) max_end_date
619: FROM per_all_people_f pap,
620: per_all_assignments_f paa,
621: per_assignment_status_types past
622: WHERE pap.person_id = paa.person_id
623: AND ( pap.person_id = P_EmployeeId or ( P_QryType = 'MANAGER' AND paa.supervisor_id = P_EmployeeId ) )