APPS.HZ_DSS_UTIL_PUB dependencies on HZ_CONTACT_POINTS

Line 2165: FROM hz_contact_points, hz_parties p

2161: CURSOR c_contact_point (
2162: p_contact_point_id NUMBER
2163: ) IS
2164: SELECT p.party_id, p.party_type
2165: FROM hz_contact_points, hz_parties p
2166: WHERE contact_point_id = p_contact_point_id
2167: AND owner_table_name = 'HZ_PARTIES'
2168: AND owner_table_id = p.party_id;
2169:

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 2234: ELSIF p_db_object_name = 'HZ_CONTACT_POINTS' THEN

2230: x_party_id_tbl.DELETE(2);
2231: x_party_type_tbl.DELETE(2);
2232: END IF;
2233:
2234: ELSIF p_db_object_name = 'HZ_CONTACT_POINTS' THEN
2235: OPEN c_contact_point(TO_NUMBER(p_object_pk1));
2236: FETCH c_contact_point BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2237: CLOSE c_contact_point;
2238: