APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_ACCOUNTS

Line 559: FROM hz_cust_accounts a,

555: l_cust_acct_site_id number;
556:
557: CURSOR c_site (l_cust_acct_id VARCHAR2) IS
558: SELECT su.site_use_id,su.cust_acct_site_id
559: FROM hz_cust_accounts a,
560: hz_cust_acct_sites_all cas,
561: hz_cust_site_uses_all su
562: WHERE a.cust_account_id = l_cust_acct_id
563: AND l_cust_acct_id = cas.cust_account_id

Line 588: FROM hz_cust_accounts a,

584: BEGIN
585: -- Modified for fix 3294182.
586: SELECT su.site_use_id,su.cust_acct_site_id
587: INTO l_site_use_id,l_cust_acct_site_id
588: FROM hz_cust_accounts a,
589: hz_cust_acct_sites_all cas, -- Bug 3456489
590: hz_cust_site_uses_all su -- Bug 3456489
591: WHERE a.cust_account_id = l_cust_acct_id
592: AND l_cust_acct_id = cas.cust_account_id

Line 1207: FROM hz_cust_accounts a,

1203: /*
1204: -- Bug 6315081 : FORWARD PORT BUG 6132727
1205: -- New Query Below
1206: SELECT count(*) into l_cnt
1207: FROM hz_cust_accounts a,
1208: hz_cust_acct_sites_all cas,
1209: hz_cust_site_uses_all su
1210: WHERE
1211: a.cust_account_id = l_cust_acct_id

Line 1751: FROM hz_cust_accounts a,

1747: /*
1748: -- Bug 6315081 : FORWARD PORT BUG 6132727
1749: -- New Query Below
1750: SELECT count(*) into l_cnt
1751: FROM hz_cust_accounts a,
1752: hz_cust_acct_sites_all cas,
1753: hz_cust_site_uses_all su
1754: WHERE
1755: a.cust_account_id = l_cust_acct_id

Line 1807: FROM hz_cust_accounts a,

1803:
1804: IF l_cnt > 0 THEN
1805: BEGIN
1806: SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
1807: FROM hz_cust_accounts a,
1808: hz_cust_acct_sites_all cas, -- Bug 3456489
1809: hz_cust_site_uses_all su -- Bug 3456489
1810: WHERE
1811: a.cust_account_id = l_cust_acct_id