DBA Data[Home] [Help]

APPS.ZX_TCM_GET_DEF_EXEMPTION dependencies on FND_LOOKUPS

Line 83: zx_exemptions ex, fnd_lookups lkp,

79: Ex.RATE_MODIFIER,
80: Ex.TAX_JURISDICTION_ID,
81: Ex.PARTY_TAX_PROFILE_ID
82: FROM
83: zx_exemptions ex, fnd_lookups lkp,
84: zx_party_tax_profile ptp_party
85: WHERE
86: Ex.exempt_reason_code = lkp.lookup_code and
87: Lkp.lookup_type = 'ZX_EXEMPTION_REASON_CODE' and

Line 116: zx_exemptions ex, fnd_lookups lkp,

112: Ex.RATE_MODIFIER,
113: Ex.TAX_JURISDICTION_ID,
114: Ex.PARTY_TAX_PROFILE_ID
115: FROM
116: zx_exemptions ex, fnd_lookups lkp,
117: zx_party_tax_profile ptp_party_site, hz_party_sites ps
118: WHERE
119: Ex.exempt_reason_code = lkp.lookup_code and
120: Lkp.lookup_type = 'ZX_EXEMPTION_REASON_CODE' and