APPS.JUMF_LCT_PKG dependencies on JTF_UM_USERTYPE_RESP

Line 463: from JTF_UM_USERTYPE_RESP

459: return;
460: else
461: select count(*)
462: into v_active_record_count
463: from JTF_UM_USERTYPE_RESP
464: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
465: and EFFECTIVE_END_DATE is NULL
466: and LAST_UPDATED_BY <> 1;
467:

Line 474: from JTF_UM_USERTYPE_RESP

470: end if;
471:
472: select LAST_UPDATED_BY
473: into v_db_owner_id
474: from JTF_UM_USERTYPE_RESP
475: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
476: and RESPONSIBILITY_KEY = x_responsibility_key
477: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
478:

Line 498: update JTF_UM_USERTYPE_RESP

494:
495: exception
496: when no_data_found then
497:
498: update JTF_UM_USERTYPE_RESP
499: set EFFECTIVE_END_DATE = SYSDATE
500: where EFFECTIVE_END_DATE is NULL
501: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
502: