DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on CN_RS_SALESREPS

Line 45: from cn_rs_salesreps s, jtf_rs_resource_extns re

41: where period_id = p_period_id and org_id=p_org_id;
42:
43: cursor get_salesrep (a_user_id number,a_org_id number) is
44: select s.salesrep_id
45: from cn_rs_salesreps s, jtf_rs_resource_extns re
46: where re.user_id = a_user_id and s.resource_id = re.resource_id
47: and s.org_id = a_org_id;
48:
49: BEGIN