[Home] [Help]
32: and ct.comp_team_id = P_TEAM_ID;
33:
34: CURSOR get_orgs IS
35: SELECT org_id
36: FROM cn_salesreps
37: WHERE resource_id = p_team_resource_id;
38:
39:
40: BEGIN
101: where comp_team_id = P_TEAM_ID;
102:
103: CURSOR get_orgs IS
104: SELECT org_id
105: FROM cn_salesreps
106: WHERE resource_id = p_team_resource_id;
107:
108: BEGIN
109: X_RETURN_STATUS := fnd_api.g_ret_sts_success;