APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_LIMITS

Line 953: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c

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
954: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
955: and a.segment_mapping_column = c.multival_attribute1
956: and a.prc_context_id = b.prc_context_id
957: and b.prc_context_type = c.multival_attr1_type

Line 964: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c

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
965: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
966: and a.segment_mapping_column = c.multival_attribute2
967: and a.prc_context_id = b.prc_context_id
968: and b.prc_context_type = c.multival_attr2_type

Line 976: from qp_segments_b a,qp_prc_contexts_b b,qp_limit_attributes c,qp_limits d

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
977: where c.limit_id = d.limit_id
978: and d.list_header_id = p_MODIFIER_LIST_rec.list_header_id
979: and a.segment_mapping_column = c.limit_attribute
980: and a.prc_context_id = b.prc_context_id