APPS.PO_DIFF_SUMMARY_PKG dependencies on DUAL

Line 897: FROM DUAL

893:
894: BEGIN
895: SELECT 'Y'
896: INTO l_any_lines_get_rejected
897: FROM DUAL
898: WHERE EXISTS
899: (SELECT 1
900: FROM po_lines_draft_all
901: WHERE draft_id = l_draft_id

Line 1190: FROM DUAL;

1186:
1187: BEGIN
1188: SELECT PO_WF_ITEMKEY_S.NEXTVAL
1189: INTO l_new_itemkey
1190: FROM DUAL;
1191:
1192: RETURN g_ITEMKEY_PREFIX || '#' || TO_CHAR(p_draft_id) || '#' ||
1193: TO_CHAR(l_new_itemkey);
1194:

Line 3017: FROM DUAL

3013: END IF;
3014:
3015: SELECT NVL(MAX(FND_API.G_TRUE), FND_API.G_FALSE)
3016: INTO l_has_record_to_accept
3017: FROM DUAL
3018: WHERE EXISTS
3019: ( SELECT 1
3020: FROM po_lines_draft_all
3021: WHERE draft_id = p_draft_id

Line 3543: FROM dual

3539: BEGIN
3540:
3541: SELECT 'Y'
3542: INTO l_any_line_accepted
3543: FROM dual
3544: WHERE EXISTS (SELECT 1
3545: FROM po_lines_draft_all
3546: WHERE draft_id = l_draft_id
3547: AND nvl(change_accepted_flag,'Y') = 'Y')