APPS.CN_RT_QUOTA_ASGNS_T1 dependencies on FND_API

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

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

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

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