[Home] [Help]
8: x_org_id NUMBER;
9: x_start_date DATE;
10: x_end_date DATE;
11: BEGIN
12: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN
13: IF (:NEW.commission_amount <> :OLD.commission_amount) THEN
14: SELECT srp.NAME, srp.org_id INTO x_salesrep_name, x_org_id
15: FROM cn_salesreps srp, cn_srp_plan_assigns_all PLAN
16: WHERE srp.salesrep_id = PLAN.salesrep_id