DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_SRP_PERIODS

Line 3108: FROM cn_srp_periods srp,

3104: CURSOR get_role_cursor(l_period_id NUMBER,
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