The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
decode(phone_country_code,null,null,phone_country_code||'-')||
decode(phone_area_code,null,'( )','('||phone_Area_code||')')||
phone_number||decode(phone_extension,null,null,' x'||phone_extension) phone_number
from
hz_contact_points
where owner_table_name = 'HZ_PARTIES' and
owner_table_id = p_party_id and
contact_point_type = 'PHONE' and
phone_line_type = p_telephone_type
order by 1;
select
count(*)
from
hz_contact_points
where owner_table_name = 'HZ_PARTIES' and
owner_table_id = p_party_id and
contact_point_type = 'PHONE' and
phone_line_type = p_telephone_type
order by 1;
select
decode(phone_country_code,null,null,phone_country_code||'-')||
decode(phone_area_code,null,'( )','('||phone_Area_code||')')||
phone_number||decode(phone_extension,null,null,' x'||phone_extension) phone_number
from
hz_contact_points
where owner_table_name = 'HZ_PARTIES' and
owner_table_id = p_party_id and
contact_point_type = 'PHONE' and
phone_line_type = p_telephone_type and
primary_flag = 'Y' order by 1;
select email_Address from hz_contact_points
where
owner_table_name = 'HZ_PARTIES' and
owner_table_id = p_party_id and contact_point_type = 'EMAIL'
order by 1;
select
decode(phone_country_code,null,null,phone_country_code||'-')||
decode(phone_area_code,null,'( )','('||phone_Area_code||')')||phone_number||
decode(phone_extension,null,null,' x'||phone_extension) phone_number
from
hz_contact_points
where owner_table_name = 'HZ_PARTIES' and
owner_table_id = p_party_id and
contact_point_type = 'PHONE'
and phone_line_type = 'FAX'
order by 1;