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_F1_DFV

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
MODELING_AVAILABILITY_RULE	VARCHAR2	(150)
DAYS_AFTER_PERIOD_START	NUMBER
DAYS_BEFORE_PERIOD_END	NUMBER
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)
TERMINATE_SEEDED_EARNINGS_BY	VARCHAR2	(150)
HR_PAYROLL_REPRESENTATIVE	VARCHAR2	(150)
USE_HOLIDAY_CARD	VARCHAR2	(150)
TAX_DAY_FORMULA	VARCHAR2	(150)
OVERTIME_SCHEME_TYPE	VARCHAR2	(150)
THRESHOLD	NUMBER
ANNUAL_QUOTA	NUMBER
WEEKLY_OFFSET_THRESHOLD	NUMBER
BONIFICATION_METHOD	VARCHAR2	(150)
MAJORATION_METHOD	VARCHAR2	(150)
WEEKLY_COMPENSATION_THRESHOLD	NUMBER
UPPER_COMPENSATION_THRESHOLD	NUMBER
LOWER_COMPENSATION_FACTOR	NUMBER
HIGHER_COMPENSATION_FACTOR	NUMBER
OVERTIME_BAND_TABLE	VARCHAR2	(150)
REGULARISATION_PERIOD_TYPE	VARCHAR2	(150)
REGULARISATION_PERIOD_WEEKS	NUMBER
REGULARISATION_THRESHOLD	NUMBER
REGULARISATION_OFFSET	NUMBER
REGULARISATION_PAYMENT_BASIS	VARCHAR2	(150)
REGULARISATION_START_DATE	DATE
OVERTIME_FORMULA	VARCHAR2	(150)
REGULARISATION_FORMULA	VARCHAR2	(150)
MARCH_SALARY_PAID_IN_APRIL	VARCHAR2	(150)
ITAX_DPNT_REF_TYPE	VARCHAR2	(150)
SI_COLLECTION_TYPE	VARCHAR2	(150)
YEA_FORMULA	VARCHAR2	(150)
GEPSAN_HIWP_MR_SYNC	VARCHAR2	(150)
GEPSAN_PROC_MMDD	VARCHAR2	(150)
ADDL_TAX_EXEM_FLAG	VARCHAR2	(150)
SP_TAX_EXEM_GOV_FLAG	VARCHAR2	(150)
ADDTL_CHILD_EXEM_GOV_FLAG	VARCHAR2	(150)
SP_TAX_EXEM_NP_PREM_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)
ISR_TAX_RATE	VARCHAR2	(150)
ISR_TAX_SUBSIDY	VARCHAR2	(150)
ISR_CREDIT_TO_SALARY	VARCHAR2	(150)
ISR_SUBSIDY_FOR_EMPL	VARCHAR2	(150)
ISR_TAX_ANNUAL_RATE	VARCHAR2	(150)
ISR_TAX_ANNUAL_SUBSIDY	VARCHAR2	(150)
ISR_ANNUAL_CREDIT_TO_SALARY	VARCHAR2	(150)
ISR_MONTHLY_TAX_RATE	VARCHAR2	(150)
ISR_MONTHLY_TAX_SUBSIDY	VARCHAR2	(150)
ISR_MONTHLY_CREDIT_TO_SALARY	VARCHAR2	(150)
EMPLOYER	VARCHAR2	(150)
SENDER	VARCHAR2	(150)
RECEIVER	VARCHAR2	(150)
MESSAGE_TYPE	VARCHAR2	(150)
HOURS_CALCULATION_TYPE	VARCHAR2	(150)
PRE_NOTIFICATION_ALLOWED	VARCHAR2	(150)
PQP_US_MODE_OF_PAYMENT_CODE	VARCHAR2	(150)
PPG_BILLING_CD	VARCHAR2	(150)
PLAN_NO	VARCHAR2	(150)
ITERATIVE_METHOD	VARCHAR2	(150)
PRE_TAX_FIT_TO_WITHIN	NUMBER
TIME_DEFINITION	VARCHAR2	(150)
PREMIUM_CALCULATION_RATE	VARCHAR2	(150)
USE_INFORMATION_HOURS_FROM	VARCHAR2	(150)
THRESHOLD_BASIS	VARCHAR2	(150)
TRANSACTION_TYPE	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(3352)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      MODELING_AVAILABILITY_RULE
,      DAYS_AFTER_PERIOD_START
,      DAYS_BEFORE_PERIOD_END
,      ROE_CONTACT_PERSON
,      ROE_CONTACT_PHONE
,      ROE_NAME_OF_ISSUER
,      CORRESPONDENCE_LANGUAGE
,      TAX_MULTIPLE_PAYMENTS_AS_ONE
,      TERMINATE_SEEDED_EARNINGS_BY
,      HR_PAYROLL_REPRESENTATIVE
,      USE_HOLIDAY_CARD
,      TAX_DAY_FORMULA
,      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
,      MARCH_SALARY_PAID_IN_APRIL
,      ITAX_DPNT_REF_TYPE
,      SI_COLLECTION_TYPE
,      YEA_FORMULA
,      GEPSAN_HIWP_MR_SYNC
,      GEPSAN_PROC_MMDD
,      ADDL_TAX_EXEM_FLAG
,      SP_TAX_EXEM_GOV_FLAG
,      ADDTL_CHILD_EXEM_GOV_FLAG
,      SP_TAX_EXEM_NP_PREM_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
,      ISR_TAX_RATE
,      ISR_TAX_SUBSIDY
,      ISR_CREDIT_TO_SALARY
,      ISR_SUBSIDY_FOR_EMPL
,      ISR_TAX_ANNUAL_RATE
,      ISR_TAX_ANNUAL_SUBSIDY
,      ISR_ANNUAL_CREDIT_TO_SALARY
,      ISR_MONTHLY_TAX_RATE
,      ISR_MONTHLY_TAX_SUBSIDY
,      ISR_MONTHLY_CREDIT_TO_SALARY
,      EMPLOYER
,      SENDER
,      RECEIVER
,      MESSAGE_TYPE
,      HOURS_CALCULATION_TYPE
,      PRE_NOTIFICATION_ALLOWED
,      PQP_US_MODE_OF_PAYMENT_CODE
,      PPG_BILLING_CD
,      PLAN_NO
,      ITERATIVE_METHOD
,      PRE_TAX_FIT_TO_WITHIN
,      TIME_DEFINITION
,      PREMIUM_CALCULATION_RATE
,      USE_INFORMATION_HOURS_FROM
,      THRESHOLD_BASIS
,      TRANSACTION_TYPE
,      CONCATENATED_SEGMENTS
FROM APPS.PAY_ALL_PAYROLLS_F1_DFV;

Dependencies

[top of page]

APPS.PAY_ALL_PAYROLLS_F1_DFV references the following:

APPS: FND_NUMBER - show dependent code; PAY_ALL_PAYROLLS_F

APPS.PAY_ALL_PAYROLLS_F1_DFV is not referenced by any database object