APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_ACCOUNTS

Line 559: FROM hz_cust_accounts a,

555: BEGIN
556: -- Modified for fix 3294182.
557: SELECT su.site_use_id,su.cust_acct_site_id
558: INTO l_site_use_id,l_cust_acct_site_id
559: FROM hz_cust_accounts a,
560: hz_cust_acct_sites_all cas, -- Bug 3456489
561: hz_cust_site_uses_all su -- Bug 3456489
562: WHERE a.cust_account_id = l_cust_acct_id
563: AND l_cust_acct_id = cas.cust_account_id

Line 1115: FROM hz_cust_accounts a,

1111: /*
1112: -- Bug 6315081 : FORWARD PORT BUG 6132727
1113: -- New Query Below
1114: SELECT count(*) into l_cnt
1115: FROM hz_cust_accounts a,
1116: hz_cust_acct_sites_all cas,
1117: hz_cust_site_uses_all su
1118: WHERE
1119: a.cust_account_id = l_cust_acct_id

Line 1620: FROM hz_cust_accounts a,

1616: /*
1617: -- Bug 6315081 : FORWARD PORT BUG 6132727
1618: -- New Query Below
1619: SELECT count(*) into l_cnt
1620: FROM hz_cust_accounts a,
1621: hz_cust_acct_sites_all cas,
1622: hz_cust_site_uses_all su
1623: WHERE
1624: a.cust_account_id = l_cust_acct_id

Line 1676: FROM hz_cust_accounts a,

1672:
1673: IF l_cnt > 0 THEN
1674: BEGIN
1675: SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
1676: FROM hz_cust_accounts a,
1677: hz_cust_acct_sites_all cas, -- Bug 3456489
1678: hz_cust_site_uses_all su -- Bug 3456489
1679: WHERE
1680: a.cust_account_id = l_cust_acct_id