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.PQP_OMP_TEMPLATE_V

Object Details

Object Name:	PQP_OMP_TEMPLATE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQP.PQP_OMP_TEMPLATE_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_TYPE_ID	NUMBER	(9)	Yes	Primary key of absence information element
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code
CLASSIFICATION_ID	NUMBER	(9)	Yes	Foreign key to HR_ORG_CLASSIFICATIONS
CLASSIFICATION_NAME	VARCHAR2	(80)		Classification of absence information element
PROCESSING_TYPE	VARCHAR2	(30)	Yes	Processing type of the absence information element
BASE_NAME	VARCHAR2	(50)		Base element name
ELEMENT_NAME	VARCHAR2	(80)	Yes	Element name
REPORTING_NAME	VARCHAR2	(80)		Reporting name of the element
DESCRIPTION	VARCHAR2	(240)		Description of absence information element
PROCESSING_PRIORITY	NUMBER	(9)	Yes	Processing priority of the element
EFFECTIVE_START_DATE	DATE		Yes	Effective start date of the element
EFFECTIVE_END_DATE	DATE		Yes	Effective end date of the element
PLAN_ID	VARCHAR2	(150)		Benefits plan id
PLAN_NAME	VARCHAR2	(240)	Yes	Benefits plan name
PLAN_DESCRIPTION	VARCHAR2	(150)		Benefits plan description
LOS_CALC	VARCHAR2	(150)		OMP qualifying date
LOS_DURATION	VARCHAR2	(150)		OMP qualifying date duration
LOS_UOM	VARCHAR2	(150)		OMP qualifying date Unit of measure
AVGEARN_DURATION	VARCHAR2	(150)		Average earnings calculation duration
AVGEARN_UOM	VARCHAR2	(150)		Average earnings calculation unit of measure
AVGEARN_BALNAME	VARCHAR2	(150)		Average earnings calculation balance name
ABS_DAYS	VARCHAR2	(150)		Absence Entitlement Type
ABS_ENT_MATLEAVES_UDT_ID	VARCHAR2	(150)		Absence entitlement parameters user defined table id
ABS_ENT_MATERNITY_LEAVES	VARCHAR2	(80)		Absence entitlement parameters user defined table name
ABS_ENT_HOLIDAYS_UDT_ID	VARCHAR2	(150)		Absence entitlement calendar user defined table id
ABS_ENT_HOLIDAYS	VARCHAR2	(80)		Absence entitlement calendar user defined table name
ABS_DAILYRATE_CALC	VARCHAR2	(150)		Absence daily rate divisor
ABS_DAILYRATE_CALC_PERIOD	VARCHAR2	(150)		Absence daily rate divisor type
ABS_DAILYRATE_CALC_DURATION	VARCHAR2	(150)		Absence daily rate divisor duration
ABS_PAY_INFO_SRC_COMP	VARCHAR2	(150)		Pay Component Rate Type
ABS_PAY_INFO_SRC_COMP_NAME	VARCHAR2	(80)		Pay Component Rate Type Name
PRIMARY_ABS_INFO_ELE_FLAG	VARCHAR2	(150)		Primary absence information element flag
ABS_DEFAULT_WORKPATTERN	VARCHAR2	(150)		Default work pattern name
ELEMENT_TYPE	VARCHAR2	(150)		Element type
ABS_TYPES_LIST_NAME	VARCHAR2	(150)		Absence types list name
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CREATED_BY	NUMBER	(15)		Standard WHO column
CREATION_DATE	DATE			Standard WHO column
ABSENCE_CATEGORY	VARCHAR2	(150)		Stores Absence Category i.e. Maternity

Query Text

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


SELECT ELEMENT_TYPE_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      CLASSIFICATION_ID
,      CLASSIFICATION_NAME
,      PROCESSING_TYPE
,      BASE_NAME
,      ELEMENT_NAME
,      REPORTING_NAME
,      DESCRIPTION
,      PROCESSING_PRIORITY
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PLAN_ID
,      PLAN_NAME
,      PLAN_DESCRIPTION
,      LOS_CALC
,      LOS_DURATION
,      LOS_UOM
,      AVGEARN_DURATION
,      AVGEARN_UOM
,      AVGEARN_BALNAME
,      ABS_DAYS
,      ABS_ENT_MATLEAVES_UDT_ID
,      ABS_ENT_MATERNITY_LEAVES
,      ABS_ENT_HOLIDAYS_UDT_ID
,      ABS_ENT_HOLIDAYS
,      ABS_DAILYRATE_CALC
,      ABS_DAILYRATE_CALC_PERIOD
,      ABS_DAILYRATE_CALC_DURATION
,      ABS_PAY_INFO_SRC_COMP
,      ABS_PAY_INFO_SRC_COMP_NAME
,      PRIMARY_ABS_INFO_ELE_FLAG
,      ABS_DEFAULT_WORKPATTERN
,      ELEMENT_TYPE
,      ABS_TYPES_LIST_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ABSENCE_CATEGORY
FROM APPS.PQP_OMP_TEMPLATE_V;

Dependencies

[top of page]

APPS.PQP_OMP_TEMPLATE_V references the following:

APPS: BEN_PL_F; BEN_PL_TYP_F; FND_GLOBAL - show dependent code; FND_NUMBER - show dependent code; FND_SESSIONS; HR_API - show dependent code; HR_LOOKUPS; PAY_ELEMENT_CLASSIFICATIONS; PAY_ELEMENT_TEMPLATES; PAY_ELEMENT_TYPES_F; PAY_ELEMENT_TYPE_EXTRA_INFO; PAY_TEMPLATE_CORE_OBJECTS; PAY_USER_TABLES

APPS.PQP_OMP_TEMPLATE_V is referenced by following:

PUBLIC: PQP_OMP_TEMPLATE_V