APPS.OE_PC_VTMPLTS_PKG dependencies on DUAL

Line 47: FROM sys.dual;

43: CURSOR CROWID IS SELECT rowid FROM oe_pc_vtmplts
44: WHERE validation_tmplt_id = x_validation_tmplt_id;
45:
46: CURSOR CID IS SELECT oe_pc_vtmplts_s.nextval
47: FROM sys.dual;
48: Begin
49:
50: IF x_validation_tmplt_id IS NULL THEN
51: Open CID;

Line 513: FROM dual

509: dummy number;
510: Begin
511: SELECT 1
512: into dummy
513: FROM dual
514: WHERE NOT EXISTS
515: (SELECT 1
516: FROM oe_pc_conditions
517: WHERE validation_tmplt_id = x_validation_tmplt_id);