DBA Data[Home] [Help]

APPS.JL_AR_AUTOINV_PKG dependencies on JL_ZZ_AR_TX_CATEG

Line 185: FROM jl_zz_ar_tx_att_cls cls, jl_zz_ar_tx_categ cat

181: l_tax_category_id IS NOT NULL THEN
182: BEGIN
183: SELECT tax_attribute_name, tax_attribute_value
184: INTO l_org_attribute_name, l_org_attribute_value
185: FROM jl_zz_ar_tx_att_cls cls, jl_zz_ar_tx_categ cat
186: WHERE cls.tax_attr_class_type = 'ORGANIZATION_CLASS'
187: AND cls.tax_attr_class_code = l_organization_class_code
188: AND cls.tax_category_id = l_tax_category_id
189: AND cls.tax_category_id = cat.tax_category_id

Line 218: FROM jl_zz_ar_tx_cus_cls cus, jl_zz_ar_tx_categ cat

214: IF l_cus_cls_flag = 'Y' THEN
215: BEGIN
216: SELECT tax_attribute_name, tax_attribute_value
217: INTO l_cust_attribute_name, l_cust_attribute_value
218: FROM jl_zz_ar_tx_cus_cls cus, jl_zz_ar_tx_categ cat
219: WHERE cus.tax_attr_class_code = l_contributor_class_code
220: AND cus.address_id = trx_lines_rec.orig_system_address_id
221: AND cus.tax_category_id = l_tax_category_id
222: AND cus.tax_category_id = cat.tax_category_id

Line 241: FROM jl_zz_ar_tx_att_cls att, jl_zz_ar_tx_categ cat

237: ELSE
238: BEGIN
239: SELECT tax_attribute_name, tax_attribute_value
240: INTO l_cust_attribute_name, l_cust_attribute_value
241: FROM jl_zz_ar_tx_att_cls att, jl_zz_ar_tx_categ cat
242: WHERE att.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
243: AND att.tax_attr_class_code = l_contributor_class_code
244: AND att.tax_category_id = l_tax_category_id
245: AND att.tax_attribute_name = cat.cus_tax_attribute