APPS.JTF_RS_TEAM_MEMBER_VUHK dependencies on CN_COMP_TEAMS

Line 20: t_team_name cn_comp_teams.name%type;

16: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
17: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
19:
20: t_team_name cn_comp_teams.name%type;
21: t_start_date_active cn_comp_teams.start_date_active%type;
22: t_end_date_active cn_comp_teams.end_date_active%type;
23: l_orig_org_id NUMBER;
24: l_orig_acc_mode VARCHAR2(1);

Line 21: t_start_date_active cn_comp_teams.start_date_active%type;

17: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
19:
20: t_team_name cn_comp_teams.name%type;
21: t_start_date_active cn_comp_teams.start_date_active%type;
22: t_end_date_active cn_comp_teams.end_date_active%type;
23: l_orig_org_id NUMBER;
24: l_orig_acc_mode VARCHAR2(1);
25:

Line 22: t_end_date_active cn_comp_teams.end_date_active%type;

18: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
19:
20: t_team_name cn_comp_teams.name%type;
21: t_start_date_active cn_comp_teams.start_date_active%type;
22: t_end_date_active cn_comp_teams.end_date_active%type;
23: l_orig_org_id NUMBER;
24: l_orig_acc_mode VARCHAR2(1);
25:
26: -- identify that the resource is a rep and the team is salescomp

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 84: t_team_name cn_comp_teams.name%type;

80: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
82:
83: l_dummy NUMBER;
84: t_team_name cn_comp_teams.name%type;
85: t_start_date_active cn_comp_teams.start_date_active%type;
86: t_end_date_active cn_comp_teams.end_date_active%type;
87: l_orig_org_id NUMBER;
88: l_orig_acc_mode VARCHAR2(1);

Line 85: t_start_date_active cn_comp_teams.start_date_active%type;

81: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
82:
83: l_dummy NUMBER;
84: t_team_name cn_comp_teams.name%type;
85: t_start_date_active cn_comp_teams.start_date_active%type;
86: t_end_date_active cn_comp_teams.end_date_active%type;
87: l_orig_org_id NUMBER;
88: l_orig_acc_mode VARCHAR2(1);
89:

Line 86: t_end_date_active cn_comp_teams.end_date_active%type;

82:
83: l_dummy NUMBER;
84: t_team_name cn_comp_teams.name%type;
85: t_start_date_active cn_comp_teams.start_date_active%type;
86: t_end_date_active cn_comp_teams.end_date_active%type;
87: l_orig_org_id NUMBER;
88: l_orig_acc_mode VARCHAR2(1);
89:
90: -- identify that the resoiurce is a rep and the team is salescomp

Line 100: from cn_comp_teams

96:
97: -- get team info
98: CURSOR c_team_info IS
99: select name, start_date_active, end_date_active
100: from cn_comp_teams
101: where comp_team_id = P_TEAM_ID;
102:
103: CURSOR get_orgs IS
104: SELECT org_id