The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ct.name, ct.start_date_active, ct.end_date_active
from cn_srp_comp_teams_v srpt, cn_comp_teams ct
where srpt.comp_team_id = P_TEAM_ID
and srpt.team_resource_id = P_TEAM_RESOURCE_ID
and ct.comp_team_id = P_TEAM_ID;
SELECT org_id
FROM cn_salesreps
WHERE resource_id = p_team_resource_id;
PROCEDURE delete_team_members_pre
(P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
l_dummy NUMBER;
select 1
from cn_srp_comp_teams_v
where comp_team_id = P_TEAM_ID
and team_resource_id = P_TEAM_RESOURCE_ID;
select name, start_date_active, end_date_active
from cn_comp_teams
where comp_team_id = P_TEAM_ID;
SELECT org_id
FROM cn_salesreps
WHERE resource_id = p_team_resource_id;
END delete_team_members_pre;
PROCEDURE update_team_members_pre
(P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
BEGIN
x_return_status := fnd_api.g_ret_sts_success;
END update_team_members_pre;
PROCEDURE update_team_members_post
(P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
BEGIN
x_return_status := fnd_api.g_ret_sts_success;
END update_team_members_post;
PROCEDURE delete_team_members_post
(P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
BEGIN
x_return_status := fnd_api.g_ret_sts_success;
END delete_team_members_post;