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_TSR_BUS dependencies on PER_PERSON_TYPES

Line 740: -- PER_PERSON_TYPE_USAGES_F & PER_PERSON_TYPES

736: l_exists varchar2(1);
737: l_global_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
738: --Bug 1991061
739: -- Enh 2530860 Following 2 cursors modified to support PTU . Included the table
740: -- PER_PERSON_TYPE_USAGES_F & PER_PERSON_TYPES
741:
742: Cursor c_trainer_global
743: IS
744: Select null

Line 745: From PER_ALL_PEOPLE_F per, PER_PERSON_TYPE_USAGES_F ptu, PER_PERSON_TYPES ppt

741:
742: Cursor c_trainer_global
743: IS
744: Select null
745: From PER_ALL_PEOPLE_F per, PER_PERSON_TYPE_USAGES_F ptu, PER_PERSON_TYPES ppt
746: Where per.person_id = p_trainer_id
747: --AND trunc(p_start_date) between per.effective_start_date and per.effective_end_date Bug# 2956482
748: AND trunc(p_start_date) >= per.start_date
749: AND NVL(trunc(p_end_date),trunc(sysdate)) <= ptu.effective_end_date --bug no 3058027

Line 761: From PER_ALL_PEOPLE_F per, PER_PERSON_TYPE_USAGES_F ptu, PER_PERSON_TYPES ppt

757:
758: Cursor c_trainer
759: IS
760: Select null
761: From PER_ALL_PEOPLE_F per, PER_PERSON_TYPE_USAGES_F ptu, PER_PERSON_TYPES ppt
762: Where per.person_id = p_trainer_id
763: -- AND trunc(p_start_date) between per.effective_start_date and per.effective_end_date Bug# 2956482
764: AND trunc(p_start_date) >= per.start_date
765: AND NVL(trunc(p_end_date),trunc(sysdate)) <= ptu.effective_end_date --bug no 3058027