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_RU_EMP_ASG

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_EFFECTIVE_DATE,
       pval002 P_DATETRACK_UPDATE_MODE,
       pval003 P_ASSIGNMENT_NUMBER,
       pval004 P_CHANGE_REASON,
       pval005 P_COMMENTS,
       pval006 P_DATE_PROBATION_END,
       pval007 P_FREQUENCY,
       pval008 P_INTERNAL_ADDRESS_LINE,
       pval009 P_MANAGER_FLAG,
       pval010 P_NORMAL_HOURS,
       pval011 P_PERF_REVIEW_PERIOD,
       pval012 P_PERF_REVIEW_PERIOD_FREQUENCY,
       pval013 P_PROBATION_PERIOD,
       pval014 P_PROBATION_UNIT,
       pval015 P_SAL_REVIEW_PERIOD,
       pval016 P_SAL_REVIEW_PERIOD_FREQUENCY,
       pval017 P_SOURCE_TYPE,
       pval018 P_TIME_NORMAL_FINISH,
       pval019 P_TIME_NORMAL_START,
       pval020 P_BARGAINING_UNIT_CODE,
       pval021 P_LABOUR_UNION_MEMBER_FLAG,
       pval022 P_HOURLY_SALARIED_CODE,
       pval023 P_ASS_ATTRIBUTE_CATEGORY,
       pval024 P_ASS_ATTRIBUTE1,
       pval025 P_ASS_ATTRIBUTE2,
       pval026 P_ASS_ATTRIBUTE3,
       pval027 P_ASS_ATTRIBUTE4,
       pval028 P_ASS_ATTRIBUTE5,
       pval029 P_ASS_ATTRIBUTE6,
       pval030 P_ASS_ATTRIBUTE7,
       pval031 P_ASS_ATTRIBUTE8,
       pval032 P_ASS_ATTRIBUTE9,
       pval033 P_ASS_ATTRIBUTE10,
       pval034 P_ASS_ATTRIBUTE11,
       pval035 P_ASS_ATTRIBUTE12,
       pval036 P_ASS_ATTRIBUTE13,
       pval037 P_ASS_ATTRIBUTE14,
       pval038 P_ASS_ATTRIBUTE15,
       pval039 P_ASS_ATTRIBUTE16,
       pval040 P_ASS_ATTRIBUTE17,
       pval041 P_ASS_ATTRIBUTE18,
       pval042 P_ASS_ATTRIBUTE19,
       pval043 P_ASS_ATTRIBUTE20,
       pval044 P_ASS_ATTRIBUTE21,
       pval045 P_ASS_ATTRIBUTE22,
       pval046 P_ASS_ATTRIBUTE23,
       pval047 P_ASS_ATTRIBUTE24,
       pval048 P_ASS_ATTRIBUTE25,
       pval049 P_ASS_ATTRIBUTE26,
       pval050 P_ASS_ATTRIBUTE27,
       pval051 P_ASS_ATTRIBUTE28,
       pval052 P_ASS_ATTRIBUTE29,
       pval053 P_ASS_ATTRIBUTE30,
       pval054 P_TITLE,
       pval055 P_SEC_EMP,
       pval056 P_CONTRACT_NUMBER,
       pval057 P_ISSUE_DATE,
       pval058 P_CONT_END_DATE,
       pval059 P_LIMIT_REASON,
       pval060 P_END_REASON,
       pval061 P_TERRITORY_COND,
       pval062 P_SPL_WORK_COND,
       pval063 P_CSR,
       pval064 P_CSR_ADD_INFO,
       pval065 P_LSR,
       pval066 P_LSR_ADD_INFO,
       pval067 P_UNINT_SERVICE_REC,
       pval068 P_TOTAL_SERVICE_REC,
       pval069 P_PENSION_YEARS,
       pval070 P_PENSION_MONTHS,
       pval071 P_PENSION_DAYS,
       pval072 P_CONCAT_SEGMENTS,
       pval073 P_CAG_SEGMENT1,
       pval074 P_CAG_SEGMENT2,
       pval075 P_CAG_SEGMENT3,
       pval076 P_CAG_SEGMENT4,
       pval077 P_CAG_SEGMENT5,
       pval078 P_CAG_SEGMENT6,
       pval079 P_CAG_SEGMENT7,
       pval080 P_CAG_SEGMENT8,
       pval081 P_CAG_SEGMENT9,
       pval082 P_CAG_SEGMENT10,
       pval083 P_CAG_SEGMENT11,
       pval084 P_CAG_SEGMENT12,
       pval085 P_CAG_SEGMENT13,
       pval086 P_CAG_SEGMENT14,
       pval087 P_CAG_SEGMENT15,
       pval088 P_CAG_SEGMENT16,
       pval089 P_CAG_SEGMENT17,
       pval090 P_CAG_SEGMENT18,
       pval091 P_CAG_SEGMENT19,
       pval092 P_CAG_SEGMENT20,
       pval093 P_NOTICE_PERIOD,
       pval094 P_NOTICE_PERIOD_UOM,
       pval095 P_EMPLOYEE_CATEGORY,
       pval096 P_WORK_AT_HOME,
       pval097 P_JOB_POST_SOURCE_NAME,
       pval098 P_CAGR_GRADE_DEF_ID,
       pval099 P_CAGR_CONCATENATED_SEGMENTS,
       pval100 P_EFFECTIVE_START_DATE,
       pval101 P_EFFECTIVE_END_DATE,
       pval102 P_COMMENT_ID,
       pval103 P_CONCATENATED_SEGMENTS,
       pval104 P_NO_MANAGERS_WARNING,
       pval105 P_OTHER_MANAGER_WARNING,
       pval106 P_HOURLY_SALARIED_WARNING,
       pval107 P_GSP_POST_PROCESS_WARNING,
       pval108 P_ASSIGNMENT_USER_KEY,
       pval109 P_SUPERVISOR_USER_KEY,
       pval110 P_USER_STATUS,
       pval111 P_LANGUAGE_CODE,
       pval112 P_DEFAULT_CODE_COMB_USER_KEY,
       pval113 P_SET_OF_BOOKS_NAME,
       pval114 P_EMPLOYER_NAME,
       pval115 P_CONTRACT_USER_KEY,
       pval116 P_ESTABLISHMENT_ORG_NAME,
       pval117 P_CAGR_NAME,
       pval118 P_CAGR_ID_FLEX_NUM_USER_KEY,
       pval119 P_SVR_ASSIGNMENT_USER_KEY,
       pval120 P_CON_SEG_USER_NAME
