APPS.IGS_FI_PRC_1098T_DATA SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

	  SELECT party_id ,location_id
	  FROM hz_party_sites WHERE PARTY_SITE_ID =c_n_PARTY_SITE_ID;

Line: 49

    SELECT party_name FROM
    hz_parties
    WHERE party_id = c_n_party_id;

Line: 54

	  SELECT country,address1,address2,address3,address4,city,
		 postal_code,state,province,county
	  FROM hz_locations
	  WHERE location_id = c_n_LOCATION_ID;

Line: 60

    SELECT hp_name.party_name, hp_email.email_address
	  FROM hz_parties hp_name, hz_relationships hr, hz_parties hp_email
	  WHERE hr.relationship_id = p_n_relationship_id
	  AND hr.directional_flag = 'B'
	  AND hp_name.party_id = hr.object_id
    AND hr.party_id = hp_email.party_id;

Line: 69

    SELECT phone_country_code, phone_area_code, phone_number,phone_extension
    FROM hz_contact_points
    WHERE contact_point_id = p_n_contact_point_id;