APPS.JL_AR_DOC_NUMBERING_PKG dependencies on JL_ZZ_AR_TX_ATT_CLS

Line 539: FROM jl_zz_ar_tx_att_cls

535: l_dummy_code := NULL;
536:
537: SELECT 'Success'
538: INTO l_dummy_code
539: FROM jl_zz_ar_tx_att_cls
540: WHERE tax_attr_class_code = l_organization_class_code
541: AND tax_attr_class_type = 'ORGANIZATION_CLASS'
542: AND tax_category_id = doc_letter_rec.tax_category_id
543: AND tax_attribute_name = doc_letter_rec.org_tax_attribute_name

Line 588: FROM jl_zz_ar_tx_att_cls att

584: AND tax_attribute_value = doc_letter_rec.con_tax_attribute_value;
585: ELSE
586: SELECT 'Success'
587: INTO l_dummy_code
588: FROM jl_zz_ar_tx_att_cls att
589: WHERE tax_attr_class_type = 'CONTRIBUTOR_CLASS'
590: AND tax_attr_class_code = l_contributor_class_code
591: AND tax_category_id = doc_letter_rec.tax_category_id
592: AND tax_attribute_name = doc_letter_rec.con_tax_attribute_name

Line 615: FROM jl_zz_ar_tx_att_cls att

611: AND tax_attribute_value = doc_letter_rec.con_tax_attribute_value;
612: ELSE
613: SELECT 'Success'
614: INTO l_dummy_code
615: FROM jl_zz_ar_tx_att_cls att
616: WHERE tax_attr_class_type = 'CONTRIBUTOR_CLASS'
617: AND tax_attr_class_code = l_contributor_class_code
618: AND tax_category_id = doc_letter_rec.tax_category_id
619: AND tax_attribute_name = doc_letter_rec.con_tax_attribute_name