35: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
36: AND EXISTS (
37: SELECT format_type
38: FROM fnd_flex_value_sets VSET,
39: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
40: WHERE vset.flex_value_set_id = segments.user_valueset_id
41: AND segments.application_id = 661
42: AND pcontexts.prc_context_type <> 'QUALIFIER'
43: AND pcontexts.prc_context_code = lattr.context
181: AND
182: EXISTS(
183: SELECT format_type
184: FROM fnd_flex_value_sets VSET,
185: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
186: WHERE vset.flex_value_set_id = segments.user_valueset_id
187: AND segments.application_id = 661
188: AND pcontexts.prc_context_type <> 'QUALIFIER'
189: AND pcontexts.prc_context_code = lattr.context
220: AND
221: NOT EXISTS(
222: SELECT format_type
223: FROM fnd_flex_value_sets VSET,
224: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
225: WHERE vset.flex_value_set_id = segments.user_valueset_id
226: AND segments.application_id = 661
227: AND pcontexts.prc_context_type <> 'QUALIFIER'
228: AND pcontexts.prc_context_code = lattr.context