DBA Data[Home] [Help]

APPS.ZX_API_PUB dependencies on ZX_REGIMES_USAGES

Line 180: from zx_regimes_usages zru

176: FROM zx_srvc_subscriptions zss
177: WHERE zss.enabled_flag = 'Y'
178: AND zss.prod_family_grp_code = nvl(p_event_class_rec.prod_family_grp_code, zss.prod_family_grp_code)
179: AND exists (select zru.regime_usage_id
180: from zx_regimes_usages zru
181: where zru.regime_usage_id = zss.regime_usage_id
182: and zru.first_pty_org_id = nvl(p_event_class_rec.first_pty_org_id, zru.first_pty_org_id))
183: AND rownum = 1;
184: EXCEPTION WHEN OTHERS THEN