APPS.HZ_DSS_UTIL_PUB dependencies on HZ_PARTY_SITES

Line 2127: FROM hz_party_sites ps, hz_parties p

2123: CURSOR c_party_site (
2124: p_party_site_id NUMBER
2125: ) IS
2126: SELECT p.party_id, p.party_type
2127: FROM hz_party_sites ps, hz_parties p
2128: WHERE party_site_id = p_party_site_id
2129: AND ps.party_id = p.party_id;
2130:
2131: CURSOR c_location (

Line 2135: FROM hz_locations loc, hz_party_sites ps, hz_parties p

2131: CURSOR c_location (
2132: p_location_id NUMBER
2133: ) IS
2134: SELECT p.party_id, p.party_type
2135: FROM hz_locations loc, hz_party_sites ps, hz_parties p
2136: WHERE loc.location_id = p_location_id
2137: AND loc.location_id = ps.location_id
2138: AND ps.party_id = p.party_id;
2139:

Line 2174: FROM hz_contact_points cp, hz_party_sites ps, hz_parties p

2170: CURSOR c_contact_point_ps (
2171: p_contact_point_id NUMBER
2172: ) IS
2173: SELECT p.party_id, p.party_type
2174: FROM hz_contact_points cp, hz_party_sites ps, hz_parties p
2175: WHERE contact_point_id = p_contact_point_id
2176: AND owner_table_name = 'HZ_PARTY_SITES'
2177: AND owner_table_id = ps.party_site_id
2178: AND ps.party_id = p.party_id;

Line 2176: AND owner_table_name = 'HZ_PARTY_SITES'

2172: ) IS
2173: SELECT p.party_id, p.party_type
2174: FROM hz_contact_points cp, hz_party_sites ps, hz_parties p
2175: WHERE contact_point_id = p_contact_point_id
2176: AND owner_table_name = 'HZ_PARTY_SITES'
2177: AND owner_table_id = ps.party_site_id
2178: AND ps.party_id = p.party_id;
2179:
2180: i NUMBER;

Line 2195: ELSIF p_db_object_name = 'HZ_PARTY_SITES' THEN

2191: OPEN c_party(TO_NUMBER(p_object_pk1));
2192: FETCH c_party BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2193: CLOSE c_party;
2194:
2195: ELSIF p_db_object_name = 'HZ_PARTY_SITES' THEN
2196: OPEN c_party_site(TO_NUMBER(p_object_pk1));
2197: FETCH c_party_site BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2198: CLOSE c_party_site;
2199: