DBA Data[Home] [Help]

APPS.PQH_WDT_BUS dependencies on PER_GRADES

Line 265: from per_grades a

261: --
262: --
263: cursor c1 is
264: select null
265: from per_grades a
266: where a.grade_id = p_grade_id;
267: --
268: Cursor c2 is
269: select budgeted_entity_cd

Line 314: -- check if grade_id value exists in per_grades table

310: --
311: End if;
312: **/
313: --
314: -- check if grade_id value exists in per_grades table
315: --
316: open c1;
317: --
318: fetch c1 into l_dummy;

Line 323: -- raise error as FK does not relate to PK in per_grades

319: if c1%notfound then
320: --
321: close c1;
322: --
323: -- raise error as FK does not relate to PK in per_grades
324: -- table.
325: --
326: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK6');
327: --