APPS.AME_ATR_BUS dependencies on AME_APPROVER_TYPES

Line 22: -- ame_approver_types.approver_type_id.

18: -- Description:
19: -- Validates that the approver_type_id field can only be populated if attribute
20: -- type is ame_util.numberAttributeType
21: -- Validates that the approver_type_id if not null, is a foreign key to
22: -- ame_approver_types.approver_type_id.
23: --
24: -- Prerequisites:
25: -- None.
26: --

Line 58: from ame_approver_types

54: l_proc varchar2(72) := g_package||'chk_approver_type_id';
55: tempCount integer;
56: cursor c_sel1 is
57: select null
58: from ame_approver_types
59: where
60: approver_type_id = p_approver_type_id and
61: p_effective_date between start_date and
62: nvl(end_date - ame_util.oneSecond, p_effective_date) ;