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'
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);