DBA Data[Home] [Help]

APPS.CN_EVENT_LOG_PKG dependencies on CN_COMP_PLANS

Line 113: X_plan_name cn_comp_plans.name%TYPE;

109:
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:

Line 132: FROM cn_comp_plans

128: BEGIN
129: -- Get Comp Plan Name.
130: SELECT name
131: INTO X_plan_name
132: FROM cn_comp_plans
133: WHERE comp_plan_id = X_comp_plan_id ;
134:
135: EXCEPTION
136: WHEN no_data_found THEN