APPS.QA_CORE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

		select hardcoded_column
        	from qa_chars
        	where char_id = P_ID;

Line: 24

		select developer_name
        	from qa_chars
        	where char_id = E_ID;

Line: 31

		select result_column_name
        	from qa_plan_chars
       		where plan_id = pl_id
         	and char_id = ch_id;

Line: 89

   	select char_id into ID
   	from qa_chars
   	where upper(Name) = upper(ELEMENT_NAME);

Line: 111

        select plan_id into ID
   	from qa_plans
   	where Name = PLAN_NAME;

Line: 136

	select name into PLAN_NAME
   	from qa_plans
   	where plan_id = GIVEN_PLAN_ID;

Line: 165

    select mandatory_flag into result
    from qa_plan_chars
    where plan_id = GIVEN_PLAN_ID and char_id = ELEMENT_ID;

Line: 202

    select datatype into atype from qa_chars where char_id = ELEMENT_ID;

Line: 233

    select datatype into atype from qa_chars where name = ELEMENT_NAME;