APPS.JL_AR_DOC_NUMBERING_PKG dependencies on JL_ZZ_AR_TX_ATT_CLS

Line 525: FROM jl_zz_ar_tx_att_cls

521: l_dummy_code := NULL;
522:
523: SELECT 'Success'
524: INTO l_dummy_code
525: FROM jl_zz_ar_tx_att_cls
526: WHERE tax_attr_class_code = l_organization_class_code
527: AND tax_attr_class_type = 'ORGANIZATION_CLASS'
528: AND tax_category_id = doc_letter_rec.tax_category_id
529: AND tax_attribute_name = doc_letter_rec.org_tax_attribute_name

Line 574: FROM jl_zz_ar_tx_att_cls att

570: AND tax_attribute_value = doc_letter_rec.con_tax_attribute_value;
571: ELSE
572: SELECT 'Success'
573: INTO l_dummy_code
574: FROM jl_zz_ar_tx_att_cls att
575: WHERE tax_attr_class_type = 'CONTRIBUTOR_CLASS'
576: AND tax_attr_class_code = l_contributor_class_code
577: AND tax_category_id = doc_letter_rec.tax_category_id
578: AND tax_attribute_name = doc_letter_rec.con_tax_attribute_name

Line 601: FROM jl_zz_ar_tx_att_cls att

597: AND tax_attribute_value = doc_letter_rec.con_tax_attribute_value;
598: ELSE
599: SELECT 'Success'
600: INTO l_dummy_code
601: FROM jl_zz_ar_tx_att_cls att
602: WHERE tax_attr_class_type = 'CONTRIBUTOR_CLASS'
603: AND tax_attr_class_code = l_contributor_class_code
604: AND tax_category_id = doc_letter_rec.tax_category_id
605: AND tax_attribute_name = doc_letter_rec.con_tax_attribute_name