APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_USERTYPE_RESP

Line 530: FROM JTF_UM_USERTYPE_RESP UT, FND_RESPONSIBILITY_VL FR

526: --added variables for 4287135
527: isDefaultRespPresent boolean :=false;
528:
529: CURSOR USERTYPE_RESP is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
530: FROM JTF_UM_USERTYPE_RESP UT, FND_RESPONSIBILITY_VL FR
531: WHERE UT.USERTYPE_ID = X_USERTYPE_ID
532: AND FR.APPLICATION_ID = UT.APPLICATION_ID
533: AND FR.RESPONSIBILITY_KEY = UT.RESPONSIBILITY_KEY
534: AND (UT.EFFECTIVE_END_DATE IS NULL OR UT.EFFECTIVE_END_DATE > SYSDATE)

Line 925: jtf_um_usertype_resp where usertype_id = l_usertype_id

921: l_application_id NUMBER;
922: l_user_id NUMBER;
923:
924: cursor find_default_resp is select responsibility_key, application_id from
925: jtf_um_usertype_resp where usertype_id = l_usertype_id
926: and (effective_end_date is null or effective_end_date > sysdate) ;
927:
928: cursor find_usertype is select usertype_id from jtf_um_usertypes_b
929: where usertype_key = l_usertype_key

Line 1066: FROM JTF_UM_USERTYPE_RESP UTRESP, FND_RESPONSIBILITY_VL FURESP

1062: ) IS
1063:
1064: l_procedure_name CONSTANT varchar2(30) := 'get_usertype_resp';
1065: CURSOR FIND_UT_RESP IS SELECT UTRESP.APPLICATION_ID, FURESP.RESPONSIBILITY_ID
1066: FROM JTF_UM_USERTYPE_RESP UTRESP, FND_RESPONSIBILITY_VL FURESP
1067: WHERE UTRESP.USERTYPE_ID = p_usertype_id
1068: AND NVL(UTRESP.EFFECTIVE_END_DATE,SYSDATE+1) > SYSDATE
1069: AND UTRESP.EFFECTIVE_START_DATE < SYSDATE
1070: AND UTRESP.RESPONSIBILITY_KEY = FURESP.RESPONSIBILITY_KEY;