DBA Data[Home] [Help]

APPS.HR_DTY_BUS dependencies on FND_GLOBAL

Line 142: and FLV.SECURITY_GROUP_ID = decode(substr(userenv('CLIENT_INFO'),55,1), ' ', 0, NULL, 0, '0', 0, fnd_global.lookup_security_group(FLV.LOOKUP_TYPE,FLV.VIEW_APPLICATION_ID))

138: WHERE FLV.lookup_type = 'DOCUMENT_CATEGORY'
139: and FLV.lookup_code = p_category_cd
140: AND FLV.LANGUAGE = userenv('LANG')
141: and FLV.VIEW_APPLICATION_ID = 3
142: and FLV.SECURITY_GROUP_ID = decode(substr(userenv('CLIENT_INFO'),55,1), ' ', 0, NULL, 0, '0', 0, fnd_global.lookup_security_group(FLV.LOOKUP_TYPE,FLV.VIEW_APPLICATION_ID))
143: and decode(FLV.TAG, NULL, 'Y',
144: decode(substr(FLV.TAG,1,1), '+', decode(sign(instr(FLV.TAG, p_legislation_code)), 1, 'Y', 'N'),
145: '-', decode(sign(instr(FLV.TAG, p_legislation_code)), 1, 'N', 'Y'), 'Y' ) ) = 'Y';
146: --