DBA Data[Home] [Help]

APPS.ONT_FREIGHT_UTIL dependencies on QP_LIST_HEADER_PHASES

Line 203: --check if there is data qp_list_header_phases

199: close list_line_info1;
200: End If;
201:
202: /*************************************************
203: --check if there is data qp_list_header_phases
204: --if not this is a pricing bug
205: *************************************************/
206: DBMS_DEBUG('Checking for pricing bug');
207: Begin

Line 211: from qp_list_header_phases

207: Begin
208: Select list_header_id,
209: pricing_phase_id
210: Into l_list_header_id,l_pricing_phase_id
211: from qp_list_header_phases
212: where list_header_id = l_list_line_info.list_header_id;
213: Exception
214: when no_data_found Then
215: --check if it has line level qualifier