[Home] [Help] [Dependency Information]
Object Name: | PAY_ALL_PAYROLLS_F_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
ROE_CONTACT_PERSON | VARCHAR2 | (150) | ||
ROE_CONTACT_PHONE | VARCHAR2 | (150) | ||
ROE_NAME_OF_ISSUER | VARCHAR2 | (150) | ||
CORRESPONDENCE_LANGUAGE | VARCHAR2 | (150) | ||
TAX_MULTIPLE_PAYMENTS_AS_ONE | VARCHAR2 | (150) | ||
OVERTIME_SCHEME_TYPE | VARCHAR2 | (150) | ||
THRESHOLD | VARCHAR2 | (150) | ||
ANNUAL_QUOTA | VARCHAR2 | (150) | ||
WEEKLY_OFFSET_THRESHOLD | VARCHAR2 | (150) | ||
BONIFICATION_METHOD | VARCHAR2 | (150) | ||
MAJORATION_METHOD | VARCHAR2 | (150) | ||
WEEKLY_COMPENSATION_THRESHOLD | VARCHAR2 | (150) | ||
UPPER_COMPENSATION_THRESHOLD | VARCHAR2 | (150) | ||
LOWER_COMPENSATION_FACTOR | VARCHAR2 | (150) | ||
HIGHER_COMPENSATION_FACTOR | VARCHAR2 | (150) | ||
OVERTIME_BAND_TABLE | VARCHAR2 | (150) | ||
REGULARISATION_PERIOD_TYPE | VARCHAR2 | (150) | ||
REGULARISATION_PERIOD_WEEKS | VARCHAR2 | (150) | ||
REGULARISATION_THRESHOLD | VARCHAR2 | (150) | ||
REGULARISATION_OFFSET | VARCHAR2 | (150) | ||
REGULARISATION_PAYMENT_BASIS | VARCHAR2 | (150) | ||
REGULARISATION_START_DATE | DATE | |||
OVERTIME_FORMULA | VARCHAR2 | (150) | ||
REGULARISATION_FORMULA | VARCHAR2 | (150) | ||
ITAX_DPNT_REF_TYPE | VARCHAR2 | (150) | ||
ADDL_TAX_EXEM_FLAG | VARCHAR2 | (150) | ||
SP_TAX_EXEM_GOV_FLAG | VARCHAR2 | (150) | ||
SP_TAX_EXEM_HI_PREM_FLAG | VARCHAR2 | (150) | ||
SP_TAX_EXEM_EI_PREM_FLAG | VARCHAR2 | (150) | ||
SP_TAX_EXEM_ADJ_AMOUNT | NUMBER | |||
MIN_SP_TAX_EXEM_FLAG | VARCHAR2 | (150) | ||
NP_PREM_TAX_EXEM_FLAG | VARCHAR2 | (150) | ||
HR_PAYROLL_REPRESENTATIVE | VARCHAR2 | (150) | ||
HOURS_CALCULATION_TYPE | VARCHAR2 | (150) | ||
PRE_NOTIFICATION_ALLOWED | VARCHAR2 | (150) | ||
PQP_US_MODE_OF_PAYMENT_CODE | VARCHAR2 | (150) | ||
TERMINATE_SEEDED_EARNINGS_BY | VARCHAR2 | (150) | ||
PPG_BILLING_CD | VARCHAR2 | (150) | ||
ITERATIVE_METHOD | VARCHAR2 | (150) | ||
PRE_TAX_FIT_TO_WITHIN | NUMBER | |||
CONCATENATED_SEGMENTS | VARCHAR2 | (2899) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, ROE_CONTACT_PERSON
, ROE_CONTACT_PHONE
, ROE_NAME_OF_ISSUER
, CORRESPONDENCE_LANGUAGE
, TAX_MULTIPLE_PAYMENTS_AS_ONE
, OVERTIME_SCHEME_TYPE
, THRESHOLD
, ANNUAL_QUOTA
, WEEKLY_OFFSET_THRESHOLD
, BONIFICATION_METHOD
, MAJORATION_METHOD
, WEEKLY_COMPENSATION_THRESHOLD
, UPPER_COMPENSATION_THRESHOLD
, LOWER_COMPENSATION_FACTOR
, HIGHER_COMPENSATION_FACTOR
, OVERTIME_BAND_TABLE
, REGULARISATION_PERIOD_TYPE
, REGULARISATION_PERIOD_WEEKS
, REGULARISATION_THRESHOLD
, REGULARISATION_OFFSET
, REGULARISATION_PAYMENT_BASIS
, REGULARISATION_START_DATE
, OVERTIME_FORMULA
, REGULARISATION_FORMULA
, ITAX_DPNT_REF_TYPE
, ADDL_TAX_EXEM_FLAG
, SP_TAX_EXEM_GOV_FLAG
, SP_TAX_EXEM_HI_PREM_FLAG
, SP_TAX_EXEM_EI_PREM_FLAG
, SP_TAX_EXEM_ADJ_AMOUNT
, MIN_SP_TAX_EXEM_FLAG
, NP_PREM_TAX_EXEM_FLAG
, HR_PAYROLL_REPRESENTATIVE
, HOURS_CALCULATION_TYPE
, PRE_NOTIFICATION_ALLOWED
, PQP_US_MODE_OF_PAYMENT_CODE
, TERMINATE_SEEDED_EARNINGS_BY
, PPG_BILLING_CD
, ITERATIVE_METHOD
, PRE_TAX_FIT_TO_WITHIN
, CONCATENATED_SEGMENTS
FROM APPS.PAY_ALL_PAYROLLS_F_DFV;
|
|
|