APPS.OZF_UTILITY_PVT dependencies on DUAL

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

196: l_count NUMBER;
197: l_bind_tbl col_val_tbl;
198:
199: BEGIN
200: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
201: l_sql := l_sql || ' WHERE ' || UPPER(p_pk_name) || ' = :b1';
202:
203: IF p_additional_where_clause IS NOT NULL THEN
204:

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

290: , p_lookup_code => p_lookup_code
291: , p_view_application_id => 682
292: );
293: ELSE
294: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;
295: l_sql := l_sql || ' WHERE LOOKUP_TYPE = :b1';
296: l_sql := l_sql || ' AND LOOKUP_CODE = :b2';
297: l_sql := l_sql || ' AND ENABLED_FLAG = ''Y'')';
298:

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

391: l_bind_tbl col_val_tbl;
392:
393: BEGIN
394:
395: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
396: -- l_sql := l_sql || ' WHERE ' || p_where_clause;
397:
398: bind_parse (p_where_clause, l_bind_tbl);
399:

Line 580: FROM DUAL;

576:
577: CURSOR c_log_seq IS
578: SELECT ams_act_logs_s.NEXTVAL,
579: ams_act_logs_transaction_id_s.NEXTVAL
580: FROM DUAL;
581:
582: CURSOR c_log(l_my_log_id VARCHAR2) IS
583: SELECT rowid
584: FROM ams_act_logs

Line 2934: SELECT 1 FROM DUAL

2930: )
2931: RETURN VARCHAR2
2932: IS
2933: CURSOR c_stat_det IS
2934: SELECT 1 FROM DUAL
2935: WHERE EXISTS (SELECT * FROM ams_status_order_rules
2936: WHERE current_status_code = p_current_status
2937: AND next_status_code = p_next_status
2938: AND system_status_type = p_status_type ) ;