DBA Data[Home] [Help]

APPS.FND_LOOKUP_TYPES_PKG dependencies on FND_SECURITY_GROUPS

Line 548: from FND_LOOKUP_TYPES LT, FND_SECURITY_GROUPS SG

544: db_ludate date; -- entity update date in db
545:
546: cursor secgrp_curs is
547: select SG.SECURITY_GROUP_ID
548: from FND_LOOKUP_TYPES LT, FND_SECURITY_GROUPS SG
549: where LT.LOOKUP_TYPE = x_lookup_type
550: and LT.VIEW_APPLICATION_ID = view_appid
551: and LT.SECURITY_GROUP_ID = SG.SECURITY_GROUP_ID
552: and SG.SECURITY_GROUP_KEY like nvl(x_security_group, 'STANDARD');

Line 580: from FND_SECURITY_GROUPS

576: -- No matching rows in any security group.
577: -- Insert a single row in requested security group
578: select SECURITY_GROUP_ID
579: into secgrp_id
580: from FND_SECURITY_GROUPS
581: where SECURITY_GROUP_KEY = nvl(x_security_group, 'STANDARD');
582:
583: Fnd_Lookup_Types_Pkg.Insert_Row(
584: x_rowid => row_id,