APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_PTE_SEGMENTS

Line 1024: update qp_pte_segments set used_in_setup='Y'

1020: where list_header_id = p_MODIFIER_LIST_rec.list_header_id;
1021:
1022: IF p_MODIFIER_LIST_rec.active_flag = 'Y'
1023: THEN
1024: update qp_pte_segments set used_in_setup='Y'
1025: where nvl(used_in_setup,'N')='N'
1026: and segment_id in
1027: (select a.segment_id
1028: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c

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

1031: and a.prc_context_id = b.prc_context_id
1032: and b.prc_context_type = 'QUALIFIER'
1033: and b.prc_context_code = c.qualifier_context);
1034:
1035: update qp_pte_segments d set used_in_setup='Y'
1036: where nvl(used_in_setup,'N')='N'
1037: and exists
1038: (select 'x'
1039: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

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

1043: and a.prc_context_id = b.prc_context_id
1044: and b.prc_context_type = 'PRICING_ATTRIBUTE'
1045: and b.prc_context_code = c.pricing_attribute_context);
1046:
1047: update qp_pte_segments d set used_in_setup='Y'
1048: where nvl(used_in_setup,'N')='N'
1049: and exists
1050: (select 'x'
1051: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

Line 1059: update qp_pte_segments set used_in_setup='Y'

1055: and a.prc_context_id = b.prc_context_id
1056: and b.prc_context_type = 'PRODUCT'
1057: and b.prc_context_code = c.product_attribute_context);
1058:
1059: update qp_pte_segments set used_in_setup='Y'
1060: where nvl(used_in_setup,'N')='N'
1061: and segment_id in
1062: (select a.segment_id
1063: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c

Line 1070: update qp_pte_segments set used_in_setup='Y'

1066: and a.prc_context_id = b.prc_context_id
1067: and b.prc_context_type = c.multival_attr1_type
1068: and b.prc_context_code = c.multival_attr1_context);
1069:
1070: update qp_pte_segments set used_in_setup='Y'
1071: where nvl(used_in_setup,'N')='N'
1072: and segment_id in
1073: (select a.segment_id
1074: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c

Line 1082: update qp_pte_segments set used_in_setup='Y'

1078: and b.prc_context_type = c.multival_attr2_type
1079: and b.prc_context_code = c.multival_attr2_context);
1080:
1081:
1082: update qp_pte_segments set used_in_setup='Y'
1083: where nvl(used_in_setup,'N')='N'
1084: and segment_id in
1085: (select a.segment_id
1086: from qp_segments_b a,qp_prc_contexts_b b,qp_limit_attributes c,qp_limits d