APPS.QA_PLANS_API SQL Statements

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

Line: 27

	SELECT *
	FROM qa_plans
	WHERE plan_id = p_id;

Line: 89

	SELECT plan_id
	FROM qa_plans
	WHERE name = plan_name;

Line: 111

        SELECT organization_id
        FROM mtl_parameters
        WHERE organization_code = upper(p_org_code);

Line: 115

	SELECT organization_id
	FROM org_organization_definitions
	WHERE organization_code = p_org_code;

Line: 139

 SELECT meaning
 FROM   fnd_lookup_values
 WHERE  lookup_type  = 'COLLECTION_PLAN_TYPE'
 AND    lookup_code = p_lookup_code
 AND    LANGUAGE = userenv('LANG');