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_VRE_BUS dependencies on PER_PEOPLE_F

Line 1315: ,per_people_f papf

1311: /*CURSOR c_pesron_names_cursor IS
1312: SELECT distinct papf.title ||' '||papf.first_name ||' '|| papf.last_name
1313: FROM pqp_vehicle_allocations_f pva
1314: ,per_all_assignments_f paa
1315: ,per_people_f papf
1316: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id
1317: AND paa.assignment_id=pva.assignment_id
1318: AND papf.person_id=paa.person_id
1319: AND (p_effective_date

Line 1335: ,per_people_f papf

1331: CURSOR c_pesron_names_cursor IS
1332: SELECT distinct hl.meaning ||' '||papf.first_name ||' '|| papf.last_name
1333: FROM pqp_vehicle_allocations_f pva
1334: ,per_all_assignments_f paa
1335: ,per_people_f papf
1336: ,hr_lookups hl
1337: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id
1338: AND paa.assignment_id=pva.assignment_id
1339: AND papf.person_id=paa.person_id

Line 1393: ,per_people_f papf

1389: CURSOR c_pesron_names_cursor IS
1390: SELECT distinct hl.meaning ||' '||papf.first_name ||' '|| papf.last_name
1391: FROM pqp_vehicle_allocations_f pva
1392: ,per_all_assignments_f paa
1393: ,per_people_f papf
1394: ,hr_lookups hl
1395: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id
1396: AND paa.assignment_id=pva.assignment_id
1397: AND papf.person_id=paa.person_id