APPS.JTF_RS_TEAM_MEMBER_VUHK dependencies on CN_SRP_COMP_TEAMS_V

Line 29: from cn_srp_comp_teams_v srpt, cn_comp_teams ct

25:
26: -- identify that the resource is a rep and the team is salescomp
27: CURSOR c_team_member IS
28: select ct.name, ct.start_date_active, ct.end_date_active
29: from cn_srp_comp_teams_v srpt, cn_comp_teams ct
30: where srpt.comp_team_id = P_TEAM_ID
31: and srpt.team_resource_id = P_TEAM_RESOURCE_ID
32: and ct.comp_team_id = P_TEAM_ID;
33:

Line 93: from cn_srp_comp_teams_v

89:
90: -- identify that the resoiurce is a rep and the team is salescomp
91: CURSOR c_member IS
92: select 1
93: from cn_srp_comp_teams_v
94: where comp_team_id = P_TEAM_ID
95: and team_resource_id = P_TEAM_RESOURCE_ID;
96:
97: -- get team info