DBA Data[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_SRVC_SBSCRPTN_EXCLS

Line 1307: FROM ZX_SRVC_SBSCRPTN_EXCLS excl

1303: BETWEEN srvc.effective_from
1304: AND NVL(srvc.effective_to,Taxlines.subscription_date)
1305: AND reg.first_pty_org_id = g_first_pty_org_id
1306: AND NOT EXISTS (SELECT 1
1307: FROM ZX_SRVC_SBSCRPTN_EXCLS excl
1308: WHERE excl.application_id = TaxLines.application_id
1309: AND excl.entity_code = TaxLines.entity_code
1310: AND excl.event_class_code = TaxLines.event_class_code
1311: AND excl.srvc_subscription_id = srvc_subscription_id