APPS.PER_APR_SHD SQL Statements

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

Line: 64

    select
	appraisal_id,
	business_group_id,
	object_version_number,
	appraisal_template_id,
	appraisee_person_id,
	appraiser_person_id,
	appraisal_date,
	appraisal_period_end_date,
	appraisal_period_start_date,
	type,
	next_appraisal_date,
	status,
	group_date,
	group_initiator_id,
	comments,
	overall_performance_level_id,
	open,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
	system_type,
	system_params,
	appraisee_access,
	main_appraiser_id,
	assignment_id,
	assignment_start_date,
	assignment_business_group_id,
	assignment_organization_id  ,
	assignment_job_id           ,
	assignment_position_id      ,
	assignment_grade_id ,
	appraisal_system_status,
	potential_readiness_level,
	potential_short_term_workopp,
	potential_long_term_workopp,
	potential_details,
	event_id,
        show_competency_ratings,
        show_objective_ratings,
        show_questionnaire_info,
        show_participant_details,
        show_participant_ratings,
        show_participant_names,
        show_overall_ratings,
        show_overall_comments,
        update_appraisal,
        provide_overall_feedback,
        appraisee_comments,
        plan_id,
        offline_status
    from	per_appraisals
    where	appraisal_id = p_appraisal_id;

Line: 202

  select
	appraisal_id,
	business_group_id,
	object_version_number,
	appraisal_template_id,
	appraisee_person_id,
	appraiser_person_id,
	appraisal_date,
	appraisal_period_end_date,
	appraisal_period_start_date,
	type,
	next_appraisal_date,
	status,
	group_date,
	group_initiator_id,
	comments,
	overall_performance_level_id,
	open,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
	system_type,
	system_params,
	appraisee_access,
	main_appraiser_id,
	assignment_id,
	assignment_start_date,
	assignment_business_group_id,
	assignment_organization_id  ,
	assignment_job_id           ,
	assignment_position_id      ,
	assignment_grade_id ,
	appraisal_system_status,
	potential_readiness_level ,
	potential_short_term_workopp ,
	potential_long_term_workopp ,
	potential_details ,
        event_id,
        show_competency_ratings,
        show_objective_ratings,
        show_questionnaire_info,
        show_participant_details,
        show_participant_ratings,
        show_participant_names,
        show_overall_ratings,
        show_overall_comments,
        update_appraisal,
        provide_overall_feedback,
        appraisee_comments,
        plan_id,
        offline_status
    from	per_appraisals
    where	appraisal_id = p_appraisal_id
    for	update nowait;

Line: 386

        p_update_appraisal             in varchar2,
        p_provide_overall_feedback     in varchar2,
        p_appraisee_comments           in varchar2,
        p_plan_id                      in number,
        p_offline_status               in varchar2
	)
	Return g_rec_type is

  l_rec	  g_rec_type;

Line: 473

  l_rec.update_appraisal                 := p_update_appraisal;