37: CURSOR CROWID IS SELECT rowid FROM oe_pc_rsets
38: WHERE record_set_id = x_record_set_id;
39:
40: CURSOR CID IS SELECT oe_pc_rsets_s.nextval 41: FROM sys.dual; 42: Begin
43:
44: IF x_record_set_id IS NULL THEN
45: Open CID;
Line 456: FROM dual
452: dummy number;
453: Begin
454: SELECT 1
455: into dummy 456: FROM dual 457: WHERE NOT EXISTS
458: (SELECT 1
459: FROM oe_pc_conditions
460: WHERE record_set_id = x_record_set_id);