DBA Data[Home] [Help]

APPS.CN_RULEATTRIBUTE_PVT dependencies on DUAL

Line 740: FROM dual;

736: AND table_id IN (-11803,-16134);
737:
738: SELECT Nvl(p_RuleAttribute_rec.attribute_rule_id, cn_attribute_rules_s.NEXTVAL)
739: INTO l_attribute_rule_id
740: FROM dual;
741:
742: IF p_RuleAttribute_rec.data_flag IN ( 'O' , 'R') THEN
743: Check_Attr_types
744: (p_value_1 => p_RuleAttribute_rec.value_1,

Line 1661: x_from := ' dual ';

1657: l_ret := dbms_sql.execute(l_cursor_num);
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: x_select := ' 1 column_id , 2 column_name ';
1661: x_from := ' dual ';
1662: x_where := ' 1 = 2 ';
1663:
1664: END ;
1665: dbms_sql.close_cursor(l_cursor_num);

Line 1671: x_from := ' dual ';

1667: CLOSE c_get_valueset_id;
1668:
1669: ELSE
1670: x_select := ' 1 column_id , 2 column_name ';
1671: x_from := ' dual ';
1672: x_where := ' 1 = 2 ';
1673:
1674: END IF;
1675: