APPS.CS_PARTIES_PKG SQL Statements

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

Line: 10

	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;

Line: 24

	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;

Line: 36

	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;

Line: 100

	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;

Line: 122

	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;