APPS.JL_ZZ_AR_TX_LIB_PKG dependencies on JL_ZZ_AR_TX_CUS_CLS

Line 257: FROM jl_zz_ar_tx_cus_cls

253:
254: BEGIN
255: SELECT count(*)
256: INTO l_cnt
257: FROM jl_zz_ar_tx_cus_cls
258: WHERE address_id = p_address_id
259: AND tax_attr_class_code = p_contributor_class_code;
260:
261: IF l_cnt > 0 THEN

Line 282: -- Bugfix 1783986. Customer Site Profile values (JL_ZZ_AR_TX_CUS_CLS) should not

278: l_dummy NUMBER(15);
279:
280: BEGIN
281:
282: -- Bugfix 1783986. Customer Site Profile values (JL_ZZ_AR_TX_CUS_CLS) should not
283: -- be populated with values from JL_ZZ_AR_TX_ATT_CLS due to functional change in
284: -- populating such records. Only changed records of Contributor Class Code will
285: -- be stored in Customer Site Profile (JL_ZZ_AR_TX_CUS_CLS)
286: --

Line 285: -- be stored in Customer Site Profile (JL_ZZ_AR_TX_CUS_CLS)

281:
282: -- Bugfix 1783986. Customer Site Profile values (JL_ZZ_AR_TX_CUS_CLS) should not
283: -- be populated with values from JL_ZZ_AR_TX_ATT_CLS due to functional change in
284: -- populating such records. Only changed records of Contributor Class Code will
285: -- be stored in Customer Site Profile (JL_ZZ_AR_TX_CUS_CLS)
286: --
287: -- A data cleanup script (JLZZUCAC) is provided to match existing records of
288: -- JL_ZZ_AR_TX_ATT_CLS and JL_ZZ_AR_TX_CUS_CLS for Contributor Class code and
289: -- will update HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9 with 'Y' if there are

Line 288: -- JL_ZZ_AR_TX_ATT_CLS and JL_ZZ_AR_TX_CUS_CLS for Contributor Class code and

284: -- populating such records. Only changed records of Contributor Class Code will
285: -- be stored in Customer Site Profile (JL_ZZ_AR_TX_CUS_CLS)
286: --
287: -- A data cleanup script (JLZZUCAC) is provided to match existing records of
288: -- JL_ZZ_AR_TX_ATT_CLS and JL_ZZ_AR_TX_CUS_CLS for Contributor Class code and
289: -- will update HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9 with 'Y' if there are
290: -- differences and will update with 'N' if there are NO differences where
291: -- HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE8 is NOT NULL.
292: --

Line 294: -- JL_ZZ_AR_TX_CUS_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='Y' and

290: -- differences and will update with 'N' if there are NO differences where
291: -- HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE8 is NOT NULL.
292: --
293: -- For records whose GLOBAL_ATTRIBUTE8 is NOT NULL, Tax Engine would look
294: -- JL_ZZ_AR_TX_CUS_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='Y' and
295: -- JL_ZZ_AR_TX_ATT_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='N'
296: -- NULL value of GLOBAL_ATTRIBUTE9 will be interpreted as 'Y'
297:
298: return;

Line 306: FROM jl_zz_ar_tx_cus_cls

302:
303: BEGIN
304: SELECT count(*)
305: INTO l_dummy
306: FROM jl_zz_ar_tx_cus_cls
307: WHERE address_id = p_address_id
308: AND tax_attr_class_code = p_contributor_class_code;
309: EXCEPTION
310: WHEN OTHERS THEN

Line 315: JL_ZZ_AR_TX_CUS_CLS_PKG.Populate_Cus_Cls_Rows(

311: l_dummy := 0;
312: END;
313:
314: IF l_dummy = 0 THEN
315: JL_ZZ_AR_TX_CUS_CLS_PKG.Populate_Cus_Cls_Rows(
316: X_address_id => p_address_id,
317: X_class_code => p_contributor_class_code);
318:
319: END IF;