APPS.IMC_THREE_SIXTY_SSM_QUERY_PKG dependencies on IMC_THREE_SIXTY_SSM_QUERY_S

Line 15: CURSOR C2 IS SELECT IMC_THREE_SIXTY_SSM_QUERY_S.nextval FROM sys.dual;

11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER,
13: X_OBJECT_VERSION_NUMBER in NUMBER
14: ) IS
15: CURSOR C2 IS SELECT IMC_THREE_SIXTY_SSM_QUERY_S.nextval FROM sys.dual;
16: begin
17: IF ( X_SSM_QUERY_ID IS NULL) OR (X_SSM_QUERY_ID = FND_API.G_MISS_NUM) THEN
18: OPEN C2;
19: FETCH C2 INTO X_SSM_QUERY_ID;

Line 108: update IMC_THREE_SIXTY_SSM_QUERY set

104: X_OBJECT_VERSION_NUMBER in NUMBER
105: ) is
106:
107: begin
108: update IMC_THREE_SIXTY_SSM_QUERY set
109: APPLICATION_ID = X_APPLICATION_ID,
110: SSM_QUERY_STRING = X_SSM_QUERY_STRING,
111: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
112: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,