APPS.AME_GPI_BUS dependencies on AME_CONFIG_VARS

Line 182: l_config_value ame_config_vars.variable_value%type;

178: ) IS
179: --
180: l_proc varchar2(72) := g_package || 'CHK_APPROVER_TYPE';
181: l_count number;
182: l_config_value ame_config_vars.variable_value%type;
183: l_application_id number;
184: --
185: -- cursor to find the transaction types using the approver group
186: --

Line 203: from ame_config_vars

199: -- current transaction type.
200: --
201: cursor C_Sel2 is
202: select variable_value
203: from ame_config_vars
204: where variable_name like 'allowAllApproverTypes'
205: and application_id = l_application_id
206: and sysdate between start_date and
207: nvl(end_date-ame_util.oneSecond,SYSDATE);

Line 246: from ame_config_vars

242: if C_Sel2%notfound then
243: -- if the config variable is not defined for the current transaction type
244: -- use the global value
245: select variable_value into l_config_value
246: from ame_config_vars
247: where variable_name like 'allowAllApproverTypes'
248: and application_id = 0
249: and sysdate between start_date and
250: nvl(end_date-ame_util.oneSecond,SYSDATE);