DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SRVC_SBSCRPTN_EXCLS

Line 1220: FROM ZX_SRVC_SBSCRPTN_EXCLS excl

1216: AND ZX_SECURITY.G_EFFECTIVE_DATE between
1217: (srvc.effective_from) AND nvl( srvc.effective_to,ZX_SECURITY.G_EFFECTIVE_DATE)
1218: AND reg.first_pty_org_id = ZX_SECURITY.G_FIRST_PARTY_ORG_ID
1219: AND NOT EXISTS (SELECT 1
1220: FROM ZX_SRVC_SBSCRPTN_EXCLS excl
1221: WHERE excl.application_id = p_application_id
1222: AND excl.entity_code = p_entity_code
1223: AND excl.event_class_code = p_event_class_code
1224: AND excl.srvc_subscription_id = srvc.srvc_subscription_id