APPS.PNT_COMP_PKG dependencies on DUAL

Line 33: from dual

29: BEGIN
30:
31: select 1
32: into dummy
33: from dual
34: where not exists ( select 1
35: from pn_companies_all
36: where name = p_company_name
37: and (( p_rowid is null ) or (rowid <> p_rowid))

Line 78: FROM dual

74: BEGIN
75:
76: SELECT 1
77: INTO dummy
78: FROM dual
79: WHERE NOT EXISTS ( SELECT 1
80: FROM pn_companies_all
81: WHERE company_number = p_company_number
82: AND (( p_rowid is null ) or (rowid <> p_rowid))

Line 161: from dual;

157: -- Allocate the sequence to the primary key company_id
158: -----------------------------------------------------------------
159: select pn_companies_s.nextval
160: into x_company_id
161: from dual;
162:
163: IF x_company_number is null then
164:
165: select pn_companies_num_s.nextval

Line 167: from dual;

163: IF x_company_number is null then
164:
165: select pn_companies_num_s.nextval
166: into x_company_number
167: from dual;
168:
169: END IF;
170:
171: insert into pn_companies_all (