APPS.AME_GPI_BUS dependencies on AME_CONFIG_VARS

Line 188: l_config_value ame_config_vars.variable_value%type;

184: ) IS
185: --
186: l_proc varchar2(72) := g_package || 'CHK_APPROVER_TYPE';
187: l_count number;
188: l_config_value ame_config_vars.variable_value%type;
189: l_application_id number;
190: --
191: -- cursor to find the transaction types using the approver group
192: --

Line 209: from ame_config_vars

205: -- current transaction type.
206: --
207: cursor C_Sel2 is
208: select variable_value
209: from ame_config_vars
210: where variable_name like 'allowAllApproverTypes'
211: and application_id = l_application_id
212: and sysdate between start_date and
213: nvl(end_date-ame_util.oneSecond,SYSDATE);

Line 252: from ame_config_vars

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