APPS.JTF_UM_RESP_INFO_PVT dependencies on FND_RESPONSIBILITY_VL

Line 72: FROM FND_RESPONSIBILITY_VL FR, FND_USER_RESP_GROUPS FG

68: ) IS
69:
70: l_procedure_name CONSTANT varchar2(30) := 'GET_RESP_INFO_SOURCE';
71: CURSOR FIND_RESP_INFO IS SELECT FR.RESPONSIBILITY_ID RESP_ID, FR.APPLICATION_ID APP_ID, FR.RESPONSIBILITY_NAME RESP_NAME, FR.RESPONSIBILITY_KEY RESP_KEY
72: FROM FND_RESPONSIBILITY_VL FR, FND_USER_RESP_GROUPS FG
73: WHERE FR.RESPONSIBILITY_ID = FG.RESPONSIBILITY_ID
74: AND FR.APPLICATION_ID = FG.RESPONSIBILITY_APPLICATION_ID
75: AND FG.USER_ID = p_user_id
76: AND NVL(FG.END_DATE, SYSDATE +1) > SYSDATE

Line 81: l_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;

77: AND FG.START_DATE < SYSDATE
78: AND FR.VERSION = 'W'
79: ORDER BY FR.RESPONSIBILITY_NAME;
80:
81: l_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
82:
83: CURSOR FIND_RESP_SOURCE IS
84: SELECT SOURCE_TYPE, SOURCE_NAME FROM
85: (