APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_USERTYPE_RESP

Line 579: FROM JTF_UM_USERTYPE_RESP UT, FND_RESPONSIBILITY_VL FR

575: --added variables for 4287135
576: isDefaultRespPresent boolean :=false;
577:
578: CURSOR USERTYPE_RESP is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
579: FROM JTF_UM_USERTYPE_RESP UT, FND_RESPONSIBILITY_VL FR
580: WHERE UT.USERTYPE_ID = X_USERTYPE_ID
581: AND FR.APPLICATION_ID = UT.APPLICATION_ID
582: AND FR.RESPONSIBILITY_KEY = UT.RESPONSIBILITY_KEY
583: AND (UT.EFFECTIVE_END_DATE IS NULL OR UT.EFFECTIVE_END_DATE > SYSDATE)

Line 980: jtf_um_usertype_resp where usertype_id = l_usertype_id

976: l_application_id NUMBER;
977: l_user_id NUMBER;
978:
979: cursor find_default_resp is select responsibility_key, application_id from
980: jtf_um_usertype_resp where usertype_id = l_usertype_id
981: and (effective_end_date is null or effective_end_date > sysdate) ;
982:
983: cursor find_usertype is select usertype_id from jtf_um_usertypes_b
984: where usertype_key = l_usertype_key

Line 1121: FROM JTF_UM_USERTYPE_RESP UTRESP, FND_RESPONSIBILITY_VL FURESP

1117: ) IS
1118:
1119: l_procedure_name CONSTANT varchar2(30) := 'get_usertype_resp';
1120: CURSOR FIND_UT_RESP IS SELECT UTRESP.APPLICATION_ID, FURESP.RESPONSIBILITY_ID
1121: FROM JTF_UM_USERTYPE_RESP UTRESP, FND_RESPONSIBILITY_VL FURESP
1122: WHERE UTRESP.USERTYPE_ID = p_usertype_id
1123: AND NVL(UTRESP.EFFECTIVE_END_DATE,SYSDATE+1) > SYSDATE
1124: AND UTRESP.EFFECTIVE_START_DATE < SYSDATE
1125: AND UTRESP.RESPONSIBILITY_KEY = FURESP.RESPONSIBILITY_KEY;