APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_LIMITS

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

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
1064: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1065: and a.segment_mapping_column = c.multival_attribute1
1066: and a.prc_context_id = b.prc_context_id
1067: and b.prc_context_type = c.multival_attr1_type

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

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
1075: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1076: and a.segment_mapping_column = c.multival_attribute2
1077: and a.prc_context_id = b.prc_context_id
1078: and b.prc_context_type = c.multival_attr2_type

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

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
1087: where c.limit_id = d.limit_id
1088: and d.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1089: and a.segment_mapping_column = c.limit_attribute
1090: and a.prc_context_id = b.prc_context_id