PAY_ACTION_INTERLOCK_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
LOCKING_ACTION_ID LOCKING_ACTION_TYPE OBJECT_ACTION_ID LOCKING_PAYROLL_ACTION_ID

Query

SQL_Statement

select distinct zzz.locking_action_id, zzz.locking_action_type, zzz.Object_action_id, Locking_payroll_Action_Id from (select locking_action_id , case when i_pact.action_type='M' or i_pact.action_type='H' or i_pact.action_type='A' or i_pact.action_type='E' then decode((select max(1) from pay_pre_payments ppp where ppp.payroll_rel_action_id=ract.payroll_rel_action_id and not exists( select 1 from pay_payroll_rel_actions paym where ppp.pre_payment_id=paym.pre_payment_id)),1,'XXX',i_pact.action_type) else i_pact.action_type end locking_action_type, ract.payroll_rel_action_id Object_action_id, i_ract.payroll_action_id Locking_payroll_Action_Id from pay_action_interlocks int, pay_payroll_rel_actions ract, pay_payroll_actions pact, pay_payroll_rel_actions i_ract, pay_payroll_actions i_pact where ract.payroll_rel_action_id = int.locked_action_id and pact.payroll_action_id = ract.payroll_action_id and i_ract.payroll_rel_action_id = int.locking_action_id and i_pact.payroll_action_id = i_ract.payroll_action_id and ract.source_action_id is null and exists ( select null from pay_payroll_rel_actions tlsa_ract, pay_payroll_actions tlsa_pact where tlsa_ract.payroll_rel_action_id = int.locking_action_id and tlsa_pact.payroll_action_id = tlsa_ract.payroll_action_id and tlsa_pact.action_type not in ('TV')) union all select locking_action_id , case when i_pact.action_type='M' or i_pact.action_type='H' or i_pact.action_type='A' or i_pact.action_type='E' then decode((select max(1) from pay_pre_payments ppp where ppp.payroll_rel_action_id=ract.payroll_rel_action_id and not exists( select 1 from pay_payroll_rel_actions paym where ppp.pre_payment_id=paym.pre_payment_id)),1,'XXX',i_pact.action_type) else i_pact.action_type end locking_action_type, ract.source_action_id Object_action_id, i_ract.payroll_action_id Locking_payroll_Action_Id from pay_action_interlocks int, pay_payroll_rel_actions ract, pay_payroll_actions pact, pay_payroll_rel_actions i_ract, pay_payroll_actions i_pact where ract.payroll_rel_action_id = int.locked_action_id and pact.payroll_action_id = ract.payroll_action_id and i_ract.payroll_rel_action_id = int.locking_action_id and i_pact.payroll_action_id = i_ract.payroll_action_id and ract.source_action_id is not null and exists ( select null from pay_payroll_rel_actions tlsa_ract, pay_payroll_actions tlsa_pact where tlsa_ract.payroll_rel_action_id = int.locking_action_id and tlsa_pact.payroll_action_id = tlsa_ract.payroll_action_id and tlsa_pact.action_type not in ('TV')) ) zzz