VIEW: APPS.HRDPV_UPDATE_GB_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_CAGR_ID_FLEX_NUM,
       pval056 P_NOTICE_PERIOD,
       pval057 P_NOTICE_PERIOD_UOM,
       pval058 P_EMPLOYEE_CATEGORY,
       pval059 P_WORK_AT_HOME,
       pval060 P_JOB_POST_SOURCE_NAME,
       pval061 P_CAGR_GRADE_DEF_ID,
       pval062 P_CAGR_CONCATENATED_SEGMENTS,
       pval063 P_CONCATENATED_SEGMENTS,
       pval064 P_SOFT_CODING_KEYFLEX_ID,
       pval065 P_COMMENT_ID,
       pval066 P_EFFECTIVE_START_DATE,
       pval067 P_EFFECTIVE_END_DATE,
       pval068 P_NO_MANAGERS_WARNING,
       pval069 P_OTHER_MANAGER_WARNING,
       pval070 P_HOURLY_SALARIED_WARNING,
       pval071 P_ASSIGNMENT_USER_KEY,
       pval072 P_SUPERVISOR_USER_KEY,
       pval073 P_DEFAULT_CODE_COMB_USER_KEY,
       pval074 P_SET_OF_BOOKS_NAME,
       pval075 P_CONTRACT_USER_KEY,
       pval076 P_ESTABLISHMENT_NAME,
       pval077 P_LOCATION,
       pval078 P_CAGR_NAME,
       pval079 P_SVR_ASSIGNMENT_USER_KEY
from hr_pump_batch_lines
where api_module_id = 1376
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_CAGR_ID_FLEX_NUM
, PVAL056 P_NOTICE_PERIOD
, PVAL057 P_NOTICE_PERIOD_UOM
, PVAL058 P_EMPLOYEE_CATEGORY
, PVAL059 P_WORK_AT_HOME
, PVAL060 P_JOB_POST_SOURCE_NAME
, PVAL061 P_CAGR_GRADE_DEF_ID
, PVAL062 P_CAGR_CONCATENATED_SEGMENTS
, PVAL063 P_CONCATENATED_SEGMENTS
, PVAL064 P_SOFT_CODING_KEYFLEX_ID
, PVAL065 P_COMMENT_ID
, PVAL066 P_EFFECTIVE_START_DATE
, PVAL067 P_EFFECTIVE_END_DATE
, PVAL068 P_NO_MANAGERS_WARNING
, PVAL069 P_OTHER_MANAGER_WARNING
, PVAL070 P_HOURLY_SALARIED_WARNING
, PVAL071 P_ASSIGNMENT_USER_KEY
, PVAL072 P_SUPERVISOR_USER_KEY
, PVAL073 P_DEFAULT_CODE_COMB_USER_KEY
, PVAL074 P_SET_OF_BOOKS_NAME
, PVAL075 P_CONTRACT_USER_KEY
, PVAL076 P_ESTABLISHMENT_NAME
, PVAL077 P_LOCATION
, PVAL078 P_CAGR_NAME
, PVAL079 P_SVR_ASSIGNMENT_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1376 WITH CHECK OPTION