APPS.PER_CTR_SHD SQL Statements

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

Line: 83

    select
   contact_relationship_id,
   business_group_id,
   person_id,
   contact_person_id,
   contact_type,
   comments,
   primary_contact_flag,
   request_id,
   program_application_id,
   program_id,
   program_update_date,
        date_start,
        start_life_reason_id,
        date_end,
        end_life_reason_id,
        rltd_per_rsds_w_dsgntr_flag,
        personal_flag,
   sequence_number,
        cont_attribute_category,
   cont_attribute1,
   cont_attribute2,
   cont_attribute3,
   cont_attribute4,
   cont_attribute5,
   cont_attribute6,
   cont_attribute7,
   cont_attribute8,
   cont_attribute9,
   cont_attribute10,
   cont_attribute11,
   cont_attribute12,
   cont_attribute13,
   cont_attribute14,
   cont_attribute15,
   cont_attribute16,
   cont_attribute17,
   cont_attribute18,
   cont_attribute19,
   cont_attribute20,
        cont_information_category,
   cont_information1,
   cont_information2,
   cont_information3,
   cont_information4,
   cont_information5,
   cont_information6,
   cont_information7,
   cont_information8,
   cont_information9,
   cont_information10,
   cont_information11,
   cont_information12,
   cont_information13,
   cont_information14,
   cont_information15,
   cont_information16,
   cont_information17,
   cont_information18,
   cont_information19,
   cont_information20,
   third_party_pay_flag,
   bondholder_flag,
        dependent_flag,
        beneficiary_flag,
   object_version_number
--
    from per_contact_relationships
    where   contact_relationship_id = p_contact_relationship_id;

Line: 219

    select  contact_relationship_id,
   business_group_id,
   person_id,
   contact_person_id,
   contact_type,
   comments,
   primary_contact_flag,
   request_id,
   program_application_id,
   program_id,
   program_update_date,
        date_start,
        start_life_reason_id,
        date_end,
        end_life_reason_id,
        rltd_per_rsds_w_dsgntr_flag,
        personal_flag,
   sequence_number,
        cont_attribute_category,
   cont_attribute1,
   cont_attribute2,
   cont_attribute3,
   cont_attribute4,
   cont_attribute5,
   cont_attribute6,
   cont_attribute7,
   cont_attribute8,
   cont_attribute9,
   cont_attribute10,
   cont_attribute11,
   cont_attribute12,
   cont_attribute13,
   cont_attribute14,
   cont_attribute15,
   cont_attribute16,
   cont_attribute17,
   cont_attribute18,
   cont_attribute19,
   cont_attribute20,
        cont_information_category,
   cont_information1,
   cont_information2,
   cont_information3,
   cont_information4,
   cont_information5,
   cont_information6,
   cont_information7,
   cont_information8,
   cont_information9,
   cont_information10,
   cont_information11,
   cont_information12,
   cont_information13,
   cont_information14,
   cont_information15,
   cont_information16,
   cont_information17,
   cont_information18,
   cont_information19,
   cont_information20,
   third_party_pay_flag,
   bondholder_flag,
        dependent_flag,
        beneficiary_flag,
   object_version_number

    from per_contact_relationships
    where   contact_relationship_id = p_contact_relationship_id
    for  update nowait;

Line: 347

   p_program_update_date           in date,
        p_date_start                    in date,
        p_start_life_reason_id          in number,
        p_date_end                      in date,
        p_end_life_reason_id            in number,
        p_rltd_per_rsds_w_dsgntr_flag   in varchar2,
        p_personal_flag                 in varchar2,
   p_sequence_number               in number,
   p_cont_attribute_category       in varchar2,
   p_cont_attribute1               in varchar2,
   p_cont_attribute2               in varchar2,
   p_cont_attribute3               in varchar2,
   p_cont_attribute4               in varchar2,
   p_cont_attribute5               in varchar2,
   p_cont_attribute6               in varchar2,
   p_cont_attribute7               in varchar2,
   p_cont_attribute8               in varchar2,
   p_cont_attribute9               in varchar2,
   p_cont_attribute10              in varchar2,
   p_cont_attribute11              in varchar2,
   p_cont_attribute12              in varchar2,
   p_cont_attribute13              in varchar2,
   p_cont_attribute14              in varchar2,
   p_cont_attribute15              in varchar2,
   p_cont_attribute16              in varchar2,
   p_cont_attribute17              in varchar2,
   p_cont_attribute18              in varchar2,
   p_cont_attribute19              in varchar2,
   p_cont_attribute20              in varchar2,
   p_cont_information_category       in varchar2,
   p_cont_information1               in varchar2,
   p_cont_information2               in varchar2,
   p_cont_information3               in varchar2,
   p_cont_information4               in varchar2,
   p_cont_information5               in varchar2,
   p_cont_information6               in varchar2,
   p_cont_information7               in varchar2,
   p_cont_information8               in varchar2,
   p_cont_information9               in varchar2,
   p_cont_information10              in varchar2,
   p_cont_information11              in varchar2,
   p_cont_information12              in varchar2,
   p_cont_information13              in varchar2,
   p_cont_information14              in varchar2,
   p_cont_information15              in varchar2,
   p_cont_information16              in varchar2,
   p_cont_information17              in varchar2,
   p_cont_information18              in varchar2,
   p_cont_information19              in varchar2,
   p_cont_information20              in varchar2,
   p_third_party_pay_flag          in varchar2,
   p_bondholder_flag               in varchar2,
        p_dependent_flag                in varchar2,
        p_beneficiary_flag              in varchar2,
   p_object_version_number         in number
        )
   Return g_rec_type is
--
  l_rec    g_rec_type;

Line: 424

  l_rec.program_update_date              := p_program_update_date;