APPS.AME_APPROVER_GROUP_API dependencies on WF_ROLES

Line 111: if r2.param_name = 'wf_roles_name' then

107: l_orig_system := null;
108: l_orig_system_id := null;
109: l_query_string := null;
110:
111: if r2.param_name = 'wf_roles_name' then
112: begin
113: select orig_system, orig_system_id
114: into l_orig_system, l_orig_system_id
115: from wf_roles

Line 115: from wf_roles

111: if r2.param_name = 'wf_roles_name' then
112: begin
113: select orig_system, orig_system_id
114: into l_orig_system, l_orig_system_id
115: from wf_roles
116: where name = r2.param
117: and status = 'ACTIVE'
118: and (expiration_date is null or
119: sysdate < expiration_date)

Line 127: and parameter_name = 'wf_roles_name'

123: select orig_system, orig_system_id
124: into l_orig_system, l_orig_system_id
125: from ame_approval_group_members
126: where approval_group_id = hr_api.g_number
127: and parameter_name = 'wf_roles_name'
128: and parameter =r2.param
129: and rownum <2;
130: end;
131: else