573: --
574: IF l_cus_cls_flag = 'Y' THEN
575: SELECT 'Success'
576: INTO l_dummy_code
577: FROM jl_zz_ar_tx_cus_cls_all cus, hz_cust_acct_sites_all cas, hz_cust_site_uses rsu
578: WHERE tax_attr_class_code = l_contributor_class_code
579: AND rsu.site_use_id = p_ship_to_address_id
580: AND cas.cust_acct_site_id = cus.address_id
581: AND rsu.cust_acct_site_id = cas.cust_acct_site_id
601: WHERE cas.cust_acct_site_id = p_ship_to_address_id;
602: IF l_cus_cls_flag = 'Y' THEN
603: SELECT 'Success'
604: INTO l_dummy_code
605: FROM jl_zz_ar_tx_cus_cls_all cus, hz_cust_acct_sites cas
606: WHERE tax_attr_class_code = l_contributor_class_code
607: AND cas.cust_acct_site_id = cus.address_id
608: AND cas.cust_acct_site_id = p_ship_to_address_id
609: AND tax_category_id = doc_letter_rec.tax_category_id