APPS.CCT_RESOURCE_ASSIGNMENT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE
WHERE USER_ID = X_USER_ID
AND   RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
AND   RESPONSIBILITY_APPLICATION_ID = X_APPLICATION_ID;

Line: 70

SELECT RESPONSIBILITY_ID, APPLICATION_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;

Line: 102

SELECT RESPONSIBILITY_ID, APPLICATION_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;