APPS.CSI_COUNTER_PVT dependencies on DUAL

Line 98: sSQL := 'select ' || P_FORMULA_TEXT || ' from dual';

94: FUNCTION VALIDATE_FORMULA(p_formula_text VARCHAR2) RETURN BOOLEAN IS
95: iSQLCur number;
96: sSQL varchar2(2090);
97: BEGIN
98: sSQL := 'select ' || P_FORMULA_TEXT || ' from dual';
99: iSQLCur := DBMS_SQL.open_cursor;
100: dbms_sql.parse(iSQLCur,sSQL,2);
101: dbms_sql.close_cursor(iSQLCur);
102: return TRUE;

Line 1018: into l_counter_id from dual;

1014:
1015: -- Check and Generate Counter_value_id
1016: IF l_counter_id IS NULL OR l_counter_id = FND_API.G_MISS_NUM THEN
1017: select CSI_COUNTERS_B_S.nextval
1018: into l_counter_id from dual;
1019: END IF;
1020: -- counter name suffix counter id is created from template or if duplicate exist.
1021: if l_created_from_counter_tmpl_id is not null then
1022: l_name := l_name||'-'||l_counter_id;

Line 1038: INTO l_ctr_group_id FROM dual;

1034: l_counter_groups_rec.ASSOCIATION_TYPE := 'TRACKABLE';
1035: END IF;
1036:
1037: SELECT CS_COUNTER_GROUPS_S.nextval
1038: INTO l_ctr_group_id FROM dual;
1039:
1040: csi_Counter_template_pvt.create_counter_group
1041: (
1042: p_api_version => p_api_version