APPS.WF_PLUG dependencies on WF_ROLES

Line 704: from WF_ROLES WR

700: colon := instr(username, ':');
701: if (colon = 0) then
702: select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
703: into uorig_system, uorig_system_id
704: from WF_ROLES WR
705: where WR.NAME = username
706: and WR.ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
707: 'HZ_GROUP','CUST_CONT');
708: else

Line 711: from WF_ROLES WR

707: 'HZ_GROUP','CUST_CONT');
708: else
709: select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
710: into uorig_system, uorig_system_id
711: from WF_ROLES WR
712: where WR.ORIG_SYSTEM = substr(username, 1, colon-1)
713: and WR.ORIG_SYSTEM_ID = substr(username, colon+1)
714: and WR.NAME = username;
715: end if;