APPS.JTF_UM_UTIL_PVT dependencies on JTF_UM_USERTYPE_REG

Line 1364: from jtf_um_usertype_reg reg,

1360:
1361: -- select default responsibility for the usertype
1362: cursor c_default_resp(p_user_id in number) is
1363: select fnd.responsibility_id, fnd.application_id
1364: from jtf_um_usertype_reg reg,
1365: jtf_um_usertype_resp resp,
1366: fnd_responsibility fnd
1367: where reg.user_id = p_user_id
1368: and reg.usertype_id = resp.usertype_id

Line 1841: CURSOR GET_ID IS SELECT USERTYPE_ID FROM JTF_UM_USERTYPE_REG

1837: function GET_USERTYPE_ID(p_user_id NUMBER) return NUMBER IS
1838:
1839: l_procedure_name CONSTANT varchar2(30) := 'GET_USERTYPE_ID';
1840:
1841: CURSOR GET_ID IS SELECT USERTYPE_ID FROM JTF_UM_USERTYPE_REG
1842: WHERE USER_ID = p_user_id
1843: AND NVL(EFFECTIVE_END_DATE, SYSDATE+1) > SYSDATE
1844: AND EFFECTIVE_START_DATE < SYSDATE;
1845: