[Home] [Help] [Dependency Information]
Object Name: | PAY_ACCRUAL_PLANS_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
LEAVE_BALANCE_TYPE | 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) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, LEAVE_BALANCE_TYPE
, 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;
|
|
|