APPS.IGS_FI_PRC_1098T_DATA dependencies on HZ_RELATIONSHIPS

Line 14: p_n_relationship_id IN hz_relationships.relationship_id%type,

10: Change History
11: Who When What
12: *************************************************************************/
13: PROCEDURE contactdetails ( p_n_party_site_id IN hz_party_sites.party_site_id%type,
14: p_n_relationship_id IN hz_relationships.relationship_id%type,
15: p_n_contact_point_id IN hz_contact_points.contact_point_id%type,
16: p_v_phone_country_code OUT NOCOPY hz_contact_points.phone_country_code%type,
17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,
18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,

Line 61: FROM hz_parties hp_name, hz_relationships hr, hz_parties hp_email

57: WHERE location_id = c_n_LOCATION_ID;
58:
59: CURSOR c_name_mailid IS
60: SELECT hp_name.party_name, hp_email.email_address
61: FROM hz_parties hp_name, hz_relationships hr, hz_parties hp_email
62: WHERE hr.relationship_id = p_n_relationship_id
63: AND hr.directional_flag = 'B'
64: AND hp_name.party_id = hr.object_id
65: AND hr.party_id = hp_email.party_id;