DBA Data[Home] [Help]

APPS.AME_STV_BUS dependencies on AME_ATTRIBUTES

Line 45: ,ame_attributes ameatr

41: --
42: cursor csr_name is
43: select amecon.condition_id, ameatr.attribute_type
44: from ame_conditions amecon
45: ,ame_attributes ameatr
46: where amecon.condition_id = p_condition_id
47: and amecon.attribute_id = ameatr.attribute_id
48: and p_effective_date between amecon.start_date and
49: nvl(amecon.end_date - ame_util.oneSecond, p_effective_date)