DBA Data[Home] [Help]

APPS.JL_AR_AUTOINV_PKG dependencies on JL_ZZ_AR_TX_ATT_CLS

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 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