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.OTA_TDB_BUS dependencies on PER_PERSON_TYPES

Line 657: per_person_types ppt

653: SELECT paf.ROWID
654: FROM per_all_assignments_f paf, ota_events evt ,
655: per_all_people_f ppf,
656: per_person_type_usages_f ptu,
657: per_person_types ppt
658: WHERE paf.person_id = l_person_id
659: AND ppf.person_id = l_person_id
660: AND ptu.person_id = ppf.person_id
661: AND evt.event_id = p_event_id

Line 718: per_person_types ppt

714: SELECT paf.ROWID
715: FROM per_all_assignments_f paf ,
716: per_all_people_f ppf,
717: per_person_type_usages_f ptu,
718: per_person_types ppt
719: WHERE paf.person_id = l_person_id
720: AND ppf.person_id = l_person_id
721: AND ptu.person_id = ppf.person_id
722: AND p_date_booking_placed BETWEEN paf.effective_start_date