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_ALL_PAYROLLS_F_DFV

Object Details

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

[View Source]

Columns

Name	Datatype	Length
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)

Query Text

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;

Dependencies

[top of page]

APPS.PAY_ALL_PAYROLLS_F_DFV references the following:

APPS: FND_NUMBER - show dependent code; PAY_ALL_PAYROLLS_F

APPS.PAY_ALL_PAYROLLS_F_DFV is not referenced by any database object