from hr_pump_batch_lines
where api_module_id = 3870
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_EFFECTIVE_DATE
, PVAL002 P_DATETRACK_UPDATE_MODE
, PVAL003 P_ASSIGNMENT_NUMBER
, PVAL004 P_CHANGE_REASON
, PVAL005 P_COMMENTS
, PVAL006 P_DATE_PROBATION_END
, PVAL007 P_FREQUENCY
, PVAL008 P_INTERNAL_ADDRESS_LINE
, PVAL009 P_MANAGER_FLAG
, PVAL010 P_NORMAL_HOURS
, PVAL011 P_PERF_REVIEW_PERIOD
, PVAL012 P_PERF_REVIEW_PERIOD_FREQUENCY
, PVAL013 P_PROBATION_PERIOD
, PVAL014 P_PROBATION_UNIT
, PVAL015 P_SAL_REVIEW_PERIOD
, PVAL016 P_SAL_REVIEW_PERIOD_FREQUENCY
, PVAL017 P_SOURCE_TYPE
, PVAL018 P_TIME_NORMAL_FINISH
, PVAL019 P_TIME_NORMAL_START
, PVAL020 P_BARGAINING_UNIT_CODE
, PVAL021 P_LABOUR_UNION_MEMBER_FLAG
, PVAL022 P_HOURLY_SALARIED_CODE
, PVAL023 P_ASS_ATTRIBUTE_CATEGORY
, PVAL024 P_ASS_ATTRIBUTE1
, PVAL025 P_ASS_ATTRIBUTE2
, PVAL026 P_ASS_ATTRIBUTE3
, PVAL027 P_ASS_ATTRIBUTE4
, PVAL028 P_ASS_ATTRIBUTE5
, PVAL029 P_ASS_ATTRIBUTE6
, PVAL030 P_ASS_ATTRIBUTE7
, PVAL031 P_ASS_ATTRIBUTE8
, PVAL032 P_ASS_ATTRIBUTE9
, PVAL033 P_ASS_ATTRIBUTE10
, PVAL034 P_ASS_ATTRIBUTE11
, PVAL035 P_ASS_ATTRIBUTE12
, PVAL036 P_ASS_ATTRIBUTE13
, PVAL037 P_ASS_ATTRIBUTE14
, PVAL038 P_ASS_ATTRIBUTE15
, PVAL039 P_ASS_ATTRIBUTE16
, PVAL040 P_ASS_ATTRIBUTE17
, PVAL041 P_ASS_ATTRIBUTE18
, PVAL042 P_ASS_ATTRIBUTE19
, PVAL043 P_ASS_ATTRIBUTE20
, PVAL044 P_ASS_ATTRIBUTE21
, PVAL045 P_ASS_ATTRIBUTE22
, PVAL046 P_ASS_ATTRIBUTE23
, PVAL047 P_ASS_ATTRIBUTE24
, PVAL048 P_ASS_ATTRIBUTE25
, PVAL049 P_ASS_ATTRIBUTE26
, PVAL050 P_ASS_ATTRIBUTE27
, PVAL051 P_ASS_ATTRIBUTE28
, PVAL052 P_ASS_ATTRIBUTE29
, PVAL053 P_ASS_ATTRIBUTE30
, PVAL054 P_TITLE
, PVAL055 P_SEC_EMP
, PVAL056 P_CONTRACT_NUMBER
, PVAL057 P_ISSUE_DATE
, PVAL058 P_CONT_END_DATE
, PVAL059 P_LIMIT_REASON
, PVAL060 P_END_REASON
, PVAL061 P_TERRITORY_COND
, PVAL062 P_SPL_WORK_COND
, PVAL063 P_CSR
, PVAL064 P_CSR_ADD_INFO
, PVAL065 P_LSR
, PVAL066 P_LSR_ADD_INFO
, PVAL067 P_UNINT_SERVICE_REC
, PVAL068 P_TOTAL_SERVICE_REC
, PVAL069 P_PENSION_YEARS
, PVAL070 P_PENSION_MONTHS
, PVAL071 P_PENSION_DAYS
, PVAL072 P_CONCAT_SEGMENTS
, PVAL073 P_CAG_SEGMENT1
, PVAL074 P_CAG_SEGMENT2
, PVAL075 P_CAG_SEGMENT3
, PVAL076 P_CAG_SEGMENT4
, PVAL077 P_CAG_SEGMENT5
, PVAL078 P_CAG_SEGMENT6
, PVAL079 P_CAG_SEGMENT7
, PVAL080 P_CAG_SEGMENT8
, PVAL081 P_CAG_SEGMENT9
, PVAL082 P_CAG_SEGMENT10
, PVAL083 P_CAG_SEGMENT11
, PVAL084 P_CAG_SEGMENT12
, PVAL085 P_CAG_SEGMENT13
, PVAL086 P_CAG_SEGMENT14
, PVAL087 P_CAG_SEGMENT15
, PVAL088 P_CAG_SEGMENT16
, PVAL089 P_CAG_SEGMENT17
, PVAL090 P_CAG_SEGMENT18
, PVAL091 P_CAG_SEGMENT19
, PVAL092 P_CAG_SEGMENT20
, PVAL093 P_NOTICE_PERIOD
, PVAL094 P_NOTICE_PERIOD_UOM
, PVAL095 P_EMPLOYEE_CATEGORY
, PVAL096 P_WORK_AT_HOME
, PVAL097 P_JOB_POST_SOURCE_NAME
, PVAL098 P_CAGR_GRADE_DEF_ID
, PVAL099 P_CAGR_CONCATENATED_SEGMENTS
, PVAL100 P_EFFECTIVE_START_DATE
, PVAL101 P_EFFECTIVE_END_DATE
, PVAL102 P_COMMENT_ID
, PVAL103 P_CONCATENATED_SEGMENTS
, PVAL104 P_NO_MANAGERS_WARNING
, PVAL105 P_OTHER_MANAGER_WARNING
, PVAL106 P_HOURLY_SALARIED_WARNING
, PVAL107 P_GSP_POST_PROCESS_WARNING
, PVAL108 P_ASSIGNMENT_USER_KEY
, PVAL109 P_SUPERVISOR_USER_KEY
, PVAL110 P_USER_STATUS
, PVAL111 P_LANGUAGE_CODE
, PVAL112 P_DEFAULT_CODE_COMB_USER_KEY
, PVAL113 P_SET_OF_BOOKS_NAME
, PVAL114 P_EMPLOYER_NAME
, PVAL115 P_CONTRACT_USER_KEY
, PVAL116 P_ESTABLISHMENT_ORG_NAME
, PVAL117 P_CAGR_NAME
, PVAL118 P_CAGR_ID_FLEX_NUM_USER_KEY
, PVAL119 P_SVR_ASSIGNMENT_USER_KEY
, PVAL120 P_CON_SEG_USER_NAME FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 3870 WITH CHECK OPTION