APPS.JTF_RS_TEAM_MEMBER_VUHK dependencies on CN_SALESREPS
Line 36: FROM cn_salesreps
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
Line 105: FROM cn_salesreps
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;