APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on JL_ZZ_AR_TX_ATT_CLS_ALL

Line 1492: FROM JL_ZZ_AR_TX_ATT_CLS_ALL TTA --Bugfix 2367111

1488: -- Match with Attribute Value of Transaction Class Type
1489: BEGIN
1490: SELECT TTA.TAX_ATTRIBUTE_VALUE
1491: INTO l_tta_attrib_value
1492: FROM JL_ZZ_AR_TX_ATT_CLS_ALL TTA --Bugfix 2367111
1493: WHERE TTA.TAX_ATTRIBUTE_VALUE
1494: = c_tax_categ_rec.transaction_nature
1495: AND TTA.TAX_ATTR_CLASS_TYPE = 'TRANSACTION_CLASS'
1496: AND TTA.TAX_CATEGORY_ID = c_tax_categ_rec.tax_category_id

Line 1536: FROM JL_ZZ_AR_TX_ATT_CLS_ALL OTA --Bugfix 2367111

1532: -- Match with Attribute Value of Organization Class Type
1533: BEGIN
1534: SELECT OTA.TAX_ATTRIBUTE_VALUE
1535: INTO l_ota_attrib_value
1536: FROM JL_ZZ_AR_TX_ATT_CLS_ALL OTA --Bugfix 2367111
1537: WHERE OTA.TAX_ATTRIBUTE_VALUE = c_tax_categ_rec.establishment_type
1538: AND OTA.TAX_ATTR_CLASS_TYPE = 'ORGANIZATION_CLASS'
1539: AND OTA.TAX_CATEGORY_ID = c_tax_categ_rec.tax_category_id
1540: AND OTA.TAX_ATTRIBUTE_TYPE = 'ORGANIZATION_ATTRIBUTE'

Line 1590: FROM JL_ZZ_AR_TX_ATT_CLS_ALL CTA --Bugfix 2367111

1586: AND nvl(cta.org_id,-99) = nvl(l_org_id,-99); --Bugfix 2367111
1587: ELSE
1588: SELECT CTA.TAX_ATTRIBUTE_VALUE
1589: INTO l_cta_attrib_value
1590: FROM JL_ZZ_AR_TX_ATT_CLS_ALL CTA --Bugfix 2367111
1591: WHERE CTA.TAX_ATTRIBUTE_VALUE = c_tax_categ_rec.contributor_type
1592: AND CTA.TAX_ATTR_CLASS_TYPE = 'CONTRIBUTOR_CLASS'
1593: AND CTA.TAX_ATTRIBUTE_TYPE = 'CONTRIBUTOR_ATTRIBUTE'
1594: AND CTA.TAX_CATEGORY_ID = c_tax_categ_rec.tax_category_id