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.JTF_UM_USER_ADMIN_PVT dependencies on JTF_UM_USERTYPE_SUBSCRIP

Line 477: (select SUBSCRIPTION_ID from JTF_UM_USERTYPE_SUBSCRIP

473: SET effective_END_DATE =SYSDATE, last_update_login=l_user_id,last_update_date=sysdate
474: WHERE USER_ID = p_user_id and status_code='APPROVED'
475: and effective_start_date < sysdate and nvl(effective_end_date,sysdate +1) > sysdate
476: AND SUBSCRIPTION_ID IN
477: (select SUBSCRIPTION_ID from JTF_UM_USERTYPE_SUBSCRIP
478: where userTYpe_id=p_usertype_id and
479: effective_start_date < sysdate and nvl(effective_end_date,sysdate +1) > sysdate);
480:
481: