[Home] [Help]
986: NVL(srvc.effective_to,
987: lines.subscription_date)
988: AND reg.first_pty_org_id = g_first_pty_org_id
989: AND NOT EXISTS (SELECT 1
990: FROM ZX_SRVC_SBSCRPTN_EXCLS excl
991: WHERE excl.application_id = TaxLines.application_id
992: AND excl.entity_code = TaxLines.entity_code
993: AND excl.event_class_code = TaxLines.event_class_code
994: AND excl.srvc_subscription_id = srvc_subscription_id