DBA Data[Home] [Help]

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 1171: FROM DUAL;

1167:
1168: BEGIN
1169: SELECT PO_WF_ITEMKEY_S.NEXTVAL
1170: INTO l_new_itemkey
1171: FROM DUAL;
1172:
1173: RETURN g_ITEMKEY_PREFIX || '#' || TO_CHAR(p_draft_id) || '#' ||
1174: TO_CHAR(l_new_itemkey);
1175:

Line 2991: FROM DUAL

2987: END IF;
2988:
2989: SELECT NVL(MAX(FND_API.G_TRUE), FND_API.G_FALSE)
2990: INTO l_has_record_to_accept
2991: FROM DUAL
2992: WHERE EXISTS
2993: ( SELECT 1
2994: FROM po_lines_draft_all
2995: WHERE draft_id = p_draft_id