APPS.SSP_MAT_SHD SQL Statements

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

Line: 93

    select
    maternity_id,
    due_date,
    person_id,
    start_date_maternity_allowance,
    notification_of_birth_date,
    unfit_for_scheduled_return,
    stated_return_date,
    intend_to_return_flag,
    start_date_with_new_employer,
    smp_must_be_paid_by_date,
    pay_smp_as_lump_sum,
    live_birth_flag,
    actual_birth_date,
    mpp_start_date,
    object_version_number,
    attribute_category,
    attribute1,
    attribute2,
    attribute3,
    attribute4,
    attribute5,
    attribute6,
    attribute7,
    attribute8,
    attribute9,
    attribute10,
    attribute11,
    attribute12,
    attribute13,
    attribute14,
    attribute15,
    attribute16,
    attribute17,
    attribute18,
    attribute19,
    attribute20,
    LEAVE_TYPE,
    MATCHING_DATE,
    PLACEMENT_DATE,
    DISRUPTED_PLACEMENT_DATE,
    mat_information_category,
    mat_information1,
    mat_information2,
    mat_information3,
    mat_information4,
    mat_information5,
    mat_information6,
    mat_information7,
    mat_information8,
    mat_information9,
    mat_information10,
    mat_information11,
    mat_information12,
    mat_information13,
    mat_information14,
    mat_information15,
    mat_information16,
    mat_information17,
    mat_information18,
    mat_information19,
    mat_information20,
    mat_information21,
    mat_information22,
    mat_information23,
    mat_information24,
    mat_information25,
    mat_information26,
    mat_information27,
    mat_information28,
    mat_information29,
    mat_information30
    from	ssp_maternities
    where	maternity_id = p_maternity_id;

Line: 234

    select maternity_id,
           due_date,
           person_id,
           start_date_maternity_allowance,
           notification_of_birth_date,
           unfit_for_scheduled_return,
           stated_return_date,
           intend_to_return_flag,
           start_date_with_new_employer,
           smp_must_be_paid_by_date,
           pay_smp_as_lump_sum,
           live_birth_flag,
           actual_birth_date,
           mpp_start_date,
           object_version_number,
           attribute_category,
           attribute1,
           attribute2,
           attribute3,
           attribute4,
           attribute5,
           attribute6,
           attribute7,
           attribute8,
           attribute9,
           attribute10,
           attribute11,
           attribute12,
           attribute13,
           attribute14,
           attribute15,
           attribute16,
           attribute17,
           attribute18,
           attribute19,
           attribute20,
           LEAVE_TYPE,
           MATCHING_DATE,
           PLACEMENT_DATE,
           DISRUPTED_PLACEMENT_DATE,
           mat_information_category,
           mat_information1,
           mat_information2,
           mat_information3,
           mat_information4,
           mat_information5,
           mat_information6,
           mat_information7,
           mat_information8,
           mat_information9,
           mat_information10,
           mat_information11,
           mat_information12,
           mat_information13,
           mat_information14,
           mat_information15,
           mat_information16,
           mat_information17,
           mat_information18,
           mat_information19,
           mat_information20,
           mat_information21,
           mat_information22,
           mat_information23,
           mat_information24,
           mat_information25,
           mat_information26,
           mat_information27,
           mat_information28,
           mat_information29,
           mat_information30
    from	ssp_maternities
    where	maternity_id = p_maternity_id
    for	update nowait;