APPS.IGW_PROP_USER_ROLES_PVT dependencies on IGW_ROLES

Line 544: FROM igw_roles_tl

540:
541: IF p_role_name IS NOT NULL THEN
542: SELECT role_id
543: INTO x_role_id
544: FROM igw_roles_tl
545: WHERE upper(role_name) = upper(p_role_name)
546: and language = userenv('LANG');
547: END IF;
548:

Line 579: from igw_roles

575: BEGIN
576: x_return_status:= FND_API.G_RET_STS_SUCCESS;
577:
578: select count(*) into N
579: from igw_roles
580: where role_id = p_role_id AND
581: seeded_flag = 'Y';
582:
583: if (N <> 0) then