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.HRDPV_UPDATE_PERSON_EXTRA_INFO

Source

View Text - Preformatted


select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_PEI_ATTRIBUTE_CATEGORY,
       pval002 P_PEI_ATTRIBUTE1,
       pval003 P_PEI_ATTRIBUTE2,
       pval004 P_PEI_ATTRIBUTE3,
       pval005 P_PEI_ATTRIBUTE4,
       pval006 P_PEI_ATTRIBUTE5,
       pval007 P_PEI_ATTRIBUTE6,
       pval008 P_PEI_ATTRIBUTE7,
       pval009 P_PEI_ATTRIBUTE8,
       pval010 P_PEI_ATTRIBUTE9,
       pval011 P_PEI_ATTRIBUTE10,
       pval012 P_PEI_ATTRIBUTE11,
       pval013 P_PEI_ATTRIBUTE12,
       pval014 P_PEI_ATTRIBUTE13,
       pval015 P_PEI_ATTRIBUTE14,
       pval016 P_PEI_ATTRIBUTE15,
       pval017 P_PEI_ATTRIBUTE16,
       pval018 P_PEI_ATTRIBUTE17,
       pval019 P_PEI_ATTRIBUTE18,
       pval020 P_PEI_ATTRIBUTE19,
       pval021 P_PEI_ATTRIBUTE20,
       pval022 P_PEI_INFORMATION_CATEGORY,
       pval023 P_PEI_INFORMATION1,
       pval024 P_PEI_INFORMATION2,
       pval025 P_PEI_INFORMATION3,
       pval026 P_PEI_INFORMATION4,
       pval027 P_PEI_INFORMATION5,
       pval028 P_PEI_INFORMATION6,
       pval029 P_PEI_INFORMATION7,
       pval030 P_PEI_INFORMATION8,
       pval031 P_PEI_INFORMATION9,
       pval032 P_PEI_INFORMATION10,
       pval033 P_PEI_INFORMATION11,
       pval034 P_PEI_INFORMATION12,
       pval035 P_PEI_INFORMATION13,
       pval036 P_PEI_INFORMATION14,
       pval037 P_PEI_INFORMATION15,
       pval038 P_PEI_INFORMATION16,
       pval039 P_PEI_INFORMATION17,
       pval040 P_PEI_INFORMATION18,
       pval041 P_PEI_INFORMATION19,
       pval042 P_PEI_INFORMATION20,
       pval043 P_PEI_INFORMATION21,
       pval044 P_PEI_INFORMATION22,
       pval045 P_PEI_INFORMATION23,
       pval046 P_PEI_INFORMATION24,
       pval047 P_PEI_INFORMATION25,
       pval048 P_PEI_INFORMATION26,
       pval049 P_PEI_INFORMATION27,
       pval050 P_PEI_INFORMATION28,
       pval051 P_PEI_INFORMATION29,
       pval052 P_PEI_INFORMATION30,
       pval053 P_PERSON_EXTRA_INFO_USER_KEY
from hr_pump_batch_lines
where api_module_id = 1227
with check option

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_PEI_ATTRIBUTE_CATEGORY
, PVAL002 P_PEI_ATTRIBUTE1
, PVAL003 P_PEI_ATTRIBUTE2
, PVAL004 P_PEI_ATTRIBUTE3
, PVAL005 P_PEI_ATTRIBUTE4
, PVAL006 P_PEI_ATTRIBUTE5
, PVAL007 P_PEI_ATTRIBUTE6
, PVAL008 P_PEI_ATTRIBUTE7
, PVAL009 P_PEI_ATTRIBUTE8
, PVAL010 P_PEI_ATTRIBUTE9
, PVAL011 P_PEI_ATTRIBUTE10
, PVAL012 P_PEI_ATTRIBUTE11
, PVAL013 P_PEI_ATTRIBUTE12
, PVAL014 P_PEI_ATTRIBUTE13
, PVAL015 P_PEI_ATTRIBUTE14
, PVAL016 P_PEI_ATTRIBUTE15
, PVAL017 P_PEI_ATTRIBUTE16
, PVAL018 P_PEI_ATTRIBUTE17
, PVAL019 P_PEI_ATTRIBUTE18
, PVAL020 P_PEI_ATTRIBUTE19
, PVAL021 P_PEI_ATTRIBUTE20
, PVAL022 P_PEI_INFORMATION_CATEGORY
, PVAL023 P_PEI_INFORMATION1
, PVAL024 P_PEI_INFORMATION2
, PVAL025 P_PEI_INFORMATION3
, PVAL026 P_PEI_INFORMATION4
, PVAL027 P_PEI_INFORMATION5
, PVAL028 P_PEI_INFORMATION6
, PVAL029 P_PEI_INFORMATION7
, PVAL030 P_PEI_INFORMATION8
, PVAL031 P_PEI_INFORMATION9
, PVAL032 P_PEI_INFORMATION10
, PVAL033 P_PEI_INFORMATION11
, PVAL034 P_PEI_INFORMATION12
, PVAL035 P_PEI_INFORMATION13
, PVAL036 P_PEI_INFORMATION14
, PVAL037 P_PEI_INFORMATION15
, PVAL038 P_PEI_INFORMATION16
, PVAL039 P_PEI_INFORMATION17
, PVAL040 P_PEI_INFORMATION18
, PVAL041 P_PEI_INFORMATION19
, PVAL042 P_PEI_INFORMATION20
, PVAL043 P_PEI_INFORMATION21
, PVAL044 P_PEI_INFORMATION22
, PVAL045 P_PEI_INFORMATION23
, PVAL046 P_PEI_INFORMATION24
, PVAL047 P_PEI_INFORMATION25
, PVAL048 P_PEI_INFORMATION26
, PVAL049 P_PEI_INFORMATION27
, PVAL050 P_PEI_INFORMATION28
, PVAL051 P_PEI_INFORMATION29
, PVAL052 P_PEI_INFORMATION30
, PVAL053 P_PERSON_EXTRA_INFO_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1227 WITH CHECK OPTION