APPS.QP_BULK_LOADER_PUB dependencies on QP_PTE_SEGMENTS

Line 183: update qp_pte_segments

179: p_update_type => 'QUAL_IND'
180: );
181:
182: Begin
183: update qp_pte_segments
184: set used_in_setup='Y'
185: where nvl(used_in_setup,'N')='N'
186: and segment_id in
187: (select a.segment_id

Line 197: update qp_pte_segments

193: and a.prc_context_id = b.prc_context_id
194: and b.prc_context_type = 'QUALIFIER'
195: and b.prc_context_code = c.qualifier_context);
196:
197: update qp_pte_segments
198: set used_in_setup='Y'
199: where nvl(used_in_setup,'N')='N'
200: and segment_id in
201: (select a.segment_id

Line 211: update qp_pte_segments

207: and a.prc_context_id = b.prc_context_id
208: and b.prc_context_type = 'PRICING_ATTRIBUTE'
209: and b.prc_context_code = c.pricing_attribute_context);
210:
211: update qp_pte_segments
212: set used_in_setup='Y'
213: where nvl(used_in_setup,'N')='N'
214: and segment_id in
215: (select a.segment_id