APPS.PER_APL_SHD SQL Statements

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

Line: 68

    select
        application_id,
	business_group_id,
	person_id,
	date_received,
	comments,
	current_employer,
	date_end,
	projected_hire_date,
	successful_flag,
	termination_reason,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	appl_attribute_category,
	appl_attribute1,
	appl_attribute2,
	appl_attribute3,
	appl_attribute4,
	appl_attribute5,
	appl_attribute6,
	appl_attribute7,
	appl_attribute8,
	appl_attribute9,
	appl_attribute10,
	appl_attribute11,
	appl_attribute12,
	appl_attribute13,
	appl_attribute14,
	appl_attribute15,
	appl_attribute16,
	appl_attribute17,
	appl_attribute18,
	appl_attribute19,
	appl_attribute20,
	object_version_number
    from	per_applications
    where	application_id = p_application_id;

Line: 174

    select 	application_id,
	business_group_id,
	person_id,
	date_received,
	comments,
	current_employer,
	date_end,
	projected_hire_date,
	successful_flag,
	termination_reason,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	appl_attribute_category,
	appl_attribute1,
	appl_attribute2,
	appl_attribute3,
	appl_attribute4,
	appl_attribute5,
	appl_attribute6,
	appl_attribute7,
	appl_attribute8,
	appl_attribute9,
	appl_attribute10,
	appl_attribute11,
	appl_attribute12,
	appl_attribute13,
	appl_attribute14,
	appl_attribute15,
	appl_attribute16,
	appl_attribute17,
	appl_attribute18,
	appl_attribute19,
	appl_attribute20,
	object_version_number
    from	per_applications
    where	application_id = p_application_id
    for	update nowait;

Line: 275

	p_program_update_date           in date,
	p_appl_attribute_category       in varchar2,
	p_appl_attribute1               in varchar2,
	p_appl_attribute2               in varchar2,
	p_appl_attribute3               in varchar2,
	p_appl_attribute4               in varchar2,
	p_appl_attribute5               in varchar2,
	p_appl_attribute6               in varchar2,
	p_appl_attribute7               in varchar2,
	p_appl_attribute8               in varchar2,
	p_appl_attribute9               in varchar2,
	p_appl_attribute10              in varchar2,
	p_appl_attribute11              in varchar2,
	p_appl_attribute12              in varchar2,
	p_appl_attribute13              in varchar2,
	p_appl_attribute14              in varchar2,
	p_appl_attribute15              in varchar2,
	p_appl_attribute16              in varchar2,
	p_appl_attribute17              in varchar2,
	p_appl_attribute18              in varchar2,
	p_appl_attribute19              in varchar2,
	p_appl_attribute20              in varchar2,
	p_object_version_number         in number
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 323

  l_rec.program_update_date              := p_program_update_date;