APPS.JL_AR_DOC_NUMBERING_PKG dependencies on HZ_CUST_ACCT_SITES

Line 502: FROM hz_cust_acct_sites_all adr,

498: IF p_created_from = 'ARXTWMAI' THEN
499: BEGIN
500: SELECT adr.global_attribute8
501: INTO l_contributor_class_code
502: FROM hz_cust_acct_sites_all adr,
503: hz_cust_site_uses rsu
504: WHERE rsu.site_use_id = p_ship_to_address_id
505: AND rsu.cust_acct_site_id = adr.cust_acct_site_id;
506: END;

Line 515: FROM hz_cust_acct_sites cas

511: ELSIF p_created_from = 'RAXTRX' THEN
512: BEGIN
513: SELECT cas.global_attribute8
514: INTO l_contributor_class_code
515: FROM hz_cust_acct_sites cas
516: WHERE cas.cust_acct_site_id = p_ship_to_address_id;
517: END;
518: IF l_contributor_class_code is null then
519: l_return_code := 'ERROR';

Line 570: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses rsu

566: END IF;
567: IF p_created_from = 'ARXTWMAI' THEN
568: SELECT nvl(cas.global_attribute9,'N')
569: INTO l_cus_cls_flag
570: FROM hz_cust_acct_sites_all cas, hz_cust_site_uses rsu
571: WHERE rsu.site_use_id = p_ship_to_address_id
572: AND rsu.cust_acct_site_id = cas.cust_acct_site_id;
573: --
574: IF l_cus_cls_flag = 'Y' THEN

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 600: FROM hz_cust_acct_sites cas

596:
597: ELSE
598: SELECT nvl(cas.global_attribute9,'N')
599: INTO l_cus_cls_flag
600: FROM 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

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