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


VIEW: APPS.PAY_NET_CALCULATION_RULES_V

Object Details
Object Name: PAY_NET_CALCULATION_RULES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_NET_CALCULATION_RULES_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 Mandatory Comments
ROW_ID ROWID (10)

NET_CALCULATION_RULE_ID NUMBER (9) Yes
ACCRUAL_PLAN_ID NUMBER (9) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
INPUT_VALUE_ID NUMBER (9) Yes
DATE_INPUT_VALUE_ID NUMBER (9)
INPUT_VALUE_NAME VARCHAR2 (80) Yes
DATE_INPUT_VALUE_NAME VARCHAR2 (80)
ELEMENT_TYPE_ID NUMBER (9) Yes
ELEMENT_TYPE_NAME VARCHAR2 (80) Yes
ADD_OR_SUBTRACT VARCHAR2 (30) Yes
ADD_OR_SUBTRACT_NAME VARCHAR2 (80) Yes
ABSENCE_ATTENDANCE_TYPE_ID NUMBER (15)
USE_ELEMENT_LINK VARCHAR2 (30)
RULE_TYPE VARCHAR2 (1)
Query Text

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


SELECT ROW_ID
,      NET_CALCULATION_RULE_ID
,      ACCRUAL_PLAN_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      INPUT_VALUE_ID
,      DATE_INPUT_VALUE_ID
,      INPUT_VALUE_NAME
,      DATE_INPUT_VALUE_NAME
,      ELEMENT_TYPE_ID
,      ELEMENT_TYPE_NAME
,      ADD_OR_SUBTRACT
,      ADD_OR_SUBTRACT_NAME
,      ABSENCE_ATTENDANCE_TYPE_ID
,      USE_ELEMENT_LINK
,      RULE_TYPE
FROM APPS.PAY_NET_CALCULATION_RULES_V;

Dependencies

[top of page]

APPS.PAY_NET_CALCULATION_RULES_V references the following:

SchemaAPPS
SynonymFND_SESSIONS
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
SynonymPAY_ACCRUAL_PLANS
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_ELEMENT_TYPES_F_TL
SynonymPAY_INPUT_VALUES_F
SynonymPAY_INPUT_VALUES_F_TL
SynonymPAY_NET_CALCULATION_RULES
APPS.PAY_NET_CALCULATION_RULES_V is referenced by following:

SchemaAPPS
Package BodyHXC_TIME_CATEGORY_HOOK - show dependent code
Package BodyHXT_UTIL - show dependent code