DBA Data[Home] [Help]

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;