DBA Data[Home] [Help]

APPS.PAY_AUD_SHD SQL Statements

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

Line: 45

    select
       stat_trans_audit_id
      ,transaction_type
      ,transaction_subtype
      ,transaction_date
      ,transaction_effective_date
      ,business_group_id
      ,person_id
      ,assignment_id
      ,source1
      ,source1_type
      ,source2
      ,source2_type
      ,source3
      ,source3_type
      ,source4
      ,source4_type
      ,source5
      ,source5_type
      ,transaction_parent_id
      ,audit_information_category
      ,audit_information1
      ,audit_information2
      ,audit_information3
      ,audit_information4
      ,audit_information5
      ,audit_information6
      ,audit_information7
      ,audit_information8
      ,audit_information9
      ,audit_information10
      ,audit_information11
      ,audit_information12
      ,audit_information13
      ,audit_information14
      ,audit_information15
      ,audit_information16
      ,audit_information17
      ,audit_information18
      ,audit_information19
      ,audit_information20
      ,audit_information21
      ,audit_information22
      ,audit_information23
      ,audit_information24
      ,audit_information25
      ,audit_information26
      ,audit_information27
      ,audit_information28
      ,audit_information29
      ,audit_information30
      ,title
      ,object_version_number
    from	pay_stat_trans_audit
    where	stat_trans_audit_id = p_stat_trans_audit_id
    for	update nowait;