APPS.CN_SRP_RATE_ASSIGNS_T1 dependencies on FND_PROFILE
Line 12: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN
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