DBA Data[Home] [Help]

APPS.ZX_TCM_GET_DEF_EXEMPTION dependencies on ZX_REGIMES_B

Line 124: ptp_party_site.party_id = ps.party_site_id) v, zx_regimes_b zxr

120: Lkp.lookup_type = 'ZX_EXEMPTION_REASON_CODE' and
121: ex.exemption_status_code in ( 'PRIMARY', 'MANUAL', 'UNAPPROVED' ) and
122: ex.party_tax_profile_id = ptp_party_site.party_tax_profile_id and
123: ptp_party_site.party_type_code = 'THIRD_PARTY_SITE' and
124: ptp_party_site.party_id = ps.party_site_id) v, zx_regimes_b zxr
125: WHERE
126: v.content_owner_id = p_ptp_id
127: AND v.tax_regime_code = zxr.tax_regime_code
128: AND nvl(v.EXEMPT_CERTIFICATE_NUMBER, -99) = nvl(p_exempt_certificate_number, -99)