DBA Data[Home] [Help]

APPS.AME_UTILITY_PKG dependencies on AME_MANDATORY_ATTRIBUTES

Line 768: ame_mandatory_attributes man

764:
765: cursor action_types_cursor(l_attribute_id number)is
766: select act.name
767: from ame_action_types act,
768: ame_mandatory_attributes man
769: where Man.action_type_id = Act.action_type_id
770: and sysdate between act.start_date and nvl(act.end_date,sysdate)
771: and sysdate between man.start_date and nvl(man.end_date,sysdate)
772: and man.attribute_id = l_attribute_id

Line 808: ame_mandatory_attributes man

804:
805: cursor category_cursor(l_attribute_id number)is
806: select man.action_type_id
807: from ame_attributes atr,
808: ame_mandatory_attributes man
809: where atr.attribute_id = man.attribute_id
810: and atr.attribute_id = l_attribute_id
811: and sysdate between atr.start_date and nvl(atr.end_date-(1/84600),sysdate)
812: and sysdate between man.start_date and nvl(man.end_date-(1/84600),sysdate);