[Home] [Help] [Dependency Information]

VIEW: APPS.PER_POSITIONS

Object Details

Object Name:	PER_POSITIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_POSITIONS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PER_POSITIONS is a view based on the table PER_ALL_POSITIONS. It lists
all off the positions visible within the current security profile.

[View Source]

Columns

Query Text

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

SELECT POSITION_ID
,      BUSINESS_GROUP_ID
,      JOB_ID
,      ORGANIZATION_ID
,      SUCCESSOR_POSITION_ID
,      RELIEF_POSITION_ID
,      LOCATION_ID
,      POSITION_DEFINITION_ID
,      DATE_EFFECTIVE
,      COMMENTS
,      DATE_END
,      FREQUENCY
,      NAME
,      PROBATION_PERIOD
,      PROBATION_PERIOD_UNITS
,      REPLACEMENT_REQUIRED_FLAG
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      WORKING_HOURS
,      STATUS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM APPS.PER_POSITIONS;

Dependencies

[top of page]

APPS

HR_ALL_POSITIONS_F_TL

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

PER_ALL_POSITIONS

APPS

AME_APPROVER_TYPE_PKG - show dependent code

BEN_ASSIGNMENT_D

BEN_ELIG_PSTN_PRTE_D

BEN_EPS_BUS - show dependent code

BEN_EXT_PERSON - show dependent code

BEN_EXT_PERSON - show dependent code

BEN_PD_RATE_AND_CVG_MODULE - show dependent code

BEN_PLAN_DESIGN_ELPRO_MODULE - show dependent code

BEN_PLAN_DESIGN_PROGRAM_MODULE - show dependent code

BEN_PLAN_DESIGN_TXNS_API - show dependent code

BEN_PSTN_RT_D

BEN_PST_BUS - show dependent code

GHR_DS_JAN99_PKG - show dependent code

GHR_FETCH_POSITION_HISTORY - show dependent code

GHR_FETCH_POSITION_HISTORY - show dependent code

GHR_GHRCPDFO_XMLP_PKG - show dependent code

GHR_NON_SF52_EXTRA_INFO - show dependent code

GHR_NON_SF52_EXTRA_INFO - show dependent code

GHR_PAY_CALC - show dependent code

GHR_PAY_CALC - show dependent code

GHR_PAY_CAPS - show dependent code

GHR_PA_REQUESTS_PKG - show dependent code

GHR_PA_REQUESTS_PKG - show dependent code

GHR_PC_BASIC_PAY - show dependent code

GHR_PD_COVERSHEET_DATA - show dependent code

GHR_POSITIONS_V

GHR_POSITION_API - show dependent code

GHR_POSITION_COPY - show dependent code

GHR_POSITION_EXTRA_INFO_API - show dependent code

GHR_POSN_COPY - show dependent code

GHR_REI_BUS - show dependent code

GHR_SF52_POS_UPDATE - show dependent code

GHR_SF52_PRE_UPDATE - show dependent code

GHR_SF52_UPDATE - show dependent code

GHR_SF52_VALIDN_PKG - show dependent code

GHR_VALIDATE_CHECK - show dependent code

GHR_VALIDATE_PERWSDPO - show dependent code

HRBV_POSITION

HRFASTANSWERS - show dependent code

HRFV_POSITION_HISTORY

HRI_CL_POSITION_HX_V

HRI_CL_POSITION_N_V

HR_BPL_ALERT_TRNSLT - show dependent code

HR_DELETE - show dependent code

HR_JP_ID_PKG - show dependent code

HR_JP_ID_PKG - show dependent code

HR_PERF_MGMT_PLAN_INTERNAL - show dependent code

HR_POSITION_API - show dependent code

HXC_RESOURCE_INFORMATION_V

HXC_RESOURCE_RULES_PERSON_V

HXC_RESOURCE_RULES_V

ICX_PO_EMPLOYEE_DETAILS_V

IGIDOSL - show dependent code

OTA_LEARNER_ACCESS_UTIL - show dependent code

OTA_TEA_BUS - show dependent code

OTV_EVENT_ASSOCIATIONS

PAYBV_PAYROLL_ACT_RR_ENET_DET

PAY_DB_PAY_SETUP - show dependent code

PAY_EMP_ACTION_ARCH - show dependent code

PAY_FR_ARC_PKG - show dependent code

PAY_FR_DB_PAY_SETUP - show dependent code

PAY_IN_24QC_ARCHIVE - show dependent code

PAY_IN_24Q_ARCHIVE - show dependent code

PAY_IN_PAYSLIP_ARCHIVE - show dependent code

PAY_IN_TERM_RPRT_GEN_PKG - show dependent code

PAY_IN_UTILS - show dependent code

PAY_NZ_ASG_PAYMENT_RUNS_V

PAY_PAYFV_ELEMENT_ENTRIES_PKG - show dependent code

PAY_PEL_BUS - show dependent code

PAY_PYNZSOE_XMLP_PKG - show dependent code

PAY_SG_ASG_PAYMENT_RUNS_V

PAY_SG_PAYSGNSL_BAL_BY_DATE_V

PAY_US_DB_PER_SETUP - show dependent code

PAY_US_EMPLOYEE_PAYSLIP_WEB - show dependent code

PA_DEFAULT_PROFILES_V

PA_ROLE_PROFILES_UTILS - show dependent code

PER_ASSIGNMENTS_V10

PER_BUDGET_ELEMENTS_PKG - show dependent code

PER_DB_PER_ADDITIONAL - show dependent code

PER_JP_EMPDET_REPORT_PKG - show dependent code

PER_JP_WRKREG_REPORT_PKG - show dependent code

PER_PERRPREQ_XMLP_PKG - show dependent code

PER_POD_SHD - show dependent code

PER_POSITIONS_PKG - show dependent code

PER_POSITIONS_V

PER_POSITION_STRUCTURES_ALL_V

PER_POS_BUS - show dependent code

PER_POS_BUS - show dependent code

PER_POS_SHD - show dependent code

PE_POI_BUS - show dependent code

PO_POSITIONS_VAL_V

PQH_ASG_WRAPPER - show dependent code

PQH_ASG_WRAPPER - show dependent code

PQH_BDGT_ACTUAL_CMMTMNT_PKG - show dependent code

PQH_BDGT_ACTUAL_CMMTMNT_PKG - show dependent code

PQH_MGMT_RPT_PKG - show dependent code

PQH_MGMT_RPT_PKG - show dependent code

PQH_PQHWSPBD_XMLP_PKG - show dependent code

PQP_HROSS_INTEGRATION - show dependent code

PQP_PERASGADD_RIW - show dependent code

WF_POS_ROLES