DBA Data[Home] [Help]

APPS.QA_VALIDATION_API dependencies on QA_PLANS

Line 3976: FROM qa_plans

3972: if hardcoded_char_tab.count <> 0 then
3973: -- Get the plan name to form the Dynamic Plan View Name
3974: SELECT deref_view_name
3975: INTO plan_name
3976: FROM qa_plans
3977: WHERE plan_id = p_plan_id;
3978:
3979: cols_str := RTRIM(cols_str, '||'',''||');
3980: char_ids_str := RTRIM(char_ids_str, ',');

Line 4272: from qa_plans

4268:
4269: l_sql_stmt := l_sql_stmt || 'CREATED_BY, COLLECTION_ID, LAST_UPDATE_DATE FROM ';
4270:
4271: select view_name into l_view_name
4272: from qa_plans
4273: where plan_id = p_plan_id;
4274:
4275: l_sql_stmt := l_sql_stmt || l_view_name;
4276: