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


VIEW: APPS.HRIFV_SAL_PRO

Object Details
Object Name: HRIFV_SAL_PRO
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHRI.HRIFV_SAL_PRO
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
PERSON_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
ASSIGNMENT_NUMBER VARCHAR2 (30)
SALARY_AMOUNT NUMBER

ANNUALIZATION_FACTOR NUMBER

ANNUAL_SALARY NUMBER

CURRENCY VARCHAR2 (15)
EFFECTIVE_FROM_DATE DATE

EFFECTIVE_TO_DATE DATE

LAST_CHANGE_DATE DATE

SALARY_CHANGE_REASON VARCHAR2 (4000)
APPROVED VARCHAR2 (4000)
GRADE_ANNUALIZATION_FACTOR NUMBER

WORKING_HOURS_AMOUNT NUMBER (22)
WORKING_HOURS_FREQUENCY VARCHAR2 (30)
PAYROLL VARCHAR2 (80) Yes
NUMBER_PER_FISCAL_YEAR NUMBER (15) Yes
PAY_BASIS VARCHAR2 (4000)
RANKING NUMBER

MULTIPLE_COMPONENTS VARCHAR2 (4000)
SALARY_BASIS VARCHAR2 (30) Yes
_DF:PAY_PROPOSALS CHAR (29)
EFFECTIVE_TO_DATE_NN DATE

CURRENCY_CODE VARCHAR2 (15)
APPROVED_CODE VARCHAR2 (30)
PAY_BASIS_CODE VARCHAR2 (30) Yes
MULTIPLE_COMPONENTS_CODE VARCHAR2 (30)
ASSIGNMENT_ID NUMBER (10) Yes
PERSON_ID NUMBER (10) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
ORGANIZATION_ID NUMBER (15) Yes
LOCATION_ID NUMBER (15)
JOB_ID NUMBER (15)
GRADE_ID NUMBER (15)
POSITION_ID NUMBER (15)
PAYROLL_ID NUMBER (9) Yes
PAY_PROPOSAL_ID NUMBER (15) Yes
PERFORMANCE_REVIEW_ID NUMBER (15)
EVENT_ID NUMBER (15)
PAY_BASIS_ID NUMBER (9) Yes
INPUT_VALUE_ID NUMBER (9) Yes
RATE_ID NUMBER (15)
ELEMENT_TYPE_ID NUMBER (9) Yes
ASG_LAST_UPDATE_DATE DATE

PEO_LAST_UPDATE_DATE DATE

PRO_LAST_UPDATE_DATE DATE

PRO_NEXT_LAST_UPDATE_DATE DATE

PIV_LAST_UPDATE_DATE DATE

PET_LAST_UPDATE_DATE DATE

PAY_LAST_UPDATE_DATE DATE

TPT_LAST_UPDATE_DATE DATE

ASG_LAST_UPDATED_BY NUMBER (15)
PRO_LAST_UPDATED_BY NUMBER (15)
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      EMPLOYEE_NUMBER
,      ASSIGNMENT_NUMBER
,      SALARY_AMOUNT
,      ANNUALIZATION_FACTOR
,      ANNUAL_SALARY
,      CURRENCY
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      LAST_CHANGE_DATE
,      SALARY_CHANGE_REASON
,      APPROVED
,      GRADE_ANNUALIZATION_FACTOR
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      PAYROLL
,      NUMBER_PER_FISCAL_YEAR
,      PAY_BASIS
,      RANKING
,      MULTIPLE_COMPONENTS
,      SALARY_BASIS
,      _DF:PAY_PROPOSALS
,      EFFECTIVE_TO_DATE_NN
,      CURRENCY_CODE
,      APPROVED_CODE
,      PAY_BASIS_CODE
,      MULTIPLE_COMPONENTS_CODE
,      ASSIGNMENT_ID
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      JOB_ID
,      GRADE_ID
,      POSITION_ID
,      PAYROLL_ID
,      PAY_PROPOSAL_ID
,      PERFORMANCE_REVIEW_ID
,      EVENT_ID
,      PAY_BASIS_ID
,      INPUT_VALUE_ID
,      RATE_ID
,      ELEMENT_TYPE_ID
,      ASG_LAST_UPDATE_DATE
,      PEO_LAST_UPDATE_DATE
,      PRO_LAST_UPDATE_DATE
,      PRO_NEXT_LAST_UPDATE_DATE
,      PIV_LAST_UPDATE_DATE
,      PET_LAST_UPDATE_DATE
,      PAY_LAST_UPDATE_DATE
,      TPT_LAST_UPDATE_DATE
,      ASG_LAST_UPDATED_BY
,      PRO_LAST_UPDATED_BY
FROM APPS.HRIFV_SAL_PRO;

Dependencies

[top of page]

APPS.HRIFV_SAL_PRO references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_INPUT_VALUES_F
ViewPAY_PAYROLLS_F
SynonymPER_ALL_PEOPLE_F
ViewPER_ASSIGNMENTS_F
SynonymPER_PAY_BASES
SynonymPER_PAY_PROPOSALS
SynonymPER_PERIODS_OF_SERVICE
SynonymPER_TIME_PERIOD_TYPES
APPS.HRIFV_SAL_PRO is referenced by following:

SchemaAPPS
Package BodyHRI_OLTP_DISC_SALARY - show dependent code