DBA Data[Home] [Help]

APPS.POS_SUPPLIER_USER_REG_PKG dependencies on STANDARD

Line 629: AND wur.role_name like 'FND_RESP|%|%|STANDARD'

625: START WITH fme.function_id = func.function_id
626: CONNECT BY PRIOR menu_id = sub_menu_id
627: )
628: AND fr.application_id = 177
629: AND wur.role_name like 'FND_RESP|%|%|STANDARD'
630: AND WUR.ROLE_ORIG_SYSTEM = 'FND_RESP'
631: AND WUR.ROLE_ORIG_SYSTEM_ID = FR.RESPONSIBILITY_ID
632: AND WUR.ASSIGNMENT_TYPE IN ('D', 'B')
633: AND wur.user_name = fu.user_name

Line 700: AND wur.role_name like ''FND_RESP|%|%|STANDARD''

696: START WITH fme.function_id = :1
697: CONNECT BY PRIOR menu_id = sub_menu_id
698: )
699: AND fr.application_id = 177
700: AND wur.role_name like ''FND_RESP|%|%|STANDARD''
701: AND WUR.ROLE_ORIG_SYSTEM = ''FND_RESP''
702: AND WUR.ROLE_ORIG_SYSTEM_ID = FR.RESPONSIBILITY_ID
703: AND WUR.ASSIGNMENT_TYPE IN (''D'', ''B'')
704: AND wur.user_name = fu.user_name'