APPS.FTE_PROCESS_REQUESTS dependencies on DUAL

Line 564: FROM dual;

560: l_return_message VARCHAR2(2000);
561:
562: CURSOR get_session_id IS
563: SELECT mrp_atp_schedule_temp_s.nextVal
564: FROM dual;
565:
566: CURSOR get_ship_method_meaning(p_ship_method_code VARCHAR2) IS
567: SELECT ship_method_meaning
568: FROM wsh_carrier_services

Line 855: l_result_tab instead of 8 individual result tables,

851: END IF;
852:
853: /* R12 Glog Integration
854: format_cs_call's signature is changed in R12 to return
855: l_result_tab instead of 8 individual result tables,
856: and the subsequent flow is based on the new return type
857: so need to convert
858:
859: 1) output parameters l_result_consolidation_id_tab,