APPS.OE_OE_INLINE_ADDRESS dependencies on DUAL

Line 160: from dual;

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

Line 183: from dual;

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

Line 205: from dual;

201: if l_gen_contact_number = 'N' then
202:
203: select hz_contact_numbers_s.nextval
204: into l_org_contact_rec.contact_number
205: from dual;
206: end if;
207:
208: l_org_contact_rec.title:= p_contact_title;
209: l_org_contact_rec.created_by_module := G_CREATED_BY_MODULE;

Line 627: from dual;

623: l_contact_points_rec.created_by_module := G_CREATED_BY_MODULE;
624:
625: select hz_contact_points_s.nextval
626: into l_contact_points_rec.contact_point_id
627: from dual;
628:
629:
630: IF in_contact_point_type = 'EMAIL' then
631: l_email_rec.email_address := in_email;

Line 2506: from dual;

2502: select in_cont_last_name||
2503: DECODE(in_cont_first_name,NULL,NULL,', '||in_cont_first_name)||
2504: DECODE(in_cont_title,NULL,NULL,' '||in_cont_title)
2505: into out_cont_Name
2506: from dual;
2507:
2508: END IF; -- if contact information is passed
2509:
2510: END Add_Customer;