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.GMS_NOTIFICATION_PKG dependencies on GMS_PERSONNEL

Line 227: from gms_personnel

223:
224:
225: cursor award_persons is
226: select person_id
227: from gms_personnel
228: where award_id = p_award_id and
229: trunc(sysdate) between start_date_active and nvl(end_date_active,to_date('01/01/4000','DD/MM/YYYY'));
230:
231: user_not_yet_created exception;

Line 326: -- added in order not to delete the person if he still exists in gms_personnel with additional

322: where user_id = l_user_id and
323: award_id = p_award_id and
324:
325: -- Bug 1969587 : Installment closeout Notification
326: -- added in order not to delete the person if he still exists in gms_personnel with additional
327: -- award role.
328:
329: not exists ( select 1
330: from gms_personnel

Line 330: from gms_personnel

326: -- added in order not to delete the person if he still exists in gms_personnel with additional
327: -- award role.
328:
329: not exists ( select 1
330: from gms_personnel
331: where award_id = p_award_id and
332: person_id = p_person_id
333: );
334: