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_UPLOAD_SALARY_PROPOSAL

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_CHANGE_DATE,
       pval002 P_PROPOSED_SALARY,
       pval003 P_PROPOSAL_REASON,
       pval004 P_NEXT_SAL_REVIEW_DATE,
       pval005 P_FORCED_RANKING,
       pval006 P_DATE_TO,
       pval007 P_PAY_PROPOSAL_ID,
       pval008 P_OBJECT_VERSION_NUMBER,
       pval009 P_COMPONENT_REASON_1,
       pval010 P_CHANGE_AMOUNT_1,
       pval011 P_CHANGE_PERCENTAGE_1,
       pval012 P_APPROVED_1,
       pval013 P_COMPONENT_ID_1,
       pval014 P_PPC_OBJECT_VERSION_NUMBER_1,
       pval015 P_COMPONENT_REASON_2,
       pval016 P_CHANGE_AMOUNT_2,
       pval017 P_CHANGE_PERCENTAGE_2,
       pval018 P_APPROVED_2,
       pval019 P_COMPONENT_ID_2,
       pval020 P_PPC_OBJECT_VERSION_NUMBER_2,
       pval021 P_COMPONENT_REASON_3,
       pval022 P_CHANGE_AMOUNT_3,
       pval023 P_CHANGE_PERCENTAGE_3,
       pval024 P_APPROVED_3,
       pval025 P_COMPONENT_ID_3,
       pval026 P_PPC_OBJECT_VERSION_NUMBER_3,
       pval027 P_COMPONENT_REASON_4,
       pval028 P_CHANGE_AMOUNT_4,
       pval029 P_CHANGE_PERCENTAGE_4,
       pval030 P_APPROVED_4,
       pval031 P_COMPONENT_ID_4,
       pval032 P_PPC_OBJECT_VERSION_NUMBER_4,
       pval033 P_COMPONENT_REASON_5,
       pval034 P_CHANGE_AMOUNT_5,
       pval035 P_CHANGE_PERCENTAGE_5,
       pval036 P_APPROVED_5,
       pval037 P_COMPONENT_ID_5,
       pval038 P_PPC_OBJECT_VERSION_NUMBER_5,
       pval039 P_COMPONENT_REASON_6,
       pval040 P_CHANGE_AMOUNT_6,
       pval041 P_CHANGE_PERCENTAGE_6,
       pval042 P_APPROVED_6,
       pval043 P_COMPONENT_ID_6,
       pval044 P_PPC_OBJECT_VERSION_NUMBER_6,
       pval045 P_COMPONENT_REASON_7,
       pval046 P_CHANGE_AMOUNT_7,
       pval047 P_CHANGE_PERCENTAGE_7,
       pval048 P_APPROVED_7,
       pval049 P_COMPONENT_ID_7,
       pval050 P_PPC_OBJECT_VERSION_NUMBER_7,
       pval051 P_COMPONENT_REASON_8,
       pval052 P_CHANGE_AMOUNT_8,
       pval053 P_CHANGE_PERCENTAGE_8,
       pval054 P_APPROVED_8,
       pval055 P_COMPONENT_ID_8,
       pval056 P_PPC_OBJECT_VERSION_NUMBER_8,
       pval057 P_COMPONENT_REASON_9,
       pval058 P_CHANGE_AMOUNT_9,
       pval059 P_CHANGE_PERCENTAGE_9,
       pval060 P_APPROVED_9,
       pval061 P_COMPONENT_ID_9,
       pval062 P_PPC_OBJECT_VERSION_NUMBER_9,
       pval063 P_COMPONENT_REASON_10,
       pval064 P_CHANGE_AMOUNT_10,
       pval065 P_CHANGE_PERCENTAGE_10,
       pval066 P_APPROVED_10,
       pval067 P_COMPONENT_ID_10,
       pval068 P_PPC_OBJECT_VERSION_NUMBER_10,
       pval069 P_PYP_PROPOSED_SAL_WARNING,
       pval070 P_ADDITIONAL_COMP_WARNING,
       pval071 P_ATTRIBUTE_CATEGORY,
       pval072 P_ATTRIBUTE1,
       pval073 P_ATTRIBUTE2,
       pval074 P_ATTRIBUTE3,
       pval075 P_ATTRIBUTE4,
       pval076 P_ATTRIBUTE5,
       pval077 P_ATTRIBUTE6,
       pval078 P_ATTRIBUTE7,
       pval079 P_ATTRIBUTE8,
       pval080 P_ATTRIBUTE9,
       pval081 P_ATTRIBUTE10,
       pval082 P_ATTRIBUTE11,
       pval083 P_ATTRIBUTE12,
       pval084 P_ATTRIBUTE13,
       pval085 P_ATTRIBUTE14,
       pval086 P_ATTRIBUTE15,
       pval087 P_ATTRIBUTE16,
       pval088 P_ATTRIBUTE17,
       pval089 P_ATTRIBUTE18,
       pval090 P_ATTRIBUTE19,
       pval091 P_ATTRIBUTE20,
       pval092 P_ASSIGNMENT_USER_KEY
