APPS.CN_API dependencies on CN_SRP_PLAN_ASSIGNS

Line 3109: cn_srp_plan_assigns assign,

3105: l_salesrep_id IN NUMBER)
3106: IS
3107: SELECT distinct r.name role_name,assign.start_date
3108: FROM cn_srp_periods srp,
3109: cn_srp_plan_assigns assign,
3110: cn_roles r
3111: WHERE assign.srp_plan_assign_id(+)= srp.srp_plan_assign_id
3112: AND srp.period_id = l_period_id
3113: AND assign.role_id = r.role_id(+)