APPS.CSM_MULTI_MOBQRY_PKG dependencies on FND_FLEX_VALIDATION_TABLES

Line 98: l_where FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%type;

94: END PARSE_XML;
95:
96: function get_ff_where(p_set_id in NUMBER ) return varchar2
97: is
98: l_where FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%type;
99: begin
100: select ADDITIONAL_WHERE_CLAUSE into l_where
101: from FND_FLEX_VALIDATION_TABLES
102: where FLEX_VALUE_SET_ID=p_set_id;

Line 101: from FND_FLEX_VALIDATION_TABLES

97: is
98: l_where FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%type;
99: begin
100: select ADDITIONAL_WHERE_CLAUSE into l_where
101: from FND_FLEX_VALIDATION_TABLES
102: where FLEX_VALUE_SET_ID=p_set_id;
103: return l_where;
104: end get_ff_where;
105:

Line 162: INTO l_ff_sql,l_ff_where from FND_FLEX_VALIDATION_TABLES WHERE FLEX_VALUE_SET_ID=rec.ffvs;

158: l_do_loop:=true;
159: ELSIF rec.VALIDATION_TYPE = 'F' THEN
160:
161: select 'SELECT '||VALUE_COLUMN_NAME ||' as code,'||NVL(MEANING_COLUMN_NAME,VALUE_COLUMN_NAME)||' as meaning FROM '||APPLICATION_TABLE_NAME,ADDITIONAL_WHERE_CLAUSE
162: INTO l_ff_sql,l_ff_where from FND_FLEX_VALIDATION_TABLES WHERE FLEX_VALUE_SET_ID=rec.ffvs;
163:
164: OPEN c_cur FOR l_ff_sql||' '||replace(l_ff_where,fnd_global.local_chr(10),' ');
165: l_do_loop:=true;
166: END IF;