APPS.OZF_CHECK_DUP_PROD_PVT dependencies on DUAL

Line 71: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');

67: IF l_stmt_1 is not null then
68: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
69: FND_DSQL.add_text('SELECT TO_NUMBER(');
70: FND_DSQL.add_bind(p_attr_value);
71: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
72: ELSE
73: FND_DSQL.add_text(' ' || l_stmt_1);
74: END IF;
75:

Line 313: SELECT 'Y' FROM DUAL

309: l_stmt_product VARCHAR2(32000) := NULL;
310: l_duplicate_prod_exists VARCHAR2(1) := 'N';
311:
312: CURSOR c_duplicate_prod_exists IS
313: SELECT 'Y' FROM DUAL
314: WHERE EXISTS(
315: SELECT 1
316: FROM ozf_vo_products_temp
317: HAVING COUNT(product_id) > 1