from hr_pump_batch_lines
where api_module_id = 1324
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_CHANGE_DATE
, PVAL002 P_PROPOSED_SALARY
, PVAL003 P_PROPOSAL_REASON
, PVAL004 P_NEXT_SAL_REVIEW_DATE
, PVAL005 P_FORCED_RANKING
, PVAL006 P_DATE_TO
, PVAL007 P_PAY_PROPOSAL_ID
, PVAL008 P_OBJECT_VERSION_NUMBER
, PVAL009 P_COMPONENT_REASON_1
, PVAL010 P_CHANGE_AMOUNT_1
, PVAL011 P_CHANGE_PERCENTAGE_1
, PVAL012 P_APPROVED_1
, PVAL013 P_COMPONENT_ID_1
, PVAL014 P_PPC_OBJECT_VERSION_NUMBER_1
, PVAL015 P_COMPONENT_REASON_2
, PVAL016 P_CHANGE_AMOUNT_2
, PVAL017 P_CHANGE_PERCENTAGE_2
, PVAL018 P_APPROVED_2
, PVAL019 P_COMPONENT_ID_2
, PVAL020 P_PPC_OBJECT_VERSION_NUMBER_2
, PVAL021 P_COMPONENT_REASON_3
, PVAL022 P_CHANGE_AMOUNT_3
, PVAL023 P_CHANGE_PERCENTAGE_3
, PVAL024 P_APPROVED_3
, PVAL025 P_COMPONENT_ID_3
, PVAL026 P_PPC_OBJECT_VERSION_NUMBER_3
, PVAL027 P_COMPONENT_REASON_4
, PVAL028 P_CHANGE_AMOUNT_4
, PVAL029 P_CHANGE_PERCENTAGE_4
, PVAL030 P_APPROVED_4
, PVAL031 P_COMPONENT_ID_4
, PVAL032 P_PPC_OBJECT_VERSION_NUMBER_4
, PVAL033 P_COMPONENT_REASON_5
, PVAL034 P_CHANGE_AMOUNT_5
, PVAL035 P_CHANGE_PERCENTAGE_5
, PVAL036 P_APPROVED_5
, PVAL037 P_COMPONENT_ID_5
, PVAL038 P_PPC_OBJECT_VERSION_NUMBER_5
, PVAL039 P_COMPONENT_REASON_6
, PVAL040 P_CHANGE_AMOUNT_6
, PVAL041 P_CHANGE_PERCENTAGE_6
, PVAL042 P_APPROVED_6
, PVAL043 P_COMPONENT_ID_6
, PVAL044 P_PPC_OBJECT_VERSION_NUMBER_6
, PVAL045 P_COMPONENT_REASON_7
, PVAL046 P_CHANGE_AMOUNT_7
, PVAL047 P_CHANGE_PERCENTAGE_7
, PVAL048 P_APPROVED_7
, PVAL049 P_COMPONENT_ID_7
, PVAL050 P_PPC_OBJECT_VERSION_NUMBER_7
, PVAL051 P_COMPONENT_REASON_8
, PVAL052 P_CHANGE_AMOUNT_8
, PVAL053 P_CHANGE_PERCENTAGE_8
, PVAL054 P_APPROVED_8
, PVAL055 P_COMPONENT_ID_8
, PVAL056 P_PPC_OBJECT_VERSION_NUMBER_8
, PVAL057 P_COMPONENT_REASON_9
, PVAL058 P_CHANGE_AMOUNT_9
, PVAL059 P_CHANGE_PERCENTAGE_9
, PVAL060 P_APPROVED_9
, PVAL061 P_COMPONENT_ID_9
, PVAL062 P_PPC_OBJECT_VERSION_NUMBER_9
, PVAL063 P_COMPONENT_REASON_10
, PVAL064 P_CHANGE_AMOUNT_10
, PVAL065 P_CHANGE_PERCENTAGE_10
, PVAL066 P_APPROVED_10
, PVAL067 P_COMPONENT_ID_10
, PVAL068 P_PPC_OBJECT_VERSION_NUMBER_10
, PVAL069 P_PYP_PROPOSED_SAL_WARNING
, PVAL070 P_ADDITIONAL_COMP_WARNING
, PVAL071 P_ATTRIBUTE_CATEGORY
, PVAL072 P_ATTRIBUTE1
, PVAL073 P_ATTRIBUTE2
, PVAL074 P_ATTRIBUTE3
, PVAL075 P_ATTRIBUTE4
, PVAL076 P_ATTRIBUTE5
, PVAL077 P_ATTRIBUTE6
, PVAL078 P_ATTRIBUTE7
, PVAL079 P_ATTRIBUTE8
, PVAL080 P_ATTRIBUTE9
, PVAL081 P_ATTRIBUTE10
, PVAL082 P_ATTRIBUTE11
, PVAL083 P_ATTRIBUTE12
, PVAL084 P_ATTRIBUTE13
, PVAL085 P_ATTRIBUTE14
, PVAL086 P_ATTRIBUTE15
, PVAL087 P_ATTRIBUTE16
, PVAL088 P_ATTRIBUTE17
, PVAL089 P_ATTRIBUTE18
, PVAL090 P_ATTRIBUTE19
, PVAL091 P_ATTRIBUTE20
, PVAL092 P_ASSIGNMENT_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1324 WITH CHECK OPTION