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_CREATE_AU_SECONDARY_EMP_

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_ASSIGNMENT_NUMBER,
       pval003 P_CHANGE_REASON,
       pval004 P_COMMENTS,
       pval005 P_DATE_PROBATION_END,
       pval006 P_EMPLOYMENT_CATEGORY,
       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_LEV_LOD_FLG,
       pval056 P_GROUP_CERT_ISSUE_DATE,
       pval057 P_HRS_WORKED_PER_WEEK,
       pval058 P_PGP_SEGMENT1,
       pval059 P_PGP_SEGMENT2,
       pval060 P_PGP_SEGMENT3,
       pval061 P_PGP_SEGMENT4,
       pval062 P_PGP_SEGMENT5,
       pval063 P_PGP_SEGMENT6,
       pval064 P_PGP_SEGMENT7,
       pval065 P_PGP_SEGMENT8,
       pval066 P_PGP_SEGMENT9,
       pval067 P_PGP_SEGMENT10,
       pval068 P_PGP_SEGMENT11,
       pval069 P_PGP_SEGMENT12,
       pval070 P_PGP_SEGMENT13,
       pval071 P_PGP_SEGMENT14,
       pval072 P_PGP_SEGMENT15,
       pval073 P_PGP_SEGMENT16,
       pval074 P_PGP_SEGMENT17,
       pval075 P_PGP_SEGMENT18,
       pval076 P_PGP_SEGMENT19,
       pval077 P_PGP_SEGMENT20,
       pval078 P_PGP_SEGMENT21,
       pval079 P_PGP_SEGMENT22,
       pval080 P_PGP_SEGMENT23,
       pval081 P_PGP_SEGMENT24,
       pval082 P_PGP_SEGMENT25,
       pval083 P_PGP_SEGMENT26,
       pval084 P_PGP_SEGMENT27,
       pval085 P_PGP_SEGMENT28,
       pval086 P_PGP_SEGMENT29,
       pval087 P_PGP_SEGMENT30,
       pval088 P_PGP_CONCAT_SEGMENTS,
       pval089 P_CAGR_ID_FLEX_NUM,
       pval090 P_CAG_SEGMENT1,
       pval091 P_CAG_SEGMENT2,
       pval092 P_CAG_SEGMENT3,
       pval093 P_CAG_SEGMENT4,
       pval094 P_CAG_SEGMENT5,
       pval095 P_CAG_SEGMENT6,
       pval096 P_CAG_SEGMENT7,
       pval097 P_CAG_SEGMENT8,
       pval098 P_CAG_SEGMENT9,
       pval099 P_CAG_SEGMENT10,
       pval100 P_CAG_SEGMENT11,
       pval101 P_CAG_SEGMENT12,
       pval102 P_CAG_SEGMENT13,
       pval103 P_CAG_SEGMENT14,
       pval104 P_CAG_SEGMENT15,
       pval105 P_CAG_SEGMENT16,
       pval106 P_CAG_SEGMENT17,
       pval107 P_CAG_SEGMENT18,
       pval108 P_CAG_SEGMENT19,
       pval109 P_CAG_SEGMENT20,
       pval110 P_CAGR_GRADE_DEF_ID,
       pval111 P_CAGR_CONCATENATED_SEGMENTS,
       pval112 P_ASSIGNMENT_USER_KEY,
       pval113 P_SOFT_CODING_KEYFLEX_ID,
       pval114 P_PEOPLE_GROUP_ID,
       pval115 P_OBJECT_VERSION_NUMBER,
       pval116 P_EFFECTIVE_START_DATE,
       pval117 P_EFFECTIVE_END_DATE,
       pval118 P_ASSIGNMENT_SEQUENCE,
       pval119 P_COMMENT_ID,
       pval120 P_CONCATENATED_SEGMENTS,
       pval121 P_GROUP_NAME,
       pval122 P_OTHER_MANAGER_WARNING,
       pval123 P_PERSON_USER_KEY,
       pval124 P_ORGANIZATION_NAME,
       pval125 P_LANGUAGE_CODE,
       pval126 P_GRADE_NAME,
       pval127 P_POSITION_NAME,
       pval128 P_JOB_NAME,
       pval129 P_USER_STATUS,
       pval130 P_PAYROLL_NAME,
       pval131 P_LOCATION_CODE,
       pval132 P_SUPERVISOR_USER_KEY,
       pval133 P_SPECIAL_CEILIN_STEP_USER_KEY,
       pval134 P_PAY_BASIS_NAME,
       pval135 P_DEFAULT_CODE_COMB_USER_KEY,
       pval136 P_SET_OF_BOOKS_NAME,
       pval137 P_LEGAL_EMPLOYER_NAME,
       pval138 P_CONTRACT_USER_KEY,
       pval139 P_ESTABLISHMENT_NAME,
       pval140 P_LOCATION,
       pval141 P_CAGR_NAME
