APPS.PO_DRAFTS_PVT dependencies on DUAL

Line 202: FROM DUAL;

198: l_draft_id NUMBER;
199: BEGIN
200: SELECT PO_DRAFTS_S.nextval
201: INTO l_draft_id
202: FROM DUAL;
203:
204: RETURN l_draft_id;
205: END draft_id_nextval;
206:

Line 2241: FROM dual

2237: -- Do not call find_draft. Execute separate query.
2238: -- Exclude entries with draft_type = 'MOD'/'ARCHIVE'
2239: SELECT FND_API.G_TRUE
2240: INTO l_pending_changes_exist
2241: FROM dual
2242: WHERE EXISTS (SELECT 'Draft Exists'
2243: FROM po_drafts
2244: WHERE document_id = p_po_header_id
2245: AND status <> g_status_COMPLETED

Line 3939: FROM dual

3935: BEGIN
3936:
3937: SELECT 'Y'
3938: INTO l_mod_flag
3939: FROM dual
3940: WHERE EXISTS(SELECT 'mod enabled po'
3941: FROM po_doc_style_headers pdsh ,
3942: po_headers_all poh
3943: WHERE pdsh.style_id=poh.style_id

Line 3985: FROM dual

3981:
3982: BEGIN
3983: SELECT 'Y'
3984: INTO l_open_mod_exist_flag
3985: FROM dual
3986: WHERE EXISTS (SELECT 'Open Mod Exists'
3987: FROM po_drafts pod,
3988: po_headers_all poh
3989: WHERE pod.document_id = poh.po_header_id

Line 9241: dual

9237: SYSDATE,
9238: fnd_global.user_id,
9239: fnd_global.login_id
9240: FROM
9241: dual
9242: ) ;
9243:
9244:
9245: d_position := 10;

Line 9315: FROM dual

9311: fnd_global.user_id,
9312: SYSDATE,
9313: fnd_global.user_id,
9314: fnd_global.login_id
9315: FROM dual
9316: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details_draft exd
9317: WHERE exd.po_exhibit_details_id = po_exhibit_details_id_tbl(idx)
9318: )
9319: );

Line 9363: FROM dual

9359:
9360: BEGIN
9361: SELECT 'Y'
9362: INTO l_par_exist_flag
9363: FROM dual
9364: WHERE EXISTS (SELECT 'PAR Exists'
9365: FROM po_drafts pod,
9366: po_headers_all poh
9367: WHERE pod.document_id = poh.po_header_id