APPS.HZP_CUST_PKG dependencies on DUAL

Line 43: from dual

39: NULL;
40: /******************************************************************
41: select 1
42: into dummy
43: from dual
44: where not exists ( select 1
45: from hz_parties
46: where party_name = p_customer_name
47: and ( ( p_rowid is null ) or (rowid <> p_rowid))

Line 88: from dual

84: BEGIN
85:
86: select 1
87: into dummy
88: from dual
89: where not exists ( select 1
90: from hz_cust_accounts
91: where account_number = p_customer_number
92: and ( ( p_rowid is null ) or (rowid <> p_rowid))

Line 133: from dual

129: begin
130:
131: select 1
132: into dummy
133: from dual
134: where not exists ( select 1
135: from hz_parties
136: where party_number = p_party_number
137: and ( ( p_rowid is null ) or (rowid <> p_rowid))

Line 176: from dual

172: dummy number;
173: begin
174: select 1
175: into dummy
176: from dual
177: where not exists ( select 1
178: from hz_cust_accounts c
179: where c.orig_system_reference = p_orig_system_reference
180: and ( ( p_rowid is null ) or (c.rowid <> p_rowid)));