DBA Data[Home] [Help]

APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on DUAL

Line 720: SELECT po_epls_evnt_s.NEXTVAL INTO l_event_key FROM dual;

716:
717: END IF;
718:
719:
720: SELECT po_epls_evnt_s.NEXTVAL INTO l_event_key FROM dual;
721: l_event_key:='EPLS'||l_event_key;
722: l_event_name := 'oracle.apps.po.integration.epls.post';
723: l_message := wf_event.test(l_event_name);
724:

Line 1126: SELECT 'N' FROM dual;

1122: AND draft_id = p_draft_id
1123: AND CHANGE_STATUS = 'NEW';
1124:
1125: CURSOR exists_pop_increase IS
1126: SELECT 'N' FROM dual;
1127:
1128: CURSOR c_not_par IS
1129: SELECT 'Y'
1130: FROM po_drafts