APPS.CN_QUOTA_RULE_UPLIFTS_T1 dependencies on FND_API

Line 53: OR TRUNC(NVL(:OLD.end_date, fnd_api.g_miss_date)) <>

49: , p_org_id => l_org_id
50: );
51: ELSIF UPDATING THEN
52: IF TRUNC(:OLD.start_date) <> TRUNC(:NEW.start_date)
53: OR TRUNC(NVL(:OLD.end_date, fnd_api.g_miss_date)) <>
54: TRUNC(NVL(:NEW.end_date, fnd_api.g_miss_date)) THEN
55: BEGIN
56: SELECT q.NAME, q.quota_id, q.org_id INTO l_name, l_quota_id, l_org_id
57: FROM cn_quotas_all q, cn_quota_rules_all qr

Line 54: TRUNC(NVL(:NEW.end_date, fnd_api.g_miss_date)) THEN

50: );
51: ELSIF UPDATING THEN
52: IF TRUNC(:OLD.start_date) <> TRUNC(:NEW.start_date)
53: OR TRUNC(NVL(:OLD.end_date, fnd_api.g_miss_date)) <>
54: TRUNC(NVL(:NEW.end_date, fnd_api.g_miss_date)) THEN
55: BEGIN
56: SELECT q.NAME, q.quota_id, q.org_id INTO l_name, l_quota_id, l_org_id
57: FROM cn_quotas_all q, cn_quota_rules_all qr
58: WHERE q.quota_id = qr.quota_id AND qr.quota_rule_id = :OLD.quota_rule_id;