APPS.PA_LOOKUPS_PKG SQL Statements

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

Line: 14

	select 	1
	into    x_dummy
	from	sys.dual
	where 	not exists
			(select 1
			 from 	pa_lookups p
			 where  p.lookup_type = x_lookup_type
			 and   ((UPPER(p.lookup_code) = UPPER(x_lookup_code)) or
						 (UPPER(p.meaning) = UPPER(x_meaning)))
			 );

Line: 51

	    	select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_credit_receivers cr
			 where cr.credit_type_code = x_lookup_code);

Line: 74

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_expenditure_types et
			 where et.unit_of_measure  = x_lookup_code);

Line: 95

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_bill_rates br
			 where br.bill_rate_unit  = x_lookup_code);

Line: 115

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_resources r
			 where r.unit_of_measure  = x_lookup_code);

Line: 135

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_emp_bill_rate_overrides eb
			 where eb.bill_rate_unit  = x_lookup_code);

Line: 155

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_job_bill_rate_overrides jb
			 where jb.bill_rate_unit  = x_lookup_code);

Line: 182

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_project_types pt
			 where pt.service_type_code  = x_lookup_code);

Line: 203

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_tasks t
			 where t.service_type_code  = x_lookup_code);

Line: 229

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_expenditure_types et
			 where et.revenue_category_code = x_lookup_code);

Line: 249

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_event_types et
			 where et.revenue_category_code = x_lookup_code);

Line: 269

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_resource_txn_attributes rt
			 where rt.revenue_category = x_lookup_code);

Line: 292

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_projects p
			 where p.project_status_code = x_lookup_code);

Line: 315

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_project_customers pc
			 where pc.project_relationship_code = x_lookup_code);

Line: 338

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_project_contacts pc
			 where pc.project_contact_type_code  = x_lookup_code);

Line: 362

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_budget_lines bl
			 where bl.change_reason_code  = x_lookup_code);

Line: 382

		select	1
	    	into    x_dummy
	    	from 	sys.dual
	    	where 	not exists
			(select 1
			 from pa_budget_versions bv
			 where bv.change_reason_code  = x_lookup_code);

Line: 405

              select 1 into x_dummy
              from sys.dual
              where not exists
                 (select 1 from pa_projects where pm_product_code
                  = x_lookup_code );

Line: 422

              select 1 into x_dummy
              from sys.dual
              where not exists
                 (select 1 from pa_budget_versions where pm_product_code
                  = x_lookup_code );