APPS.QP_BULK_LOADER_PUB dependencies on QP_PRC_CONTEXTS_B

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

184: set used_in_setup='Y'
185: where nvl(used_in_setup,'N')='N'
186: and segment_id in
187: (select a.segment_id
188: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h
189: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
190: and h.active_flag = 'Y'
191: and c.list_header_id = h.list_header_id
192: and a.segment_mapping_column = c.qualifier_attribute

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

198: set used_in_setup='Y'
199: where nvl(used_in_setup,'N')='N'
200: and segment_id in
201: (select a.segment_id
202: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
203: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
204: and h.active_flag = 'Y'
205: and c.list_header_id = h.list_header_id
206: and a.segment_mapping_column = c.pricing_attribute

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

212: set used_in_setup='Y'
213: where nvl(used_in_setup,'N')='N'
214: and segment_id in
215: (select a.segment_id
216: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
217: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
218: and h.active_flag = 'Y'
219: and c.list_header_id = h.list_header_id
220: and a.segment_mapping_column = c.product_attribute