APPS.PO_WF_PO_PRICAT_UPDATE dependencies on DUAL

Line 182: select 'COMPLETE:N' into result from sys.dual

178:
179: result := 'COMPLETE:Y';
180:
181: begin
182: select 'COMPLETE:N' into result from sys.dual
183: where exists ( select 'un_processed_items_exist'
184: from PO_LINES_INTERFACE
185: where interface_header_id = x_interface_header_id
186: and NVL(process_code, 'PENDING') = 'NOTIFIED'

Line 220: select 'COMPLETE:Y' into result from sys.dual

216:
217: result := 'COMPLETE:N';
218:
219: begin
220: select 'COMPLETE:Y' into result from sys.dual
221: where exists ( select 'items_were_rejected'
222: from PO_LINES_INTERFACE
223: where interface_header_id = x_interface_header_id
224: and NVL(process_code, 'PENDING') = 'NOTIFIED'