DBA Data[Home] [Help]

APPS.PON_PO_INTEGRATION_GRP dependencies on DUAL

Line 97: from dual

93: for l_idx in 1..p_in_rec.entity_ids.count loop
94: begin
95: select 1
96: into l_references
97: from dual
98: where exists (select 1
99: from pon_bid_headers
100: where po_header_id = p_in_rec.entity_ids(l_idx)
101: );

Line 111: from dual

107: if (l_references = 0) then
108: begin
109: select 1
110: into l_references
111: from dual
112: where exists ( select 1
113: from pon_auction_headers_all
114: where source_doc_msg in ('PO_POTYPE_BLKT', 'PO_POTYPE_CNTR')
115: and source_doc_id = p_in_rec.entity_ids(l_idx)

Line 149: from dual

145: for l_idx in 1..p_in_rec.entity_ids.count loop
146: begin
147: select 1
148: into l_references
149: from dual
150: where exists ( select 1
151: from pon_backing_requisitions
152: where requisition_header_id = p_in_rec.entity_ids(l_idx)
153: );