APPS.CCT_RESOURCE_ASSIGNMENT dependencies on FND_RESPONSIBILITY_VL

Line 18: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;

14: )
15: IS
16: l_def_resp_id NUMBER;
17: l_def_app_id NUMBER;
18: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
19: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
20:
21: BEGIN
22: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(

Line 19: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;

15: IS
16: l_def_resp_id NUMBER;
17: l_def_app_id NUMBER;
18: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
19: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
20:
21: BEGIN
22: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(
23: user_id => X_USER_ID,

Line 71: FROM FND_RESPONSIBILITY_VL

67: p_application_id NUMBER;
68: CURSOR RESP_KEY
69: IS
70: SELECT RESPONSIBILITY_ID, APPLICATION_ID
71: FROM FND_RESPONSIBILITY_VL
72: WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;
73: BEGIN
74:
75: OPEN RESP_KEY;

Line 103: FROM FND_RESPONSIBILITY_VL

99: p_responsibility_id NUMBER;
100: p_application_id NUMBER;
101: CURSOR RESP_KEY_ID IS
102: SELECT RESPONSIBILITY_ID, APPLICATION_ID
103: FROM FND_RESPONSIBILITY_VL
104: WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;
105: BEGIN
106:
107: OPEN RESP_KEY_ID;