40: return;
41:
42: end;
43:
44: -- check against PA_PROJECTS_ALL
45: begin
46: select 1
47: into x_dummy
48: from sys.dual
47: into x_dummy
48: from sys.dual
49: where not exists
50: (select 1
51: from pa_projects_all p
52: where p.cost_ind_rate_sch_id = x_ind_rate_sch_id
53: or p.rev_ind_rate_sch_id = x_ind_rate_sch_id
54: or p.inv_ind_rate_sch_id = x_ind_rate_sch_id
55: or p.cint_rate_sch_id = x_ind_rate_sch_id); /* added for bug#3041364 */