APPS.ARH_CSU_PKG dependencies on HZ_CUST_ACCT_SITES

Line 344: hz_cust_acct_sites a

340: --
341: select count(1)
342: into dummy
343: from hz_cust_site_uses su,
344: hz_cust_acct_sites a
345: where su.cust_acct_site_ID = a.cust_acct_site_ID
346: and a.cust_account_id = p_customer_id
347: and su.site_use_code = p_site_use_code
348: and su.status = 'A'

Line 432: hz_cust_acct_sites a

428: --
429: select count(1)
430: into dummy
431: from hz_cust_site_uses su,
432: hz_cust_acct_sites a
433: where su.cust_acct_site_ID = a.cust_acct_site_ID
434: and a.cust_account_id = p_customer_id
435: and su.site_use_code = p_site_use_code
436: and su.status = 'A'

Line 535: hz_cust_acct_sites addr

531:
532: select 1
533: into dummy
534: from hz_cust_site_uses su,
535: hz_cust_acct_sites addr
536: where su.cust_acct_site_ID = addr.cust_acct_site_ID
537: and su.site_use_code = p_site_use_code
538: and su.location = p_location
539: and addr.cust_account_ID = p_customer_id

Line 607: hz_cust_acct_sites addr

603:
604: select 1
605: into dummy
606: from hz_cust_site_uses su,
607: hz_cust_acct_sites addr
608: where su.cust_acct_site_ID = addr.cust_acct_site_ID
609: and su.site_use_code = p_site_use_code
610: and su.location = p_location
611: and addr.cust_account_ID = p_customer_id

Line 671: hz_cust_acct_sites addr,

667: begin
668: select count(1)
669: into dummy
670: from hz_cust_accounts cust,
671: hz_cust_acct_sites addr,
672: hz_cust_site_uses su
673: where su.cust_acct_site_ID = addr.cust_acct_site_ID
674: and addr.cust_account_ID = cust.cust_account_ID
675: and cust.cust_account_ID = p_customer_id