DBA Data[Home] [Help]

APPS.IGW_PROP_USERS_PVT dependencies on IGW_ROLES

Line 534: and role_id in (select role_id from igw_roles where seeded_flag = 'Y');

530: select count(*) into N
531: from igw_prop_user_roles
532: where proposal_id = p_proposal_id
533: and user_id = p_user_id
534: and role_id in (select role_id from igw_roles where seeded_flag = 'Y');
535:
536:
537: if (N <> 0) then
538: x_return_status:= FND_API.G_RET_STS_ERROR;