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.PQP_GB_SWF_ARCHIVE dependencies on HR_LOCATION_EXTRA_INFO

Line 824: hr_location_extra_info hlei,

820: is
821: select distinct asg.assignment_id,
822: asg.person_id
823: from per_all_assignments_f asg,
824: hr_location_extra_info hlei,
825: per_people_extra_info pei,
826: (select distinct min(asg1.effective_start_date) over( partition by assignment_id) effective_start_date,
827: max(asg1.effective_end_date) over( partition by assignment_id) effective_end_date,
828: first_value(location_id)over( partition by assignment_id order by asg1.effective_end_date desc ) location_id,

Line 910: hr_location_extra_info hlei,

906: is
907: select distinct asg.assignment_id,asg.person_id
908: from per_all_assignments_f asg,
909: pqp_assignment_attributes_f att,
910: hr_location_extra_info hlei,
911: per_people_extra_info pei,
912: (select min(att1.effective_start_date) effective_start_date,
913: max(att1.effective_end_date) effective_end_date,
914: att1.assignment_id

Line 1281: hr_location_extra_info hlei

1277:
1278: cursor get_estab_no( p_assignment_id in number , p_effective_date in date) is
1279: select hlei.lei_information2
1280: from per_all_assignments_f asg,
1281: hr_location_extra_info hlei
1282: where asg.business_group_id + 0 = g_business_group_id
1283: and asg.location_id = hlei.location_id
1284: and asg.assignment_id = p_assignment_id
1285: and p_effective_date between asg.effective_start_date and asg.effective_end_date