APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_PTE_SEGMENTS

Line 914: update qp_pte_segments set used_in_setup='Y'

910: where list_header_id = p_MODIFIER_LIST_rec.list_header_id;
911:
912: IF p_MODIFIER_LIST_rec.active_flag = 'Y'
913: THEN
914: update qp_pte_segments set used_in_setup='Y'
915: where nvl(used_in_setup,'N')='N'
916: and segment_id in
917: (select a.segment_id
918: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c

Line 925: update qp_pte_segments d set used_in_setup='Y'

921: and a.prc_context_id = b.prc_context_id
922: and b.prc_context_type = 'QUALIFIER'
923: and b.prc_context_code = c.qualifier_context);
924:
925: update qp_pte_segments d set used_in_setup='Y'
926: where nvl(used_in_setup,'N')='N'
927: and exists
928: (select 'x'
929: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

Line 937: update qp_pte_segments d set used_in_setup='Y'

933: and a.prc_context_id = b.prc_context_id
934: and b.prc_context_type = 'PRICING_ATTRIBUTE'
935: and b.prc_context_code = c.pricing_attribute_context);
936:
937: update qp_pte_segments d set used_in_setup='Y'
938: where nvl(used_in_setup,'N')='N'
939: and exists
940: (select 'x'
941: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

Line 949: update qp_pte_segments set used_in_setup='Y'

945: and a.prc_context_id = b.prc_context_id
946: and b.prc_context_type = 'PRODUCT'
947: and b.prc_context_code = c.product_attribute_context);
948:
949: update qp_pte_segments set used_in_setup='Y'
950: where nvl(used_in_setup,'N')='N'
951: and segment_id in
952: (select a.segment_id
953: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c

Line 960: update qp_pte_segments set used_in_setup='Y'

956: and a.prc_context_id = b.prc_context_id
957: and b.prc_context_type = c.multival_attr1_type
958: and b.prc_context_code = c.multival_attr1_context);
959:
960: update qp_pte_segments set used_in_setup='Y'
961: where nvl(used_in_setup,'N')='N'
962: and segment_id in
963: (select a.segment_id
964: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c

Line 972: update qp_pte_segments set used_in_setup='Y'

968: and b.prc_context_type = c.multival_attr2_type
969: and b.prc_context_code = c.multival_attr2_context);
970:
971:
972: update qp_pte_segments set used_in_setup='Y'
973: where nvl(used_in_setup,'N')='N'
974: and segment_id in
975: (select a.segment_id
976: from qp_segments_b a,qp_prc_contexts_b b,qp_limit_attributes c,qp_limits d