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_BUS2 dependencies on PER_ALL_PEOPLE_F

Line 357: from per_all_people_f

353: --
354: --
355: cursor c_person (l_person_id number) is
356: select 1
357: from per_all_people_f
358: where person_id = l_person_id
359: and business_group_id = p_business_group_id;
360:
361:

Line 701: from per_all_people_f

697: /* Modified p_date_booking_placed to trunc(p_date_booking_placed)for bug 6402358*/
698:
699: cursor c_delegate is
700: select effective_start_date, effective_end_date
701: from per_all_people_f
702: where person_id = p_delegate_person_id
703: and trunc(p_date_booking_placed)
704: between effective_start_date
705: and nvl(effective_end_date,hr_api.g_eot);

Line 709: from per_all_people_f

705: and nvl(effective_end_date,hr_api.g_eot);
706: --
707: cursor c_sponsor is
708: select effective_start_date, effective_end_date
709: from per_all_people_f
710: where person_id = p_sponsor_person_id
711: and p_date_booking_placed
712: between effective_start_date
713: and nvl(effective_end_date,hr_api.g_eot);