APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1242: FROM hz_cust_site_uses uses, hz_cust_acct_sites_all cust_site

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

Line 1249: FROM hz_cust_acct_sites_all a,

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

Line 4477: from hz_cust_acct_sites_all s,

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