110: PROCEDURE Comp_Plan_Event( X_comp_plan_id IN number) IS
111:
112: X_event_log_id NUMBER(15) ;
113: X_plan_name cn_comp_plans.name%TYPE;
114: X_owner_id cn_salesreps.assigned_to_user_id%TYPE;
115: X_rep_id cn_salesreps.salesrep_id%TYPE;
116: X_rep_name cn_salesreps.name%TYPE;
117:
118:
111:
112: X_event_log_id NUMBER(15) ;
113: X_plan_name cn_comp_plans.name%TYPE;
114: X_owner_id cn_salesreps.assigned_to_user_id%TYPE;
115: X_rep_id cn_salesreps.salesrep_id%TYPE;
116: X_rep_name cn_salesreps.name%TYPE;
117:
118:
119: CURSOR A1_cursor IS
112: X_event_log_id NUMBER(15) ;
113: X_plan_name cn_comp_plans.name%TYPE;
114: X_owner_id cn_salesreps.assigned_to_user_id%TYPE;
115: X_rep_id cn_salesreps.salesrep_id%TYPE;
116: X_rep_name cn_salesreps.name%TYPE;
117:
118:
119: CURSOR A1_cursor IS
120: SELECT sr.salesrep_id, sr.name, sr.assigned_to_user_id
117:
118:
119: CURSOR A1_cursor IS
120: SELECT sr.salesrep_id, sr.name, sr.assigned_to_user_id
121: FROM cn_salesreps sr
122: WHERE sr.salesrep_id IN (SELECT pa.salesrep_id
123: FROM cn_srp_plan_assigns pa
124: WHERE pa.comp_plan_id = X_comp_plan_id) ;
125: