APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on JL_ZZ_AR_TX_CUS_CLS

Line 699: FROM JL_ZZ_AR_TX_CUS_CLS CTA

695: AND ATC.ENABLED_FLAG = 'Y'
696: AND ATC.TAX_ATTR_CLASS_CODE = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10
697: AND nvl(tgr.org_id,-99) = nvl(atc.org_id,-99)) --Bugfix 2367111)
698: AND EXISTS (SELECT CTA.TAX_ATTRIBUTE_VALUE
699: FROM JL_ZZ_AR_TX_CUS_CLS CTA
700: WHERE CTA.ADDRESS_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8
701: AND CTA.TAX_ATTR_CLASS_CODE = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6
702: AND CTA.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
703: AND CTA.TAX_ATTRIBUTE_NAME = TXC.CUS_TAX_ATTRIBUTE

Line 754: FROM JL_ZZ_AR_TX_CUS_CLS CTA

750: AND ATC.ENABLED_FLAG = 'Y'
751: AND ATC.TAX_ATTR_CLASS_CODE =
752: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10)
753: AND EXISTS (SELECT CTA.TAX_ATTRIBUTE_VALUE
754: FROM JL_ZZ_AR_TX_CUS_CLS CTA
755: WHERE CTA.ADDRESS_ID =
756: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8
757: AND CTA.TAX_ATTR_CLASS_CODE =
758: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6

Line 1152: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Using JL_ZZ_AR_TX_CUS_CLS for Contributor Class');

1148:
1149: -- Check if Override Customer Site Profile is set to 'Y'
1150: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
1151: IF (g_level_statement >= g_current_runtime_level ) THEN
1152: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Using JL_ZZ_AR_TX_CUS_CLS for Contributor Class');
1153: END IF;
1154:
1155: -- Fetch Tax Group details
1156: FOR c_grp_code_cus_rec IN c_grp_code_cus

Line 1453: l_cta_attrib_value jl_zz_ar_tx_cus_cls.tax_attribute_value%type;

1449:
1450: DECLARE
1451: l_tta_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;
1452: l_ota_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;
1453: l_cta_attrib_value jl_zz_ar_tx_cus_cls.tax_attribute_value%type;
1454:
1455: CURSOR c_tax_categ IS
1456: SELECT TGR.TAX_CATEGORY_ID,
1457: TGR.CALCULATE_IN_OE,

Line 1579: FROM JL_ZZ_AR_TX_CUS_CLS_ALL CTA --Bugfix 2367111

1575: BEGIN
1576: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
1577: SELECT CTA.TAX_ATTRIBUTE_VALUE
1578: INTO l_cta_attrib_value
1579: FROM JL_ZZ_AR_TX_CUS_CLS_ALL CTA --Bugfix 2367111
1580: WHERE CTA.TAX_ATTRIBUTE_VALUE = c_tax_categ_rec.contributor_type
1581: AND CTA.ADDRESS_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8
1582: AND CTA.TAX_CATEGORY_ID = c_tax_categ_rec.tax_category_id
1583: AND CTA.TAX_ATTRIBUTE_NAME = c_tax_categ_rec.cus_tax_attribute

Line 1707: 'Using JL_ZZ_AR_TX_CUS_CLS for Contributor Class');

1703:
1704: IF (g_level_statement >= g_current_runtime_level ) THEN
1705: FND_LOG.STRING(g_level_statement,
1706: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1707: 'Using JL_ZZ_AR_TX_CUS_CLS for Contributor Class');
1708: END IF;
1709:
1710: OPEN c_grp_code_cus_cm;
1711: FETCH c_grp_code_cus_cm INTO