APPS.HZ_DSS_UTIL_PUB dependencies on HZ_CONTACT_POINTS

Line 2305: FROM hz_contact_points, hz_parties p

2301: CURSOR c_contact_point (
2302: p_contact_point_id NUMBER
2303: ) IS
2304: SELECT p.party_id, p.party_type
2305: FROM hz_contact_points, hz_parties p
2306: WHERE contact_point_id = p_contact_point_id
2307: AND owner_table_name = 'HZ_PARTIES'
2308: AND owner_table_id = p.party_id;
2309:

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

2370: x_party_id_tbl.DELETE(2);
2371: x_party_type_tbl.DELETE(2);
2372: END IF;
2373:
2374: ELSIF p_db_object_name = 'HZ_CONTACT_POINTS' THEN
2375: OPEN c_contact_point(TO_NUMBER(p_object_pk1));
2376: FETCH c_contact_point BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2377: CLOSE c_contact_point;
2378: