APPS.INL_INTERFACE_PVT dependencies on DUAL

Line 8514: FROM dual;

8510: WHEN NO_DATA_FOUND THEN
8511: -- Create a Line Group record
8512: SELECT inl_ship_line_groups_s.NEXTVAL
8513: INTO current_SLnGr_rec.ship_line_group_id
8514: FROM dual;
8515: SELECT MAX(ship_line_group_num)
8516: INTO current_SLnGr_rec.ship_line_group_num
8517: FROM inl_ship_line_groups
8518: WHERE ship_header_id = x_ship_ln_int_rec.ship_header_id;

Line 8937: FROM dual;

8933: p_debug_info => l_debug_info) ;
8934: -- Get the next Shipment Line Id
8935: SELECT inl_ship_Lines_all_s.NEXTVAL
8936: INTO x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_id
8937: FROM dual;
8938:
8939: INL_LOGGING_PVT.Log_Variable(
8940: p_module_name => g_module_name,
8941: p_procedure_name => l_program_name,

Line 10615: FROM dual; -- BUG#8411723 => MURALI

10611: RAISE L_FND_EXC_UNEXPECTED_ERROR;
10612: ELSE
10613: SELECT inl_match_Amounts_s.NEXTVAL
10614: INTO matchAmountsToProcess_List(iMatch).new_match_Amount_id
10615: FROM dual; -- BUG#8411723 => MURALI
10616:
10617: INL_LOGGING_PVT.Log_Variable(
10618: p_module_name => g_module_name,
10619: p_procedure_name => l_program_name,

Line 10770: FROM dual; -- BUG#8411723 => MURALI

10766: RAISE L_FND_EXC_UNEXPECTED_ERROR;
10767: ELSE
10768: SELECT inl_matches_s.NEXTVAL
10769: INTO matchesToProcess_List(iMatch).new_match_id
10770: FROM dual; -- BUG#8411723 => MURALI
10771:
10772: INSERT INTO inl_matches(
10773: match_id , /* 01 */
10774: adj_group_date , /* 01A*/ --OPM Integration