Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select taskId as id
- , forEmptyClient
- , forBank
- , forLegalPerson
- , forNaturalPerson
- , forSPDFL
- , enableQBE
- , angularRoute as route
- , rights.hasRight
- from JetB2Task
- , (select decode(count(0), 0, 0, 1) as hasRight
- from userTask ut
- where ut.taskId = :vTaskId
- and ut.userGroupId in (select ugl.userGroupId
- from userGroupLink ugl
- where ugl.userId in (select id
- from users
- where upper(userName) = sys_context('CX_B2_USER', 'USERNAME')))) rights
- where taskId = :vTaskId
Advertisement
Add Comment
Please, Sign In to add comment