from hr_pump_batch_lines
where api_module_id = 2161
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_ASSIGNMENT_NUMBER
, PVAL003 P_CHANGE_REASON
, PVAL004 P_COMMENTS
, PVAL005 P_DATE_PROBATION_END
, PVAL006 P_EMPLOYMENT_CATEGORY
, 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_LEV_LOD_FLG
, PVAL056 P_GROUP_CERT_ISSUE_DATE
, PVAL057 P_HRS_WORKED_PER_WEEK
, PVAL058 P_PGP_SEGMENT1
, PVAL059 P_PGP_SEGMENT2
, PVAL060 P_PGP_SEGMENT3
, PVAL061 P_PGP_SEGMENT4
, PVAL062 P_PGP_SEGMENT5
, PVAL063 P_PGP_SEGMENT6
, PVAL064 P_PGP_SEGMENT7
, PVAL065 P_PGP_SEGMENT8
, PVAL066 P_PGP_SEGMENT9
, PVAL067 P_PGP_SEGMENT10
, PVAL068 P_PGP_SEGMENT11
, PVAL069 P_PGP_SEGMENT12
, PVAL070 P_PGP_SEGMENT13
, PVAL071 P_PGP_SEGMENT14
, PVAL072 P_PGP_SEGMENT15
, PVAL073 P_PGP_SEGMENT16
, PVAL074 P_PGP_SEGMENT17
, PVAL075 P_PGP_SEGMENT18
, PVAL076 P_PGP_SEGMENT19
, PVAL077 P_PGP_SEGMENT20
, PVAL078 P_PGP_SEGMENT21
, PVAL079 P_PGP_SEGMENT22
, PVAL080 P_PGP_SEGMENT23
, PVAL081 P_PGP_SEGMENT24
, PVAL082 P_PGP_SEGMENT25
, PVAL083 P_PGP_SEGMENT26
, PVAL084 P_PGP_SEGMENT27
, PVAL085 P_PGP_SEGMENT28
, PVAL086 P_PGP_SEGMENT29
, PVAL087 P_PGP_SEGMENT30
, PVAL088 P_PGP_CONCAT_SEGMENTS
, PVAL089 P_CAGR_ID_FLEX_NUM
, PVAL090 P_CAG_SEGMENT1
, PVAL091 P_CAG_SEGMENT2
, PVAL092 P_CAG_SEGMENT3
, PVAL093 P_CAG_SEGMENT4
, PVAL094 P_CAG_SEGMENT5
, PVAL095 P_CAG_SEGMENT6
, PVAL096 P_CAG_SEGMENT7
, PVAL097 P_CAG_SEGMENT8
, PVAL098 P_CAG_SEGMENT9
, PVAL099 P_CAG_SEGMENT10
, PVAL100 P_CAG_SEGMENT11
, PVAL101 P_CAG_SEGMENT12
, PVAL102 P_CAG_SEGMENT13
, PVAL103 P_CAG_SEGMENT14
, PVAL104 P_CAG_SEGMENT15
, PVAL105 P_CAG_SEGMENT16
, PVAL106 P_CAG_SEGMENT17
, PVAL107 P_CAG_SEGMENT18
, PVAL108 P_CAG_SEGMENT19
, PVAL109 P_CAG_SEGMENT20
, PVAL110 P_CAGR_GRADE_DEF_ID
, PVAL111 P_CAGR_CONCATENATED_SEGMENTS
, PVAL112 P_ASSIGNMENT_USER_KEY
, PVAL113 P_SOFT_CODING_KEYFLEX_ID
, PVAL114 P_PEOPLE_GROUP_ID
, PVAL115 P_OBJECT_VERSION_NUMBER
, PVAL116 P_EFFECTIVE_START_DATE
, PVAL117 P_EFFECTIVE_END_DATE
, PVAL118 P_ASSIGNMENT_SEQUENCE
, PVAL119 P_COMMENT_ID
, PVAL120 P_CONCATENATED_SEGMENTS
, PVAL121 P_GROUP_NAME
, PVAL122 P_OTHER_MANAGER_WARNING
, PVAL123 P_PERSON_USER_KEY
, PVAL124 P_ORGANIZATION_NAME
, PVAL125 P_LANGUAGE_CODE
, PVAL126 P_GRADE_NAME
, PVAL127 P_POSITION_NAME
, PVAL128 P_JOB_NAME
, PVAL129 P_USER_STATUS
, PVAL130 P_PAYROLL_NAME
, PVAL131 P_LOCATION_CODE
, PVAL132 P_SUPERVISOR_USER_KEY
, PVAL133 P_SPECIAL_CEILIN_STEP_USER_KEY
, PVAL134 P_PAY_BASIS_NAME
, PVAL135 P_DEFAULT_CODE_COMB_USER_KEY
, PVAL136 P_SET_OF_BOOKS_NAME
, PVAL137 P_LEGAL_EMPLOYER_NAME
, PVAL138 P_CONTRACT_USER_KEY
, PVAL139 P_ESTABLISHMENT_NAME
, PVAL140 P_LOCATION
, PVAL141 P_CAGR_NAME FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 2161 WITH CHECK OPTION