APPS.JTF_RS_TEAM_MEMBER_VUHK SQL Statements

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

Line: 28

    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;

Line: 35

      SELECT org_id
	FROM cn_salesreps
       WHERE resource_id = p_team_resource_id;

Line: 77

  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;

Line: 92

    select 1
    from cn_srp_comp_teams_v
    where comp_team_id = P_TEAM_ID
    and team_resource_id = P_TEAM_RESOURCE_ID;

Line: 99

      select name, start_date_active, end_date_active
      from cn_comp_teams
	where comp_team_id = P_TEAM_ID;

Line: 104

	SELECT org_id
	  FROM cn_salesreps
	 WHERE resource_id = p_team_resource_id;

Line: 143

  END delete_team_members_pre;

Line: 145

  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;

Line: 150

  END update_team_members_pre;

Line: 152

  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;

Line: 157

  END update_team_members_post;

Line: 159

  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;

Line: 166

  END delete_team_members_post;