APPS.JTF_RS_TEAM_USAGE_VUHK SQL Statements

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

Line: 28

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

Line: 34

       SELECT org_id
         FROM cn_repositories_all
        WHERE status = 'A';

Line: 76

  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;

Line: 90

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

Line: 95

       SELECT org_id
         FROM cn_repositories_all
        WHERE status = 'A';

Line: 134

  END delete_team_usage_pre;

Line: 144

  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;

Line: 150

  END delete_team_usage_post;