APPS.AHL_UTILITY_PVT dependencies on DUAL

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

117: l_sql VARCHAR2(4000);
118: l_count NUMBER;
119:
120: BEGIN
121: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
122: l_sql := l_sql || ' WHERE ' || UPPER(p_pk_name) || ' = :b1';
123:
124: IF p_additional_where_clause IS NOT NULL THEN
125: -- given time, incorporate bind_parse

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

164: l_count NUMBER;
165:
166: BEGIN
167:
168: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;
169: l_sql := l_sql || ' WHERE LOOKUP_TYPE = :b1';
170: l_sql := l_sql || ' AND LOOKUP_CODE = :b2';
171: l_sql := l_sql || ' AND ENABLED_FLAG = ''Y'')';
172:

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

211: l_bind_tbl col_val_tbl;
212:
213: BEGIN
214:
215: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
216: bind_parse (p_where_clause, l_bind_tbl);
217: --
218: -- Support up to 4 WHERE conditions for uniqueness. If
219: -- the number of conditions changes, then must also revise

Line 353: SELECT 1 FROM DUAL

349:
350: RETURN VARCHAR2
351: IS
352: CURSOR cur_usr_stat_det IS
353: SELECT 1 FROM DUAL
354: WHERE EXISTS (SELECT * FROM AHL_USER_STATUSES_VL
355: WHERE user_status_id = p_user_status_id
356: AND system_status_type = p_status_type
357: AND system_status_code = p_next_status

Line 395: SELECT 1 FROM DUAL

391: x_return_status OUT NOCOPY VARCHAR2)
392: IS
393: -- Cursor to check next status code is valid
394: CURSOR cur_stat_det IS
395: SELECT 1 FROM DUAL
396: WHERE EXISTS (SELECT * FROM AHL_STATUS_ORDER_RULES
397: WHERE system_status_type = p_status_type
398: AND current_status_code = p_current_status
399: AND next_status_code = p_next_status);