PAY_PAYROLL_ACTION_LOCKS_V

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
PAYROLL_ACTION_ID <column 2>

Query

SQL_Statement
select payroll_action_id, decode (pay_action_status.get_action_count(payroll_action_id), 0, 'N', pay_action_status.get_locked_action_count(payroll_action_id), 'Y', 'N' ) from pay_payroll_actions