DBA Data[Home] [Help]

APPS.RCV_ROI_PREPROCESSOR dependencies on DUAL

Line 989: from dual where exists (select 'Errored RHI'

985:
986: begin
987: select 1
988: into l_count
989: from dual where exists (select 'Errored RHI'
990: from rcv_headers_interface
991: where asn_type in ('ASN','ASBN')
992: and processing_status_code = 'ERROR'
993: and header_interface_id = x_header_record.header_record.header_interface_id);

Line 1000: from dual

996:
997: begin
998: select 1
999: into l_count
1000: from dual
1001: where exists (select 'Errored RTIs'
1002: from rcv_transactions_interface
1003: where processing_status_code = 'ERROR'
1004: and header_interface_id = x_header_record.header_record.header_interface_id);

Line 1325: FROM DUAL;

1321: x_cascaded_table(p_parent_index).deliver_to_person_id deliver_to_person_id,
1322: x_cascaded_table(p_parent_index).deliver_to_location_id deliver_to_location_id,
1323: x_cascaded_table(p_parent_index).secondary_unit_of_measure secondary_unit_of_measure,
1324: x_cascaded_table(p_parent_index).secondary_uom_code secondary_uom_code
1325: FROM DUAL;
1326:
1327: x_parent_row get_parent_row_from_rt%ROWTYPE;
1328:
1329: PROCEDURE default_no_check(