APPS.HZ_ACT_UTIL_PUB dependencies on HZ_PARTY_SITES

Line 105: l_location_id HZ_PARTY_SITES.location_id%type := NULL;

101:
102: function get_location_id (
103: p_act_site_id IN NUMBER) RETURN NUMBER IS
104:
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

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;