APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_ACCT_SITES

Line 1225: FROM hz_cust_acct_sites s,

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

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:

Line 4740: from hz_cust_acct_sites s,hz_cust_site_uses_all u

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

Line 4783: from hz_cust_acct_sites cs

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

Line 4834: from hz_cust_acct_sites

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

Line 5483: hz_cust_acct_sites s,

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