eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_EMP_DETAILS_ACTION_INFO_V

Source

View Text - Preformatted


SELECT action_context_id action_context_id, action_context_type action_context_type, tax_unit_id tax_unit_id, action_information_category action_information_category, action_information1 action_information1, action_information2 action_information2, action_information3 action_information3, action_information4 action_information4, action_information5 action_information5, action_information6 action_information6, action_information7 action_information7, action_information8 action_information8, action_information9 action_information9, action_information10 action_information10, action_information11 action_information11, action_information12 action_information12, action_information13 action_information13, action_information14 action_information14, action_information15 action_information15, action_information16 action_information16, action_information17 action_information17, action_information18 action_information18, action_information19 action_information19, action_information20 action_information20, action_information21 action_information21, action_information22 action_information22, action_information23 action_information23, action_information24 action_information24, action_information25 action_information25, action_information26 action_information26, action_information27 action_information27, action_information28 action_information28, action_information29 action_information29, action_information30 action_information30 from pay_action_information WHERE action_information_category like '__ EMPLOYEE DETAILS'

View Text - HTML Formatted

SELECT ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE ACTION_CONTEXT_TYPE
, TAX_UNIT_ID TAX_UNIT_ID
, ACTION_INFORMATION_CATEGORY ACTION_INFORMATION_CATEGORY
, ACTION_INFORMATION1 ACTION_INFORMATION1
, ACTION_INFORMATION2 ACTION_INFORMATION2
, ACTION_INFORMATION3 ACTION_INFORMATION3
, ACTION_INFORMATION4 ACTION_INFORMATION4
, ACTION_INFORMATION5 ACTION_INFORMATION5
, ACTION_INFORMATION6 ACTION_INFORMATION6
, ACTION_INFORMATION7 ACTION_INFORMATION7
, ACTION_INFORMATION8 ACTION_INFORMATION8
, ACTION_INFORMATION9 ACTION_INFORMATION9
, ACTION_INFORMATION10 ACTION_INFORMATION10
, ACTION_INFORMATION11 ACTION_INFORMATION11
, ACTION_INFORMATION12 ACTION_INFORMATION12
, ACTION_INFORMATION13 ACTION_INFORMATION13
, ACTION_INFORMATION14 ACTION_INFORMATION14
, ACTION_INFORMATION15 ACTION_INFORMATION15
, ACTION_INFORMATION16 ACTION_INFORMATION16
, ACTION_INFORMATION17 ACTION_INFORMATION17
, ACTION_INFORMATION18 ACTION_INFORMATION18
, ACTION_INFORMATION19 ACTION_INFORMATION19
, ACTION_INFORMATION20 ACTION_INFORMATION20
, ACTION_INFORMATION21 ACTION_INFORMATION21
, ACTION_INFORMATION22 ACTION_INFORMATION22
, ACTION_INFORMATION23 ACTION_INFORMATION23
, ACTION_INFORMATION24 ACTION_INFORMATION24
, ACTION_INFORMATION25 ACTION_INFORMATION25
, ACTION_INFORMATION26 ACTION_INFORMATION26
, ACTION_INFORMATION27 ACTION_INFORMATION27
, ACTION_INFORMATION28 ACTION_INFORMATION28
, ACTION_INFORMATION29 ACTION_INFORMATION29
, ACTION_INFORMATION30 ACTION_INFORMATION30
FROM PAY_ACTION_INFORMATION
WHERE ACTION_INFORMATION_CATEGORY LIKE '__ EMPLOYEE DETAILS'