[Home] [Help] [Dependency Information]
Object Name: | PA_COMP_OT_EXP_TYPES |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_COMP_OT_EXP_TYPES |
Subobject Name: | |
Status: | VALID |
PA_COMP_OT_EXP_TYPES assigns labor cost multipliers to overtime expenditure types for each labor costing rule. The multipliers are applied as raw cost is calculated for transactions charged to the associated expenditure types.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_COMP_OT_EXP_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LABOR_COSTING_RULE
EXPENDITURE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LABOR_COSTING_RULE | VARCHAR2 | (150) | Yes | Implementation defined name that uniquely identifies the costing rule. |
EXPENDITURE_TYPE | VARCHAR2 | (150) | Yes | Overtime expenditure type to which premium rates are applied. |
LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | (150) | Labor Cost Multiplier used to calculate premium overtime amounts | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT LABOR_COSTING_RULE
, EXPENDITURE_TYPE
, LABOR_COST_MULTIPLIER_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM PA.PA_COMP_OT_EXP_TYPES;
PA.PA_COMP_OT_EXP_TYPES does not reference any database object
PA.PA_COMP_OT_EXP_TYPES is referenced by following:
|
|
|