DBA Data[Home] [Help]

APPS.ZX_TCM_GET_EXEMPT_PKG dependencies on ZX_SECURITY

Line 567: nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)

563: and exempt_reason_code = p_reason_code
564: and party_tax_profile_id = p_bill_to_party_ptp_id
565: and tax_regime_code = p_tax_regime_code
566: and content_owner_id =
567: nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)
568: and nvl(tax_status_code,'X') = nvl(p_tax_status_code,'X')
569: and nvl(tax,'X') = nvl(p_tax,'X')
570: and nvl(tax_jurisdiction_id,-999) = nvl(l_tax_jurisdiction_id,-999)
571: and exemption_status_code = 'UNAPPROVED';

Line 607: 'Content owner id '||to_char(nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)) || ' ' ||

603: 'Tax Regime Code '|| p_TAX_REGIME_CODE || ' '||
604: 'Tax '|| p_TAX || ' '||
605: 'Tax Status Code ' ||p_TAX_STATUS_CODE || ' ' ||
606: 'Tax Rate Code '||p_tax_rate_code || ' ' ||
607: 'Content owner id '||to_char(nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID)) || ' ' ||
608: 'Exemption Certificate Number '|| p_exempt_certificate_number || ' ' ||
609: 'Reason Code '|| p_REASON_CODE || ' ' ||
610: 'Start Date '|| to_char(nvl(l_start_date, trunc(sysdate))) || ' ' ||
611: 'Bill to party ptp id '|| to_char(p_bill_to_party_ptp_id) || ' ' ||

Line 653: nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID),

649: p_TAX_REGIME_CODE,
650: p_TAX,
651: p_TAX_STATUS_CODE,
652: p_tax_rate_code,
653: nvl(p_event_class_rec.first_pty_org_id,ZX_SECURITY.G_FIRST_PARTY_ORG_ID),
654: p_exempt_certificate_number,
655: p_REASON_CODE,
656: nvl(l_start_date, trunc(sysdate)),
657: p_bill_to_party_ptp_id,