APPS.PO_CLM_DOCUMENT_CONTROL_PVT dependencies on DUAL

Line 146: AND closeout_doc_type = po_closeout_pvt.g_CLOSEOUT_TYPE_INDIVIDUAL;

142: last_update_date = SYSDATE,
143: last_updated_by = FND_GLOBAL.USER_ID,
144: last_update_login = FND_GLOBAL.LOGIN_ID
145: WHERE reference_doc_id = p_doc_header_id
146: AND closeout_doc_type = po_closeout_pvt.g_CLOSEOUT_TYPE_INDIVIDUAL;
147:
148: d_pos := 30;
149:
150: --unfreeze the document

Line 278: FROM dual

274: THEN
275: BEGIN
276: SELECT 'Y'
277: INTO l_open_mod_exists_flag
278: FROM dual
279: WHERE EXISTS (SELECT 'open mod exists'
280: FROM po_drafts
281: WHERE document_id = p_doc_header_id
282: AND status NOT IN ('COMPLETED', 'WITHDRAWN')

Line 307: FROM dual

303: THEN
304: BEGIN
305: SELECT 'Y'
306: INTO l_open_award_exists_flag
307: FROM dual
308: WHERE EXISTS (SELECT 'open reference exists at header level'
309: FROM po_headers_all
310: WHERE clm_source_document_id = p_doc_header_id
311: AND NVL(frozen_flag,'N') = 'N'