APPS.HZ_DSS_UTIL_PUB dependencies on HZ_PARTY_SITES

Line 2267: FROM hz_party_sites ps, hz_parties p

2263: CURSOR c_party_site (
2264: p_party_site_id NUMBER
2265: ) IS
2266: SELECT p.party_id, p.party_type
2267: FROM hz_party_sites ps, hz_parties p
2268: WHERE party_site_id = p_party_site_id
2269: AND ps.party_id = p.party_id;
2270:
2271: CURSOR c_location (

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

2271: CURSOR c_location (
2272: p_location_id NUMBER
2273: ) IS
2274: SELECT p.party_id, p.party_type
2275: FROM hz_locations loc, hz_party_sites ps, hz_parties p
2276: WHERE loc.location_id = p_location_id
2277: AND loc.location_id = ps.location_id
2278: AND ps.party_id = p.party_id;
2279:

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

2310: CURSOR c_contact_point_ps (
2311: p_contact_point_id NUMBER
2312: ) IS
2313: SELECT p.party_id, p.party_type
2314: FROM hz_contact_points cp, hz_party_sites ps, hz_parties p
2315: WHERE contact_point_id = p_contact_point_id
2316: AND owner_table_name = 'HZ_PARTY_SITES'
2317: AND owner_table_id = ps.party_site_id
2318: AND ps.party_id = p.party_id;

Line 2316: AND owner_table_name = 'HZ_PARTY_SITES'

2312: ) IS
2313: SELECT p.party_id, p.party_type
2314: FROM hz_contact_points cp, hz_party_sites ps, hz_parties p
2315: WHERE contact_point_id = p_contact_point_id
2316: AND owner_table_name = 'HZ_PARTY_SITES'
2317: AND owner_table_id = ps.party_site_id
2318: AND ps.party_id = p.party_id;
2319:
2320: i NUMBER;

Line 2335: ELSIF p_db_object_name = 'HZ_PARTY_SITES' THEN

2331: OPEN c_party(TO_NUMBER(p_object_pk1));
2332: FETCH c_party BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2333: CLOSE c_party;
2334:
2335: ELSIF p_db_object_name = 'HZ_PARTY_SITES' THEN
2336: OPEN c_party_site(TO_NUMBER(p_object_pk1));
2337: FETCH c_party_site BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2338: CLOSE c_party_site;
2339: