Product: | PAY - Payroll |
---|---|
Description: | Discoverer base view for pay_cost_allocation_keyflex |
Implementation/DBA Data: |
![]() |
SELECT PCAK.CONCATENATED_SEGMENTS
, PCAK.ID_FLEX_NUM
, PCAK.SUMMARY_FLAG
, PCAK.ENABLED_FLAG
, PCAK.START_DATE_ACTIVE
, PCAK.END_DATE_ACTIVE
, '_KF:PAY:COST:PCAK'
, PCAK.SEGMENT1
, PCAK.SEGMENT2
, PCAK.SEGMENT3
, PCAK.SEGMENT4
, PCAK.SEGMENT5
, PCAK.SEGMENT6
, PCAK.SEGMENT7
, PCAK.SEGMENT8
, PCAK.SEGMENT9
, PCAK.SEGMENT10
, PCAK.SEGMENT11
, PCAK.SEGMENT12
, PCAK.SEGMENT13
, PCAK.SEGMENT14
, PCAK.SEGMENT15
, PCAK.SEGMENT16
, PCAK.SEGMENT17
, PCAK.SEGMENT18
, PCAK.SEGMENT19
, PCAK.SEGMENT20
, PCAK.SEGMENT21
, PCAK.SEGMENT22
, PCAK.SEGMENT23
, PCAK.SEGMENT24
, PCAK.SEGMENT25
, PCAK.SEGMENT26
, PCAK.SEGMENT27
, PCAK.SEGMENT28
, PCAK.SEGMENT29
, PCAK.SEGMENT30
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCAK.SUMMARY_FLAG) SUMMARY_FLAG_CODE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCAK.ENABLED_FLAG) ENABLED_FLAG_CODE
, PCAK.COST_ALLOCATION_KEYFLEX_ID
, PCAK.LAST_UPDATE_DATE
, PCAK.LAST_UPDATED_BY
, PCAK.LAST_UPDATE_LOGIN
, PCAK.CREATED_BY
, PCAK.CREATION_DATE
FROM PAY_COST_ALLOCATION_KEYFLEX PCAK WITH READ ONLY