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.HRBV_PAY_PROPOSALS_V

Object Details

Object Name:	HRBV_PAY_PROPOSALS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Pay proposals (from PER_PAY_PROPOSALS table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHANGE_DATE	DATE			Change date.
COMMENTS	LONG	(0)		Comments.
LAST_CHANGE_DATE	DATE			Last change date.
NEXT_PERF_REVIEW_DATE	DATE			Next perf review date.
NEXT_SAL_REVIEW_DATE	DATE			Next salary review date.
PERFORMANCE_RATING	VARCHAR2	(30)		Performance rating.
PROPOSAL_REASON	VARCHAR2	(30)		(Lookup code based on lookup type PROPOSAL_REASON).
PROPOSAL_REASON_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type PROPOSAL_REASON).
PROPOSED_SALARY	VARCHAR2	(60)		Proposed salary.
REVIEW_DATE	DATE			Review date.
APPROVED_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
MULTIPLE_COMPONENTS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
FORCED_RANKING	NUMBER			Forced ranking.
PROPOSED_SALARY_N	NUMBER			Proposed salary n.
BG_SECURITY_FLAG_CODE	CHAR	(1)		Business group security flag code.
LEGISLATION_CODE	VARCHAR2	(4000)		Legislation code.
APPROVED	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
MULTIPLE_COMPONENTS	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
_DF:PYP	CHAR	(29)		Dfpyp
PERFORMANCE_REVIEW_ID	NUMBER	(15)		Foreign key to PER_PERFORMANCE_REVIEWS.
PAY_PROPOSAL_ID	NUMBER	(15)	Yes	Primary key for PER_PAY_PROPOSALS.
ASSIGNMENT_ID	NUMBER	(10)	Yes	Foreign key to PER_ALL_ASSIGNMENTS_F.
EVENT_ID	NUMBER	(15)		Foreign key to PER_EVENTS.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS.
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column

Query Text

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


SELECT CHANGE_DATE
,      COMMENTS
,      LAST_CHANGE_DATE
,      NEXT_PERF_REVIEW_DATE
,      NEXT_SAL_REVIEW_DATE
,      PERFORMANCE_RATING
,      PROPOSAL_REASON
,      PROPOSAL_REASON_M
,      PROPOSED_SALARY
,      REVIEW_DATE
,      APPROVED_M
,      MULTIPLE_COMPONENTS_M
,      FORCED_RANKING
,      PROPOSED_SALARY_N
,      BG_SECURITY_FLAG_CODE
,      LEGISLATION_CODE
,      APPROVED
,      MULTIPLE_COMPONENTS
,      _DF:PYP
,      PERFORMANCE_REVIEW_ID
,      PAY_PROPOSAL_ID
,      ASSIGNMENT_ID
,      EVENT_ID
,      BUSINESS_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.HRBV_PAY_PROPOSALS_V;

Dependencies

[top of page]

APPS.HRBV_PAY_PROPOSALS_V references the following:

APPS: HR_API - show dependent code; HR_BIS - show dependent code; PER_PAY_PROPOSALS

APPS.HRBV_PAY_PROPOSALS_V is referenced by following:

PUBLIC: HRBV_PAY_PROPOSALS_V