PAY_VALUE_INSTANCES

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
VALUE_DEFN_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE BASE_NAME VALUE_GROUP_ID PARENT_VALUE_DEFN_ID SOURCE_ID SOURCE_TYPE DIR_OVERRIDE_USAGE_ID ENTERPRISE_ID LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID UOM PERIODICITY PERIODICITY_TYPE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY CALC_TYPE_ID DATABASE_ITEM_ID RANGE_DATABASE_ITEM_ID DATE_MODE CURRENCY_CODE SEED_STATUS

Name

VALUE_DEFN_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

BASE_NAME

VALUE_GROUP_ID

PARENT_VALUE_DEFN_ID

SOURCE_ID

SOURCE_TYPE

DIR_OVERRIDE_USAGE_ID

ENTERPRISE_ID

LEGISLATION_CODE

LEGISLATIVE_DATA_GROUP_ID

UOM

PERIODICITY

PERIODICITY_TYPE

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

CALC_TYPE_ID

DATABASE_ITEM_ID

RANGE_DATABASE_ITEM_ID

DATE_MODE

CURRENCY_CODE

SEED_STATUS

Query

SQL_Statement
SELECT PAY_VALUE_DEFINITIONS_F.VALUE_DEFN_ID, PAY_VALUE_DEFINITIONS_F.EFFECTIVE_START_DATE, PAY_VALUE_DEFINITIONS_F.EFFECTIVE_END_DATE, PAY_VALUE_DEFINITIONS_F.BASE_NAME, PAY_VALUE_DEFINITIONS_F.VALUE_GROUP_ID, PAY_VALUE_DEFINITIONS_F.PARENT_VALUE_DEFN_ID, PAY_VALUE_DEFINITIONS_F.SOURCE_ID, PAY_VALUE_DEFINITIONS_F.SOURCE_TYPE, PAY_VALUE_DEFINITIONS_F.DIR_OVERRIDE_USAGE_ID, PAY_VALUE_DEFINITIONS_F.ENTERPRISE_ID, PAY_VALUE_DEFINITIONS_F.LEGISLATION_CODE, PAY_VALUE_DEFINITIONS_F.LEGISLATIVE_DATA_GROUP_ID, PAY_VALUE_DEFINITIONS_F.UOM, PAY_VALUE_DEFINITIONS_F.PERIODICITY, PAY_VALUE_DEFINITIONS_F.PERIODICITY_TYPE, PAY_VALUE_DEFINITIONS_F.OBJECT_VERSION_NUMBER, PAY_VALUE_DEFINITIONS_F.CREATED_BY, PAY_VALUE_DEFINITIONS_F.CREATION_DATE, PAY_VALUE_DEFINITIONS_F.LAST_UPDATE_DATE, PAY_VALUE_DEFINITIONS_F.LAST_UPDATE_LOGIN, PAY_VALUE_DEFINITIONS_F.LAST_UPDATED_BY, PAY_VALUE_DEFINITIONS_F.CALC_TYPE_ID, PAY_VALUE_DEFINITIONS_F.DATABASE_ITEM_ID, PAY_VALUE_DEFINITIONS_F.RANGE_DATABASE_ITEM_ID, PAY_VALUE_DEFINITIONS_F.DATE_MODE, PAY_VALUE_DEFINITIONS_F.CURRENCY_CODE, PAY_VALUE_DEFINITIONS_F.SEED_STATUS FROM pay_old_value_defns_f PAY_VALUE_DEFINITIONS_f WHERE SOURCE_TYPE = 'PDCC' /* and not exists (select '' from pay_value_insts_f value_inst where value_inst.value_inst_id = PAY_VALUE_DEFINITIONS_F.value_defn_id) union all SELECT value_inst.VALUE_INST_ID, value_inst.EFFECTIVE_START_DATE, value_inst.EFFECTIVE_END_DATE, value_def.BASE_NAME, value_def.VALUE_GROUP_ID, value_inst.PARENT_VALUE_DEFN_ID, value_inst.SOURCE_ID, value_inst.SOURCE_TYPE, value_inst.DIR_OVERRIDE_USAGE_ID, value_inst.ENTERPRISE_ID, value_inst.LEGISLATION_CODE, value_inst.LEGISLATIVE_DATA_GROUP_ID, value_inst.UOM, value_inst.PERIODICITY, value_inst.PERIODICITY_TYPE, value_inst.OBJECT_VERSION_NUMBER, value_inst.CREATED_BY, value_inst.CREATION_DATE, value_inst.LAST_UPDATE_DATE, value_inst.LAST_UPDATE_LOGIN, value_inst.LAST_UPDATED_BY, nvl(value_inst.CALC_TYPE_ID, value_def. CALC_TYPE_ID), value_def.DATABASE_ITEM_ID, value_def.RANGE_DATABASE_ITEM_ID, value_def.DATE_MODE, nvl(value_inst.CURRENCY_CODE, value_def. CURRENCY_CODE), null FROM pay_value_insts_f value_inst, pay_value_defs_f value_def WHERE value_inst. parent_value_defn_id = value_def.value_defn_id and value_inst.effective_start_date between value_def.effective_start_date and value_def.effective_end_date */

