DBA Data[Home] [Help]

APPS.CN_SRP_RULE_UPLIFTS_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.payment_factor <> :OLD.payment_factor) OR(:NEW.quota_factor <> :OLD.quota_factor) 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, cn_srp_quota_rules_all rule
16: WHERE rule.srp_quota_rule_id = :NEW.srp_quota_rule_id