11: x_return_status := 0;
12:
13: select 1
14: into x_dummy 15: from sys.dual 16: where not exists
17: (select 1
18: from pa_lookups p
19: where p.lookup_type like 'COST BASE TYPE'
Line 48: from sys.dual
44:
45: begin
46: select 1
47: into x_dummy 48: from sys.dual 49: where not exists
50: (select 1
51: from pa_cost_bases cb
52: where cb.cost_base_type = x_lookup_code);