APPS.HZ_ACT_UTIL_PUB dependencies on HZ_CUST_ACCT_SITES

Line 13: from hz_cust_acct_sites asite,

9: l_count NUMBER := 0;
10:
11: cursor c_site_use_purposes (l_act_site_id IN NUMBER) is
12: select al.MEANING
13: from hz_cust_acct_sites asite,
14: hz_cust_site_uses asu,
15: ar_lookups al
16: where asite.cust_acct_site_id = l_act_site_id
17: and asu.status = 'A'

Line 63: from hz_cust_acct_sites asite,

59: l_count NUMBER := 0;
60:
61: cursor c_site_use_purposes (l_act_site_id IN NUMBER) is
62: select al.MEANING
63: from hz_cust_acct_sites asite,
64: hz_cust_site_uses asu,
65: ar_lookups al
66: where asite.cust_acct_site_id = l_act_site_id
67: and asu.cust_acct_site_id = asite.cust_acct_site_id

Line 109: from hz_party_sites ps, hz_cust_acct_sites asite

105: l_location_id HZ_PARTY_SITES.location_id%type := NULL;
106: begin
107:
108: select ps.location_id into l_location_id
109: from hz_party_sites ps, hz_cust_acct_sites asite
110: where ps.party_site_id = asite.party_site_id
111: and asite.cust_acct_site_id = p_act_site_id;
112:
113: RETURN l_location_id;