[Home] [Help]
| Product: | PAY - Payroll |
|---|---|
| Description: | Discoverer base view for pay_costs. |
| Implementation/DBA Data: |
APPS.PAYBV_COST
|
SELECT PC.COSTED_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('DEBIT_CREDIT'
, PC.DEBIT_OR_CREDIT) DEBIT_OR_CREDIT
, HR_BIS.BIS_DECODE_LOOKUP('BALANCE_COST'
, PC.BALANCE_OR_COST) BALANCE_OR_COST
, PC.DEBIT_OR_CREDIT DEBIT_OR_CREDIT_CODE
, PC.BALANCE_OR_COST BALANCE_OR_COST_CODE
, PC.COST_ID
, PC.ASSIGNMENT_ACTION_ID
, PC.INPUT_VALUE_ID
, PC.RUN_RESULT_ID
, PC.COST_ALLOCATION_KEYFLEX_ID
, PC.DISTRIBUTED_INPUT_VALUE_ID
, PC.DISTRIBUTED_RUN_RESULT_ID
, PC.SOURCE_ID
FROM PAY_COSTS PC WITH READ ONLY