APPS.JL_AR_DOC_NUMBERING_PKG dependencies on HZ_CUST_SITE_USES

Line 489: hz_cust_site_uses rsu

485: BEGIN
486: SELECT adr.global_attribute8
487: INTO l_contributor_class_code
488: FROM hz_cust_acct_sites_all adr,
489: hz_cust_site_uses rsu
490: WHERE rsu.site_use_id = p_ship_to_address_id
491: AND rsu.cust_acct_site_id = adr.cust_acct_site_id;
492: END;
493: IF l_contributor_class_code is null then

Line 556: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses rsu

552: END IF;
553: IF p_created_from = 'ARXTWMAI' THEN
554: SELECT nvl(cas.global_attribute9,'N')
555: INTO l_cus_cls_flag
556: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses rsu
557: WHERE rsu.site_use_id = p_ship_to_address_id
558: AND rsu.cust_acct_site_id = cas.cust_acct_site_id;
559: --
560: IF l_cus_cls_flag = 'Y' THEN

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

559: --
560: IF l_cus_cls_flag = 'Y' THEN
561: SELECT 'Success'
562: INTO l_dummy_code
563: FROM jl_zz_ar_tx_cus_cls_all cus, hz_cust_acct_sites_all cas, hz_cust_site_uses rsu
564: WHERE tax_attr_class_code = l_contributor_class_code
565: AND rsu.site_use_id = p_ship_to_address_id
566: AND cas.cust_acct_site_id = cus.address_id
567: AND rsu.cust_acct_site_id = cas.cust_acct_site_id