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_ELEMENT_TEMPLATES_CONF_DFV

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
ALLOWANCE_NAME	VARCHAR2	(150)
NATURE_OF_EXPENSE	VARCHAR2	(150)
ENABLE_ADVANCES	VARCHAR2	(150)
ENABLE_PROJECTIONS	VARCHAR2	(150)
CREATE_EXPENSE_ELEMENT	VARCHAR2	(150)
IS_HRA	VARCHAR2	(150)
IS_ENTERTAINMENT	VARCHAR2	(150)
ADVANCE_FOR_HRA	VARCHAR2	(150)
ADVANCE_FOR_ENTERTAINMENT	VARCHAR2	(150)
PERQUISITE_NAME	VARCHAR2	(150)
PROJECT_TAXABLE_VALUE	VARCHAR2	(150)
PAID_AND_DISPLAYED_AS_EARNINGS	VARCHAR2	(150)
ESI_ELIGIBILITY	VARCHAR2	(150)
ESI_COMPUTATION_BASE	VARCHAR2	(150)
PF_COMPUTATION_BASE	VARCHAR2	(150)
PT_COMPUTATION_BASE	VARCHAR2	(150)
PT_PROJECTION_BASE	VARCHAR2	(150)
HRA_BASE	VARCHAR2	(150)
COMPANY_ACCOMMODATION_BASE	VARCHAR2	(150)
NOTICE_PAY_BASE	VARCHAR2	(150)
LEAVE_ENCASHMENT_BASE	VARCHAR2	(150)
GRATUITY_ELIGIBILITY	VARCHAR2	(150)
USED_FOR_PENSION_CONTRIBUTION	VARCHAR2	(150)
USED_FOR_PENSION_EXEMPTION	VARCHAR2	(150)
IS_CEA_OR_HEA	VARCHAR2	(150)
CATEGORY	VARCHAR2	(150)
IS_MEDICAL	VARCHAR2	(150)
FRINGE_BENEFIT_TAX	VARCHAR2	(150)
PROJECT_TAXABLE_VALUES	VARCHAR2	(150)
TAXABLE	VARCHAR2	(150)
CLUB_EXPENDITURE_OR_CARD	VARCHAR2	(150)
SEPARATE_PAYMENT	VARCHAR2	(150)
SEPARATE_PAYMENT_IV	VARCHAR2	(150)
PROCESS_SEPARATELY_IV	VARCHAR2	(150)
TAX_PROCESSING_TYPE	VARCHAR2	(150)
DBC1___DAYS_BASIS_OF_QUOTATION	VARCHAR2	(150)
DBC2___DAYS_BASIS_OF_QUOTATION	VARCHAR2	(150)
DBC3___DAYS_BASIS_OF_QUOTATION	VARCHAR2	(150)
EMPLOYER_LIABILITIES_BAL	VARCHAR2	(150)
ELIGIBLE_WORKED_DAYS_FOR_PTU	VARCHAR2	(150)
INSUFFICIENT_FUNDS_TYPE	VARCHAR2	(150)
EXCLUSION_RULE_FOR_ARREARAGE	VARCHAR2	(150)
STOP_WHEN_TOTAL_REACHED	VARCHAR2	(150)
INFONAVIT	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(1993)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      ALLOWANCE_NAME
,      NATURE_OF_EXPENSE
,      ENABLE_ADVANCES
,      ENABLE_PROJECTIONS
,      CREATE_EXPENSE_ELEMENT
,      IS_HRA
,      IS_ENTERTAINMENT
,      ADVANCE_FOR_HRA
,      ADVANCE_FOR_ENTERTAINMENT
,      PERQUISITE_NAME
,      PROJECT_TAXABLE_VALUE
,      PAID_AND_DISPLAYED_AS_EARNINGS
,      ESI_ELIGIBILITY
,      ESI_COMPUTATION_BASE
,      PF_COMPUTATION_BASE
,      PT_COMPUTATION_BASE
,      PT_PROJECTION_BASE
,      HRA_BASE
,      COMPANY_ACCOMMODATION_BASE
,      NOTICE_PAY_BASE
,      LEAVE_ENCASHMENT_BASE
,      GRATUITY_ELIGIBILITY
,      USED_FOR_PENSION_CONTRIBUTION
,      USED_FOR_PENSION_EXEMPTION
,      IS_CEA_OR_HEA
,      CATEGORY
,      IS_MEDICAL
,      FRINGE_BENEFIT_TAX
,      PROJECT_TAXABLE_VALUES
,      TAXABLE
,      CLUB_EXPENDITURE_OR_CARD
,      SEPARATE_PAYMENT
,      SEPARATE_PAYMENT_IV
,      PROCESS_SEPARATELY_IV
,      TAX_PROCESSING_TYPE
,      DBC1___DAYS_BASIS_OF_QUOTATION
,      DBC2___DAYS_BASIS_OF_QUOTATION
,      DBC3___DAYS_BASIS_OF_QUOTATION
,      EMPLOYER_LIABILITIES_BAL
,      ELIGIBLE_WORKED_DAYS_FOR_PTU
,      INSUFFICIENT_FUNDS_TYPE
,      EXCLUSION_RULE_FOR_ARREARAGE
,      STOP_WHEN_TOTAL_REACHED
,      INFONAVIT
,      CONCATENATED_SEGMENTS
FROM APPS.PAY_ELEMENT_TEMPLATES_CONF_DFV;

Dependencies

[top of page]

APPS.PAY_ELEMENT_TEMPLATES_CONF_DFV references the following:

APPS: PAY_ELEMENT_TEMPLATES

APPS.PAY_ELEMENT_TEMPLATES_CONF_DFV is not referenced by any database object