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

VIEW: APPS.PAY_IE_P35_INSURABLE_WEEKS_V

Object Details
Object Name: PAY_IE_P35_INSURABLE_WEEKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_IE_P35_INSURABLE_WEEKS_V
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 Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
PERSON_ID NUMBER (10) Yes Foreign key to PER_PEOPLE.
FULL_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by.
ORIGINAL_HIRE_DATE DATE

Original date of hire.
MINIMUM_EFFECTIVE_DATE DATE

Minimum Effective Date
COMBINED_CLASS VARCHAR2 (120)
Combined Class
INSURABLE_WEEKS NUMBER

Insurable Weeks
Query Text

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


SELECT BUSINESS_GROUP_ID
,      PERSON_ID
,      FULL_NAME
,      ORIGINAL_HIRE_DATE
,      MINIMUM_EFFECTIVE_DATE
,      COMBINED_CLASS
,      INSURABLE_WEEKS
FROM APPS.PAY_IE_P35_INSURABLE_WEEKS_V;

Dependencies

[top of page]

APPS.PAY_IE_P35_INSURABLE_WEEKS_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymFND_PROFILE_OPTIONS
SynonymFND_PROFILE_OPTION_VALUES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_INPUT_VALUES_F
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_RUN_RESULTS
SynonymPAY_RUN_RESULT_VALUES
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
ViewPER_ASSIGNMENTS_F
APPS.PAY_IE_P35_INSURABLE_WEEKS_V is referenced by following:

SchemaAPPS
Package BodyPAY_IE_P35 - show dependent code
SchemaPUBLIC
SynonymPAY_IE_P35_INSURABLE_WEEKS_V