APPS.QP_BULK_LOADER_PUB dependencies on QP_SEGMENTS_B

Line 214: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h

210: set used_in_setup='Y'
211: where nvl(used_in_setup,'N')='N'
212: and segment_id in
213: (select a.segment_id
214: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h
215: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
216: and h.active_flag = 'Y'
217: and c.REQUEST_ID = child_req_rec.request_id --8418006
218: and c.list_header_id = h.list_header_id

Line 229: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h

225: set used_in_setup='Y'
226: where nvl(used_in_setup,'N')='N'
227: and segment_id in
228: (select a.segment_id
229: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
230: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
231: and h.active_flag = 'Y'
232: and c.REQUEST_ID = child_req_rec.request_id --8418006
233: and c.list_header_id = h.list_header_id

Line 244: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h

240: set used_in_setup='Y'
241: where nvl(used_in_setup,'N')='N'
242: and segment_id in
243: (select a.segment_id
244: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
245: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
246: and h.active_flag = 'Y'
247: and c.REQUEST_ID = child_req_rec.request_id --8418006
248: and c.list_header_id = h.list_header_id