APPS.PO_DRAFT_MERGE_PKG dependencies on DUAL

Line 162: from dual

158:
159: begin
160: select 'Y'
161: into l_header_attach_exist
162: from dual
163: where exists (select 'header attachments exist'
164: from fnd_attached_documents
165: where entity_name = 'PO_HEADERS'
166: and pk1_value = to_char(p_document_id) || '-' || to_char(p_draft_id));

Line 249: from dual

245:
246: BEGIN
247: select 'Y'
248: into l_mod_attach_exist
249: from dual
250: where exists (select 'attachments exist for mod'
251: from fnd_attached_documents
252: where pk1_value LIKE '%-'|| to_char(p_draft_id)
253: and entity_name in ('PO_HEADERS','PO_HEADERS_DEL','PO_LINES','PO_LINES_DEL','PO_SHIPMENTS','PO_SHIPMENTS_DEL'));

Line 263: FROM DUAL

259: BEGIN
260:
261: SELECT 'Y'
262: INTO l_attach_with_orig_attach_id
263: FROM DUAL
264: WHERE EXISTS (SELECT 'mod attachments exist with orig attach id not null'
265: FROM fnd_attached_documents
266: WHERE pk1_value LIKE '%-'|| to_char(p_draft_id)
267: AND entity_name in ('PO_HEADERS','PO_HEADERS_DEL','PO_LINES','PO_LINES_DEL','PO_SHIPMENTS','PO_SHIPMENTS_DEL')

Line 272: FROM DUAL

268: AND ORIG_ATTACH_DOC_ID IS NOT NULL);
269:
270: SELECT 'Y'
271: INTO l_attach_locks_exist
272: FROM DUAL
273: WHERE EXISTS (SELECT 'attachment locks exist'
274: FROM po_entity_locks
275: WHERE lock_by_draft_id = p_draft_id
276: AND entity_name IN ('PO_HEADERS_ATTACH','PO_LINES_ATTACH','PO_LINE_LOCATIONS_ATTACH'));