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: