[Home] [Help] [Dependency Information]

VIEW: APPS.HRDPV_CREATE_AU_SECONDARY_EMP_

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT BATCH_ID
,      BATCH_LINE_ID
,      API_MODULE_ID
,      LINE_STATUS
,      USER_SEQUENCE
,      LINK_VALUE
,      BUSINESS_GROUP_NAME
,      P_EFFECTIVE_DATE
,      P_ASSIGNMENT_NUMBER
,      P_CHANGE_REASON
,      P_COMMENTS
,      P_DATE_PROBATION_END
,      P_EMPLOYMENT_CATEGORY
,      P_FREQUENCY
,      P_INTERNAL_ADDRESS_LINE
,      P_MANAGER_FLAG
,      P_NORMAL_HOURS
,      P_PERF_REVIEW_PERIOD
,      P_PERF_REVIEW_PERIOD_FREQUENCY
,      P_PROBATION_PERIOD
,      P_PROBATION_UNIT
,      P_SAL_REVIEW_PERIOD
,      P_SAL_REVIEW_PERIOD_FREQUENCY
,      P_SOURCE_TYPE
,      P_TIME_NORMAL_FINISH
,      P_TIME_NORMAL_START
,      P_BARGAINING_UNIT_CODE
,      P_LABOUR_UNION_MEMBER_FLAG
,      P_HOURLY_SALARIED_CODE
,      P_ASS_ATTRIBUTE_CATEGORY
,      P_ASS_ATTRIBUTE1
,      P_ASS_ATTRIBUTE2
,      P_ASS_ATTRIBUTE3
,      P_ASS_ATTRIBUTE4
,      P_ASS_ATTRIBUTE5
,      P_ASS_ATTRIBUTE6
,      P_ASS_ATTRIBUTE7
,      P_ASS_ATTRIBUTE8
,      P_ASS_ATTRIBUTE9
,      P_ASS_ATTRIBUTE10
,      P_ASS_ATTRIBUTE11
,      P_ASS_ATTRIBUTE12
,      P_ASS_ATTRIBUTE13
,      P_ASS_ATTRIBUTE14
,      P_ASS_ATTRIBUTE15
,      P_ASS_ATTRIBUTE16
,      P_ASS_ATTRIBUTE17
,      P_ASS_ATTRIBUTE18
,      P_ASS_ATTRIBUTE19
,      P_ASS_ATTRIBUTE20
,      P_ASS_ATTRIBUTE21
,      P_ASS_ATTRIBUTE22
,      P_ASS_ATTRIBUTE23
,      P_ASS_ATTRIBUTE24
,      P_ASS_ATTRIBUTE25
,      P_ASS_ATTRIBUTE26
,      P_ASS_ATTRIBUTE27
,      P_ASS_ATTRIBUTE28
,      P_ASS_ATTRIBUTE29
,      P_ASS_ATTRIBUTE30
,      P_TITLE
,      P_LEV_LOD_FLG
,      P_GROUP_CERT_ISSUE_DATE
,      P_HRS_WORKED_PER_WEEK
,      P_PGP_SEGMENT1
,      P_PGP_SEGMENT2
,      P_PGP_SEGMENT3
,      P_PGP_SEGMENT4
,      P_PGP_SEGMENT5
,      P_PGP_SEGMENT6
,      P_PGP_SEGMENT7
,      P_PGP_SEGMENT8
,      P_PGP_SEGMENT9
,      P_PGP_SEGMENT10
,      P_PGP_SEGMENT11
,      P_PGP_SEGMENT12
,      P_PGP_SEGMENT13
,      P_PGP_SEGMENT14
,      P_PGP_SEGMENT15
,      P_PGP_SEGMENT16
,      P_PGP_SEGMENT17
,      P_PGP_SEGMENT18
,      P_PGP_SEGMENT19
,      P_PGP_SEGMENT20
,      P_PGP_SEGMENT21
,      P_PGP_SEGMENT22
,      P_PGP_SEGMENT23
,      P_PGP_SEGMENT24
,      P_PGP_SEGMENT25
,      P_PGP_SEGMENT26
,      P_PGP_SEGMENT27
,      P_PGP_SEGMENT28
,      P_PGP_SEGMENT29
,      P_PGP_SEGMENT30
,      P_PGP_CONCAT_SEGMENTS
,      P_CAGR_ID_FLEX_NUM
,      P_CAG_SEGMENT1
,      P_CAG_SEGMENT2
,      P_CAG_SEGMENT3
,      P_CAG_SEGMENT4
,      P_CAG_SEGMENT5
,      P_CAG_SEGMENT6
,      P_CAG_SEGMENT7
,      P_CAG_SEGMENT8
,      P_CAG_SEGMENT9
,      P_CAG_SEGMENT10
,      P_CAG_SEGMENT11
,      P_CAG_SEGMENT12
,      P_CAG_SEGMENT13
,      P_CAG_SEGMENT14
,      P_CAG_SEGMENT15
,      P_CAG_SEGMENT16
,      P_CAG_SEGMENT17
,      P_CAG_SEGMENT18
,      P_CAG_SEGMENT19
,      P_CAG_SEGMENT20
,      P_CAGR_GRADE_DEF_ID
,      P_CAGR_CONCATENATED_SEGMENTS
,      P_ASSIGNMENT_USER_KEY
,      P_SOFT_CODING_KEYFLEX_ID
,      P_PEOPLE_GROUP_ID
,      P_OBJECT_VERSION_NUMBER
,      P_EFFECTIVE_START_DATE
,      P_EFFECTIVE_END_DATE
,      P_ASSIGNMENT_SEQUENCE
,      P_COMMENT_ID
,      P_CONCATENATED_SEGMENTS
,      P_GROUP_NAME
,      P_OTHER_MANAGER_WARNING
,      P_PERSON_USER_KEY
,      P_ORGANIZATION_NAME
,      P_LANGUAGE_CODE
,      P_GRADE_NAME
,      P_POSITION_NAME
,      P_JOB_NAME
,      P_USER_STATUS
,      P_PAYROLL_NAME
,      P_LOCATION_CODE
,      P_SUPERVISOR_USER_KEY
,      P_SPECIAL_CEILIN_STEP_USER_KEY
,      P_PAY_BASIS_NAME
,      P_DEFAULT_CODE_COMB_USER_KEY
,      P_SET_OF_BOOKS_NAME
,      P_LEGAL_EMPLOYER_NAME
,      P_CONTRACT_USER_KEY
,      P_ESTABLISHMENT_NAME
,      P_LOCATION
,      P_CAGR_NAME
FROM APPS.HRDPV_CREATE_AU_SECONDARY_EMP_;

Dependencies

[top of page]

APPS

HR_PUMP_BATCH_LINES

APPS.HRDPV_CREATE_AU_SECONDARY_EMP_ is not referenced by any database object