APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_ACCT_SITES

Line 1227: FROM hz_cust_acct_sites s,

1223: CURSOR c_acct_site(in_cust_account_id in number
1224: ,in_party_site_id in number
1225: ,in_site_use_code in varchar2) IS
1226: SELECT s.cust_acct_site_id,u.site_use_id,u.primary_flag
1227: FROM hz_cust_acct_sites s,
1228: hz_cust_site_uses_all u
1229: WHERE s.cust_account_id = in_cust_account_id
1230: AND s.party_site_id = in_party_site_id
1231: AND s.status(+) = 'A'

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:

Line 4742: from hz_cust_acct_sites s,hz_cust_site_uses_all u

4738: END IF;
4739: begin
4740: select u.site_use_id
4741: into p_site_use_id
4742: from hz_cust_acct_sites s,hz_cust_site_uses_all u
4743: where s.party_site_id=p_party_site_id
4744: and s.cust_acct_site_id= u.cust_acct_site_id;
4745:
4746: EXCEPTION

Line 4785: from hz_cust_acct_sites cs

4781: END IF;
4782: begin
4783: select distinct cust_account_id
4784: into p_cust_account_id
4785: from hz_cust_acct_sites cs
4786: where party_site_id=p_party_site_id;
4787:
4788: EXCEPTION
4789:

Line 4836: from hz_cust_acct_sites

4832: END IF;
4833: begin
4834: select distinct cust_account_id
4835: into p_cust_account_id
4836: from hz_cust_acct_sites
4837: where cust_acct_site_id=p_site_id;
4838:
4839: EXCEPTION
4840:

Line 5485: hz_cust_acct_sites s,

5481: begin
5482: select a.party_id
5483: into p_party_id
5484: from hz_cust_accounts a,
5485: hz_cust_acct_sites s,
5486: hz_cust_site_uses_all u
5487: where u.site_use_id=p_account_site_use_id
5488: and u.cust_acct_site_id=s.cust_acct_site_id
5489: and s.cust_account_id=a.cust_account_id;