DBA Data[Home] [Help]

APPS.JL_AR_DOC_NUMBERING_PKG dependencies on JL_ZZ_AR_TX_CUS_CLS_ALL

Line 577: FROM jl_zz_ar_tx_cus_cls_all cus, hz_cust_acct_sites_all cas, hz_cust_site_uses rsu

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

Line 605: FROM jl_zz_ar_tx_cus_cls_all cus, hz_cust_acct_sites cas

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