DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SRVC_SBSCRPTN_EXCLS

Line 1344: FROM ZX_SRVC_SBSCRPTN_EXCLS excl

1340: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1341: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1342: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1343: AND NOT EXISTS (SELECT 1
1344: FROM ZX_SRVC_SBSCRPTN_EXCLS excl
1345: WHERE excl.application_id = p_application_id
1346: AND excl.entity_code = p_entity_code
1347: AND excl.event_class_code = p_event_class_code
1348: AND excl.srvc_subscription_id = srvc.srvc_subscription_id