DBA Data[Home] [Help]

APPS.AME_APU_BUS dependencies on AME_APPROVER_TYPE_USAGES

Line 182: from ame_approver_type_usages

178: -- Verify if approver type id is valid (-1 = any approver type).
179: if(c_sel1%notfound) then
180: if(p_approver_type_id = ame_util.anyApproverType) then
181: select count(*) into l_temp_count
182: from ame_approver_type_usages
183: where
184: action_type_id = p_action_type_id and
185: p_effective_date between start_date and
186: nvl(end_date - ame_util.oneSecond, p_effective_date);