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


VIEW: APPS.HXTFV_INTERACT_POLICY

Object Details
Object Name: HXTFV_INTERACT_POLICY
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHXT.HXTFV_INTERACT_POLICY
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_NAME VARCHAR2 (240) Yes Business Group of person
PERSON_NAME VARCHAR2 (240)
Name of person
PERSON_COUNT NUMBER

Person count
EARNING_POLICY VARCHAR2 (80) Yes Earning Policy Name
PREMIUM_INTERACT_POLICY VARCHAR2 (80) Yes Premium interaction policy name
POLICY_DESCRIPTION VARCHAR2 (255)
Premium interaction policy description
DATE_FROM DATE
Yes Date Interaction Policy becomes effective
DATE_TO DATE

Date Interaction Policy ceases to be effective
POLICY_BASE_ELEMENT VARCHAR2 (80)
Name of the base policy element
RULES_BASE_ELEMENT VARCHAR2 (80)
Name of the base rule element
RULES_PREM_ELEMENT VARCHAR2 (80)
Name of the premium rule element
ASSIGNMENT_ID NUMBER (10) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
EARNING_POLICY_ID NUMBER (15) Yes
EARNED_POL_ID NUMBER (9) Yes
EARNED_PREM_ID NUMBER (9) Yes
GRADE_ID NUMBER (15)
INTERACT_POLICY_ID NUMBER (15) Yes
JOB_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
POSITION_ID NUMBER (15)
PRIOR_PREM_ID NUMBER (9) Yes
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      PERSON_COUNT
,      EARNING_POLICY
,      PREMIUM_INTERACT_POLICY
,      POLICY_DESCRIPTION
,      DATE_FROM
,      DATE_TO
,      POLICY_BASE_ELEMENT
,      RULES_BASE_ELEMENT
,      RULES_PREM_ELEMENT
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      EARNING_POLICY_ID
,      EARNED_POL_ID
,      EARNED_PREM_ID
,      GRADE_ID
,      INTERACT_POLICY_ID
,      JOB_ID
,      ORGANIZATION_ID
,      PERSON_ID
,      POSITION_ID
,      PRIOR_PREM_ID
FROM APPS.HXTFV_INTERACT_POLICY;

Dependencies

[top of page]

APPS.HXTFV_INTERACT_POLICY references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHXT_ADD_ASSIGN_INFO_F
SynonymHXT_EARNING_POLICIES
SynonymHXT_PREM_INTERACT_POLICIES
SynonymHXT_PREM_INTERACT_POL_RULES
SynonymHXT_PREM_INTERACT_RULES
SynonymPAY_ELEMENT_TYPES_F
SynonymPER_ALL_PEOPLE_F
ViewPER_ASSIGNMENTS_F

APPS.HXTFV_INTERACT_POLICY is not referenced by any database object