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

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
LEAVE_BALANCE_TYPE	VARCHAR2	(150)
OTHER_ADJUSTMENTS_TYPE	VARCHAR2	(150)
FOREIGN_WORKER_PLAN	VARCHAR2	(150)
ASSOCIATED_ACCRUAL_PLAN	VARCHAR2	(150)
ACCRUAL_START_MONTH	NUMBER
ENTITLEMENT_OFFSET	NUMBER
ENTITLEMENT_DURATION	NUMBER
MAIN_HOLIDAY_ACCRUAL_PLAN	VARCHAR2	(150)
ENT_MAIN_DAYS_INPUT_ID	VARCHAR2	(150)
OBS_MAIN_DAYS_INPUT_ID	VARCHAR2	(150)
ADJ_MAIN_DAYS_INPUT_ID	VARCHAR2	(150)
ENT_ACCRUAL_DATE_INPUT_ID	VARCHAR2	(150)
OBS_ACCRUAL_DATE_INPUT_ID	VARCHAR2	(150)
ADJ_ACCRUAL_DATE_INPUT_ID	VARCHAR2	(150)
ACCRUAL_WORKING_DAYS_INPUT_ID	VARCHAR2	(150)
TERMINATION_PAYMENT_DAYS	VARCHAR2	(150)
TERM_ACCRUAL_DATE_INPUT_ID	VARCHAR2	(150)
REGULARIZATION_ACCOUNTING	VARCHAR2	(150)
WORKING_DAYS	NUMBER
PROTECTED_DAYS	NUMBER
ACCOUNTING_METHOD	VARCHAR2	(150)
ENT_PROTECTED_DAYS_INPUT_ID	VARCHAR2	(240)
ENT_CONVENTIONAL_DAYS_INPUT_ID	VARCHAR2	(150)
ENT_SENIORITY_DAYS_INPUT_ID	VARCHAR2	(150)
ENT_YOUNG_MOTHERS_INPUT_ID	VARCHAR2	(150)
OBS_PROTECTED_DAYS_INPUT_ID	VARCHAR2	(150)
OBS_CONVENTIONAL_DAYS_INPUT_ID	VARCHAR2	(150)
OBS_SENIORITY_DAYS_INPUT_ID	VARCHAR2	(150)
OBS_YOUNG_MOTHERS_INPUT_ID	VARCHAR2	(150)
ADJ_PROTECTED_DAYS_INPUT_ID	VARCHAR2	(150)
ADJ_CONVENTIONAL_DAYS_INPUT_ID	VARCHAR2	(150)
ADJ_SENIORITY_DAYS_INPUT_ID	VARCHAR2	(150)
ADJ_YOUNG_MOTHERS_INPUT_ID	VARCHAR2	(150)
ACCRUAL_PROTECTED_DAY_INPUT_ID	VARCHAR2	(150)
OBJ_MAIN_DAYS_INPUT_ID	VARCHAR2	(150)
PAYMENT_PERCENTAGE	NUMBER
CONCATENATED_SEGMENTS	VARCHAR2	(4000)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      LEAVE_BALANCE_TYPE
,      OTHER_ADJUSTMENTS_TYPE
,      FOREIGN_WORKER_PLAN
,      ASSOCIATED_ACCRUAL_PLAN
,      ACCRUAL_START_MONTH
,      ENTITLEMENT_OFFSET
,      ENTITLEMENT_DURATION
,      MAIN_HOLIDAY_ACCRUAL_PLAN
,      ENT_MAIN_DAYS_INPUT_ID
,      OBS_MAIN_DAYS_INPUT_ID
,      ADJ_MAIN_DAYS_INPUT_ID
,      ENT_ACCRUAL_DATE_INPUT_ID
,      OBS_ACCRUAL_DATE_INPUT_ID
,      ADJ_ACCRUAL_DATE_INPUT_ID
,      ACCRUAL_WORKING_DAYS_INPUT_ID
,      TERMINATION_PAYMENT_DAYS
,      TERM_ACCRUAL_DATE_INPUT_ID
,      REGULARIZATION_ACCOUNTING
,      WORKING_DAYS
,      PROTECTED_DAYS
,      ACCOUNTING_METHOD
,      ENT_PROTECTED_DAYS_INPUT_ID
,      ENT_CONVENTIONAL_DAYS_INPUT_ID
,      ENT_SENIORITY_DAYS_INPUT_ID
,      ENT_YOUNG_MOTHERS_INPUT_ID
,      OBS_PROTECTED_DAYS_INPUT_ID
,      OBS_CONVENTIONAL_DAYS_INPUT_ID
,      OBS_SENIORITY_DAYS_INPUT_ID
,      OBS_YOUNG_MOTHERS_INPUT_ID
,      ADJ_PROTECTED_DAYS_INPUT_ID
,      ADJ_CONVENTIONAL_DAYS_INPUT_ID
,      ADJ_SENIORITY_DAYS_INPUT_ID
,      ADJ_YOUNG_MOTHERS_INPUT_ID
,      ACCRUAL_PROTECTED_DAY_INPUT_ID
,      OBJ_MAIN_DAYS_INPUT_ID
,      PAYMENT_PERCENTAGE
,      CONCATENATED_SEGMENTS
FROM APPS.PAY_ACCRUAL_PLANS_DFV;

Dependencies

[top of page]

APPS.PAY_ACCRUAL_PLANS_DFV references the following:

APPS: FND_NUMBER - show dependent code; PAY_ACCRUAL_PLANS

APPS.PAY_ACCRUAL_PLANS_DFV is not referenced by any database object