DBA Data[Home] [Help]

APPS.AME_UTILITY_PKG dependencies on DUAL

Line 1514: from sys.dual;

1510: from ame_rules;
1511: else
1512: select ame_rules_s.nextval
1513: into l_rule_id
1514: from sys.dual;
1515: end if;
1516: return l_rule_id;
1517: end get_rule_id;
1518:

Line 1529: from sys.dual;

1525: from ame_conditions;
1526: else
1527: select ame_conditions_s.nextval
1528: into l_condition_id
1529: from sys.dual;
1530: end if;
1531: return l_condition_id;
1532: end get_condition_id;
1533:

Line 1559: select ame_approver_types_s.nextval into nextSequence from dual;

1555: nextSequence integer;
1556: countOfIds integer;
1557: begin
1558: while true loop
1559: select ame_approver_types_s.nextval into nextSequence from dual;
1560: select count(*)
1561: into countOfIds
1562: from ame_approver_types
1563: where approver_type_id = nextSequence;