APPS.PER_PEA_SHD SQL Statements

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

Line: 75

    select
        person_analysis_id,
        business_group_id,
        analysis_criteria_id,
        person_id,
        comments,
        date_from,
        date_to,
        id_flex_num,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        attribute16,
        attribute17,
        attribute18,
        attribute19,
        attribute20,
        object_version_number
    from        per_person_analyses
    where       person_analysis_id = p_person_analysis_id;

Line: 179

    select
        person_analysis_id,
        business_group_id,
        analysis_criteria_id,
        person_id,
        comments,
        date_from,
        date_to,
        id_flex_num,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        attribute16,
        attribute17,
        attribute18,
        attribute19,
        attribute20,
        object_version_number
    from        per_person_analyses
    where       person_analysis_id = p_person_analysis_id
    for	update nowait;

Line: 294

        p_program_update_date           in date,
        p_attribute_category            in varchar2,
        p_attribute1                    in varchar2,
        p_attribute2                    in varchar2,
        p_attribute3                    in varchar2,
        p_attribute4                    in varchar2,
        p_attribute5                    in varchar2,
        p_attribute6                    in varchar2,
        p_attribute7                    in varchar2,
        p_attribute8                    in varchar2,
        p_attribute9                    in varchar2,
        p_attribute10                   in varchar2,
        p_attribute11                   in varchar2,
        p_attribute12                   in varchar2,
        p_attribute13                   in varchar2,
        p_attribute14                   in varchar2,
        p_attribute15                   in varchar2,
        p_attribute16                   in varchar2,
        p_attribute17                   in varchar2,
        p_attribute18                   in varchar2,
        p_attribute19                   in varchar2,
        p_attribute20                   in varchar2,
        p_object_version_number         in number
        )
        Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 340

  l_rec.program_update_date              := p_program_update_date;