APPS.OZF_UTILITY_PVT dependencies on DUAL

Line 217: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

213: l_count NUMBER;
214: l_bind_tbl col_val_tbl;
215:
216: BEGIN
217: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
218: l_sql := l_sql || ' WHERE ' || UPPER(p_pk_name) || ' = :b1';
219:
220: IF p_additional_where_clause IS NOT NULL THEN
221:

Line 311: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;

307: , p_lookup_code => p_lookup_code
308: , p_view_application_id => 682
309: );
310: ELSE
311: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;
312: l_sql := l_sql || ' WHERE LOOKUP_TYPE = :b1';
313: l_sql := l_sql || ' AND LOOKUP_CODE = :b2';
314: l_sql := l_sql || ' AND ENABLED_FLAG = ''Y'')';
315:

Line 412: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

408: l_bind_tbl col_val_tbl;
409:
410: BEGIN
411:
412: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
413: -- l_sql := l_sql || ' WHERE ' || p_where_clause;
414:
415: bind_parse (p_where_clause, l_bind_tbl);
416:

Line 597: FROM DUAL;

593:
594: CURSOR c_log_seq IS
595: SELECT ams_act_logs_s.NEXTVAL,
596: ams_act_logs_transaction_id_s.NEXTVAL
597: FROM DUAL;
598:
599: CURSOR c_log(l_my_log_id VARCHAR2) IS
600: SELECT rowid
601: FROM ams_act_logs

Line 2956: SELECT 1 FROM DUAL

2952: )
2953: RETURN VARCHAR2
2954: IS
2955: CURSOR c_stat_det IS
2956: SELECT 1 FROM DUAL
2957: WHERE EXISTS (SELECT * FROM ams_status_order_rules
2958: WHERE current_status_code = p_current_status
2959: AND next_status_code = p_next_status
2960: AND system_status_type = p_status_type ) ;