DBA Data[Home] [Help]

APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_SRP_ROLES

Line 251: FROM cn_srp_roles

247: AND org_id = p_org_id;
248:
249: CURSOR get_roles is
250: SELECT start_date, nvl(end_date,l_end_of_time) end_date
251: FROM cn_srp_roles
252: WHERE salesrep_id = p_payee_id
253: AND org_id = p_org_id
254: AND role_id = g_payee_role;
255: