270: -- Cursor modified to improve performance.
271:
272: cursor valid_pos_grades is
273: select 1
274: from per_valid_grades vg
275: where vg.business_group_id = P_BUS_GRP_ID
276: and vg.position_id is not null;
277: --
278: -- Bug fix 3648612.
279: -- Cursor modified to improve performance.
280:
281: cursor valid_job_grades is
282: select 1
283: from per_valid_grades vg
284: where vg.business_group_id = P_BUS_GRP_ID
285: and vg.job_id is not null;
286: --
287: cursor get_pd_of_ser is