APPS.OE_OE_INLINE_ADDRESS dependencies on DUAL

Line 163: from dual;

159: -- from the sequence
160: if l_gen_party_number = 'N' then
161: select hz_party_number_s.nextval
162: into l_party_rec.party_number
163: from dual;
164: end if;
165:
166: l_person_rec.party_rec := l_party_rec;
167:

Line 186: from dual;

182:
183: if l_gen_party_number = 'N' then
184: select hz_party_number_s.nextval
185: into l_org_contact_rec.party_rel_rec.party_rec.party_number
186: from dual;
187: end if;
188:
189: l_org_contact_rec.party_rel_rec.subject_id := x_party_id;
190: l_org_contact_rec.party_rel_rec.object_id := p_party_id;

Line 209: from dual;

205: if l_gen_contact_number = 'N' then
206:
207: select hz_contact_numbers_s.nextval
208: into l_org_contact_rec.contact_number
209: from dual;
210: end if;
211:
212: l_org_contact_rec.title:= p_contact_title;
213: l_org_contact_rec.created_by_module := G_CREATED_BY_MODULE;

Line 645: from dual;

641: l_contact_points_rec.orig_system_reference := p_orig_system_reference; --ER7675548
642:
643: select hz_contact_points_s.nextval
644: into l_contact_points_rec.contact_point_id
645: from dual;
646:
647:
648: IF in_contact_point_type = 'EMAIL' then
649: l_email_rec.email_address := in_email;

Line 2550: from dual;

2546: select in_cont_last_name||
2547: DECODE(in_cont_first_name,NULL,NULL,', '||in_cont_first_name)||
2548: DECODE(in_cont_title,NULL,NULL,' '||in_cont_title)
2549: into out_cont_Name
2550: from dual;
2551:
2552: END IF; -- if contact information is passed
2553:
2554: END Add_Customer;