APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1240: FROM hz_cust_site_uses uses, hz_cust_acct_sites_all cust_site

1236: SELECT uses.cust_acct_site_id,
1237: uses.status,
1238: uses.primary_flag,
1239: cust_site.cust_account_id
1240: FROM hz_cust_site_uses uses, hz_cust_acct_sites_all cust_site
1241: WHERE site_use_id = in_site_Use_id
1242: AND site_use_code = in_site_use_code
1243: AND cust_site.cust_acct_site_id = uses.cust_acct_site_id;
1244:

Line 1247: FROM hz_cust_acct_sites_all a,

1243: AND cust_site.cust_acct_site_id = uses.cust_acct_site_id;
1244:
1245: CURSOR C_get_cust_from_site_use_id(l_site_use_Id NUMBER) IS
1246: SELECT a.cust_account_id
1247: FROM hz_cust_acct_sites_all a,
1248: hz_cust_site_uses b
1249: WHERE b.site_use_id=l_site_use_id
1250: and a.cust_acct_site_id=b.cust_acct_site_id
1251: and b.status = 'A';

Line 4475: from hz_cust_acct_sites_all s,

4471: END IF;
4472:
4473: select s.cust_account_id
4474: into p_cust_account_id
4475: from hz_cust_acct_sites_all s,
4476: hz_cust_site_uses u
4477: where s.cust_acct_site_id=u.cust_acct_site_id
4478: and u.site_use_id=p_site_use_id;
4479: