60: begin
61:
62: status := 0;
63:
64: -- check pa_ind_rate_sch_revisions table
65:
66: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
67: (SELECT 1 FROM pa_ind_rate_sch_revisions irsr
68: WHERE irsr.cost_plus_structure = cp_structure);
63:
64: -- check pa_ind_rate_sch_revisions table
65:
66: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
67: (SELECT 1 FROM pa_ind_rate_sch_revisions irsr
68: WHERE irsr.cost_plus_structure = cp_structure);
69:
70: exception
71: