APPS.ARH_CSU_PKG dependencies on HZ_CUST_SITE_USES_S

Line 225: from hz_cust_site_uses su

221: -- first we encounter.
222: --
223: cursor c_site_use is select su.site_use_id,
224: su.status
225: from hz_cust_site_uses su
226: where su.cust_acct_site_id = p_address_id
227: and su.site_use_code = p_site_use_code
228: order
229: by su.status;

Line 271: update hz_cust_site_uses su

267: --
268: begin
269: --
270: --
271: update hz_cust_site_uses su
272: set su.status = p_status
273: where su.site_use_id = p_site_use_id;
274: --
275: --

Line 343: from hz_cust_site_uses su,

339: --
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

Line 431: from hz_cust_site_uses su,

427: --
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

Line 534: from hz_cust_site_uses su,

530: BEGIN
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

Line 606: from hz_cust_site_uses su,

602: BEGIN
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

Line 672: hz_cust_site_uses su

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
676: and site_use_code = p_site_use_code

Line 826: select hz_cust_site_uses_s.nextval into x_site_use_id from dual;

822:
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825:
826: select hz_cust_site_uses_s.nextval into x_site_use_id from dual;
827: --
828: --
829: --
830: -- Location will be null if automatic site number = 'Y'