APPS.PER_ADD_SHD SQL Statements

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

Line: 71

    select
	address_id,
	business_group_id,
	person_id,
	date_from,
	primary_flag,
        derived_locale,
	style,
	address_line1,
	address_line2,
	address_line3,
	address_type,
	comments,
	country,
	date_to,
	postal_code,
	region_1,
	region_2,
	region_3,
	telephone_number_1,
	telephone_number_2,
	telephone_number_3,
	town_or_city,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
        addr_attribute_category,
	addr_attribute1,
	addr_attribute2,
	addr_attribute3,
	addr_attribute4,
	addr_attribute5,
	addr_attribute6,
	addr_attribute7,
	addr_attribute8,
	addr_attribute9,
	addr_attribute10,
	addr_attribute11,
	addr_attribute12,
	addr_attribute13,
	addr_attribute14,
	addr_attribute15,
	addr_attribute16,
	addr_attribute17,
	addr_attribute18,
	addr_attribute19,
	addr_attribute20,
	add_information13,
	add_information14,
	add_information15,
	add_information16,
	add_information17,
	add_information18,
	add_information19,
	add_information20,
	object_version_number,
	party_id,            -- HR/TCA merge
	geometry
    from	per_addresses
    where	address_id = p_address_id;

Line: 199

    select 	address_id,
	business_group_id,
	person_id,
	date_from,
	primary_flag,
        derived_locale,
	style,
	address_line1,
	address_line2,
	address_line3,
	address_type,
	comments,
	country,
	date_to,
	postal_code,
	region_1,
	region_2,
	region_3,
	telephone_number_1,
	telephone_number_2,
	telephone_number_3,
	town_or_city,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	addr_attribute_category,
	addr_attribute1,
	addr_attribute2,
	addr_attribute3,
	addr_attribute4,
	addr_attribute5,
	addr_attribute6,
	addr_attribute7,
	addr_attribute8,
	addr_attribute9,
	addr_attribute10,
	addr_attribute11,
	addr_attribute12,
	addr_attribute13,
	addr_attribute14,
	addr_attribute15,
	addr_attribute16,
	addr_attribute17,
	addr_attribute18,
	addr_attribute19,
	addr_attribute20,
	add_information13,
	add_information14,
	add_information15,
	add_information16,
	add_information17,
	add_information18,
	add_information19,
	add_information20,
	object_version_number,
	party_id,             -- HR/TCA merge
	geometry
    from	per_addresses
    where	address_id = p_address_id
    for	update nowait;

Line: 336

	p_program_update_date           in date,
	p_addr_attribute_category       in varchar2,
	p_addr_attribute1               in varchar2,
	p_addr_attribute2               in varchar2,
	p_addr_attribute3               in varchar2,
	p_addr_attribute4               in varchar2,
	p_addr_attribute5               in varchar2,
	p_addr_attribute6               in varchar2,
	p_addr_attribute7               in varchar2,
	p_addr_attribute8               in varchar2,
	p_addr_attribute9               in varchar2,
	p_addr_attribute10              in varchar2,
	p_addr_attribute11              in varchar2,
	p_addr_attribute12              in varchar2,
	p_addr_attribute13              in varchar2,
	p_addr_attribute14              in varchar2,
	p_addr_attribute15              in varchar2,
	p_addr_attribute16              in varchar2,
	p_addr_attribute17              in varchar2,
	p_addr_attribute18              in varchar2,
	p_addr_attribute19              in varchar2,
	p_addr_attribute20              in varchar2,
	p_add_information13             in varchar2,
	p_add_information14             in varchar2,
	p_add_information15             in varchar2,
	p_add_information16             in varchar2,
	p_add_information17             in varchar2,
	p_add_information18             in varchar2,
	p_add_information19             in varchar2,
	p_add_information20             in varchar2,
	p_object_version_number         in number,
	p_party_id                      in number default null -- HR/TCA merge
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 404

  l_rec.program_update_date              := p_program_update_date;