APPS.QP_LIMIT_ATTRS_UTIL dependencies on QP_PRC_CONTEXTS_B

Line 870: FROM qp_segments_b a,qp_prc_contexts_b b

866: UPDATE qp_pte_segments SET used_in_setup='Y'
867: WHERE nvl(used_in_setup,'N')='N'
868: AND segment_id IN
869: (SELECT a.segment_id
870: FROM qp_segments_b a,qp_prc_contexts_b b
871: WHERE a.segment_mapping_column=p_LIMIT_ATTRS_rec.limit_attribute
872: AND a.prc_context_id=b.prc_context_id
873: AND b.prc_context_type = p_LIMIT_ATTRS_rec.limit_attribute_type
874: AND b.prc_context_code=p_LIMIT_ATTRS_rec.limit_attribute_context);

Line 989: FROM qp_segments_b a,qp_prc_contexts_b b

985: UPDATE qp_pte_segments SET used_in_setup='Y'
986: WHERE nvl(used_in_setup,'N')='N'
987: AND segment_id IN
988: (SELECT a.segment_id
989: FROM qp_segments_b a,qp_prc_contexts_b b
990: WHERE a.segment_mapping_column=p_LIMIT_ATTRS_rec.limit_attribute
991: AND a.prc_context_id=b.prc_context_id
992: AND b.prc_context_type = p_LIMIT_ATTRS_rec.limit_attribute_type
993: AND b.prc_context_code=p_LIMIT_ATTRS_rec.limit_attribute_context);