DBA Data[Home] [Help]

APPS.PNT_CONT_PKG dependencies on DUAL

Line 28: FROM dual

24: BEGIN
25:
26: SELECT 1
27: INTO dummy
28: FROM dual
29: WHERE NOT EXISTS ( SELECT 1
30: FROM pn_contacts_all c
31: WHERE c.last_name = x_last_name
32: AND c.first_name = x_first_name

Line 152: FROM dual;

148: END IF;
149:
150: SELECT pn_contacts_s.nextval
151: INTO x_contact_id
152: FROM dual;
153:
154: INSERT INTO pn_contacts_all
155: (
156: contact_id,