APPS.AME_UTILITY_PKG dependencies on AME_ATTRIBUTES

Line 500: from ame_attributes

496: ,(select name
497: ,attribute_id
498: ,attribute_type
499: ,approver_type_id
500: from ame_attributes
501: where p_effective_date between start_date
502: and nvl(end_date,p_effective_date)
503: ) attr
504: where cond.condition_id = p_condition_id

Line 807: from ame_attributes atr,

803: oth_category varchar2(25);
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)

Line 1422: ame_attributes atr

1418:
1419: select count(*)
1420: into temp_count
1421: from ame_item_class_usages itu,
1422: ame_attributes atr
1423: where itu.item_class_id = atr.item_class_id
1424: and itu.application_id = l_application_id
1425: and atr.attribute_id = l_attribute_id
1426: and sysdate between itu.start_date

Line 1443: from ame_attributes atr

1439: end if;
1440:
1441: select atr.approver_type_id
1442: into temp_count
1443: from ame_attributes atr
1444: where atr.attribute_id = l_attribute_id
1445: and sysdate between atr.start_date
1446: and nvl(atr.end_date - (1/86400), sysdate);
1447:

Line 1454: from ame_attributes atr,

1450: return(return_val);
1451: end if;
1452:
1453: select count(*) into temp_count
1454: from ame_attributes atr,
1455: ame_approver_types apt
1456: where atr.approver_type_id = apt.approver_type_id
1457: and atr.attribute_id = l_attribute_id
1458: and sysdate between atr.start_date