SQL_Statement

SELECT

PAY_VALUE_DEFINITIONS_F.VALUE_DEFN_ID,

PAY_VALUE_DEFINITIONS_F.EFFECTIVE_START_DATE,

PAY_VALUE_DEFINITIONS_F.EFFECTIVE_END_DATE,

PAY_VALUE_DEFINITIONS_F.BASE_NAME,

PAY_VALUE_DEFINITIONS_F.VALUE_GROUP_ID,

PAY_VALUE_DEFINITIONS_F.PARENT_VALUE_DEFN_ID,

PAY_VALUE_DEFINITIONS_F.SOURCE_ID,

PAY_VALUE_DEFINITIONS_F.SOURCE_TYPE,

PAY_VALUE_DEFINITIONS_F.DIR_OVERRIDE_USAGE_ID,

PAY_VALUE_DEFINITIONS_F.ENTERPRISE_ID,

PAY_VALUE_DEFINITIONS_F.LEGISLATION_CODE,

PAY_VALUE_DEFINITIONS_F.LEGISLATIVE_DATA_GROUP_ID,

PAY_VALUE_DEFINITIONS_F.UOM,

PAY_VALUE_DEFINITIONS_F.PERIODICITY,

PAY_VALUE_DEFINITIONS_F.PERIODICITY_TYPE,

PAY_VALUE_DEFINITIONS_F.OBJECT_VERSION_NUMBER,

PAY_VALUE_DEFINITIONS_F.CREATED_BY,

PAY_VALUE_DEFINITIONS_F.CREATION_DATE,

PAY_VALUE_DEFINITIONS_F.LAST_UPDATE_DATE,

PAY_VALUE_DEFINITIONS_F.LAST_UPDATE_LOGIN,

PAY_VALUE_DEFINITIONS_F.LAST_UPDATED_BY,

PAY_VALUE_DEFINITIONS_F.CALC_TYPE_ID,

PAY_VALUE_DEFINITIONS_F.DATABASE_ITEM_ID,

PAY_VALUE_DEFINITIONS_F.RANGE_DATABASE_ITEM_ID,

PAY_VALUE_DEFINITIONS_F.DATE_MODE,

PAY_VALUE_DEFINITIONS_F.CURRENCY_CODE,

PAY_VALUE_DEFINITIONS_F.SEED_STATUS

FROM

pay_old_value_defns_f PAY_VALUE_DEFINITIONS_f

WHERE

SOURCE_TYPE = 'PDCC'

/*

and not exists (select ''

from pay_value_insts_f value_inst

where value_inst.value_inst_id = PAY_VALUE_DEFINITIONS_F.value_defn_id)

union all

SELECT

value_inst.VALUE_INST_ID,

value_inst.EFFECTIVE_START_DATE,

value_inst.EFFECTIVE_END_DATE,

value_def.BASE_NAME,

value_def.VALUE_GROUP_ID,

value_inst.PARENT_VALUE_DEFN_ID,

value_inst.SOURCE_ID,

value_inst.SOURCE_TYPE,

value_inst.DIR_OVERRIDE_USAGE_ID,

value_inst.ENTERPRISE_ID,

value_inst.LEGISLATION_CODE,

value_inst.LEGISLATIVE_DATA_GROUP_ID,

value_inst.UOM,

value_inst.PERIODICITY,

value_inst.PERIODICITY_TYPE,

value_inst.OBJECT_VERSION_NUMBER,

value_inst.CREATED_BY,

value_inst.CREATION_DATE,

value_inst.LAST_UPDATE_DATE,

value_inst.LAST_UPDATE_LOGIN,

value_inst.LAST_UPDATED_BY,

nvl(value_inst.CALC_TYPE_ID, value_def. CALC_TYPE_ID),

value_def.DATABASE_ITEM_ID,

value_def.RANGE_DATABASE_ITEM_ID,

value_def.DATE_MODE,

nvl(value_inst.CURRENCY_CODE, value_def. CURRENCY_CODE),

null

FROM

pay_value_insts_f value_inst,

pay_value_defs_f value_def

WHERE

value_inst. parent_value_defn_id = value_def.value_defn_id

and value_inst.effective_start_date between value_def.effective_start_date

and value_def.effective_end_date

*/