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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PAY_GB_PEOPLE_SOE_V

Object Details

Object Name:	PAY_GB_PEOPLE_SOE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_GB_PEOPLE_SOE_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row Id
PERSON_ID	NUMBER	(10)	Person ID
SALARY	VARCHAR2	(60)	Salary
PAY_BASIS	VARCHAR2	(30)	Time basis for recording actual salary values, for example, annual, monthly, hourly.
JOB_TITLE	VARCHAR2	(700)	Job Title
FULL_NAME	VARCHAR2	(240)	Concatenation of last name, title, first name, middle names and the name the person is known by.
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Mapped to PAY_ASSIGNMENT_ACTIONS
ASSIGNMENT_ID	NUMBER	(10)	System generated primary key column from PER_ALL_ASSIGNMENTS_F
ASSIGNMENT_NUMBER	VARCHAR2	(30)	Employee assignment number
LOCATION_ID	NUMBER	(15)	Mapped to HR_LOCATIONS
INTERNAL_ADDRESS_LINE	VARCHAR2	(80)	Internal Address Line
NI_NUMBER	VARCHAR2	(30)	Number by which a person is identified in a given legislation
EXPENSE_CHECK_SEND_TO_ADDRESS	VARCHAR2	(30)	Mailing address

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      SALARY
,      PAY_BASIS
,      JOB_TITLE
,      FULL_NAME
,      ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      LOCATION_ID
,      INTERNAL_ADDRESS_LINE
,      NI_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
FROM APPS.PAY_GB_PEOPLE_SOE_V;

Dependencies

[top of page]

APPS.PAY_GB_PEOPLE_SOE_V references the following:

APPS: HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PAY_ACTION_INTERLOCKS; PAY_ASSIGNMENT_ACTIONS; PAY_ELEMENT_ENTRIES_F; PAY_ELEMENT_ENTRY_VALUES_F; PAY_PAYROLL_ACTIONS; PER_ALL_ASSIGNMENTS_F; PER_JOBS_TL; PER_PAY_BASES; PER_PEOPLE_F

APPS.PAY_GB_PEOPLE_SOE_V is not referenced by any database object