The following lines contain the word 'select', 'insert', 'update' or 'delete':
select name, start_date_active, end_date_active
from cn_comp_teams
where comp_team_id = P_TEAM_ID;
SELECT org_id
FROM cn_repositories_all
WHERE status = 'A';
PROCEDURE delete_team_usage_pre
(P_TEAM_ID IN NUMBER,
P_USAGE IN VARCHAR2,
X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
t_team_name cn_comp_teams.name%type;
select name, start_date_active, end_date_active
from cn_comp_teams
where comp_team_id = P_TEAM_ID;
SELECT org_id
FROM cn_repositories_all
WHERE status = 'A';
END delete_team_usage_pre;
PROCEDURE delete_team_usage_post
(P_TEAM_ID IN NUMBER,
P_USAGE IN VARCHAR2,
X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
BEGIN
x_return_status := fnd_api.g_ret_sts_success;
END delete_team_usage_post;