1. Tables and Views for HCM
  2. HWM_EXT_ACT_ALLOC_V

HWM_EXT_ACT_ALLOC_V

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

RESOURCE_ID

ALLOCATION_DATE

ALLOCATION_ID

ALLOCATION_VERSION

Query

SQL_Statement

select

alloc.resource_ID,

alloc.allocation_date,

alloc.TM_ACT_ALLOC_ID allocation_id,

alloc.TM_ACT_ALLOC_VERSION allocation_version

from HWM_TM_ACT_ALLOCS alloc,HWM_TM_ACT_ALLOC_STATUSES stat,

PER_ALL_PEOPLE_F pap

where

alloc.resource_id = pap.person_id

and pap.person_number = nvl(pay_report_utils.get_parameter_value('PERSON_NUMBER'),pap.person_number)

and alloc.allocation_date between nvl(trunc(pay_report_utils.get_parameter_value_date('START_DATE')), to_date('1952-01-01','YYYY-MM-DD'))

and nvl(trunc(pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE')), to_date('4712-12-31','YYYY-MM-DD'))

and stat.TM_ACT_ALLOC_ID = alloc.TM_ACT_ALLOC_ID

and stat.TM_ACT_ALLOC_VERSION = alloc.TM_ACT_ALLOC_VERSION

and systimestamp between stat.date_from and stat.date_to

and alloc.latest_version='Y'

and stat.allocation_status='ORA_HWM_AA_VALID'

and stat.TRANSFER_STATUS='ORA_HWM_AA_STAT_NOT_TRANS'