APPS.QP_QUALIFIERS_UTIL dependencies on QP_PRC_CONTEXTS_B

Line 1178: FROM qp_segments_b a,qp_prc_contexts_b b

1174: UPDATE qp_pte_segments SET used_in_setup='Y'
1175: WHERE nvl(used_in_setup,'N')='N'
1176: AND segment_id IN
1177: (SELECT a.segment_id
1178: FROM qp_segments_b a,qp_prc_contexts_b b
1179: WHERE a.segment_mapping_column=p_QUALIFIERS_rec.qualifier_attribute
1180: AND a.prc_context_id=b.prc_context_id
1181: AND b.prc_context_type='QUALIFIER'
1182: AND b.prc_context_code=p_QUALIFIERS_rec.qualifier_context);

Line 1249: FROM qp_segments_b a,qp_prc_contexts_b b

1245:
1246:
1247: cursor update_pte_cur(l_qual_context varchar2,l_qual_attribute varchar2) is
1248: SELECT a.segment_id
1249: FROM qp_segments_b a,qp_prc_contexts_b b
1250: WHERE a.segment_mapping_column=l_qual_attribute
1251: AND a.prc_context_id=b.prc_context_id
1252: AND b.prc_context_type='QUALIFIER'
1253: AND b.prc_context_code=l_qual_context;

Line 1463: FROM qp_segments_b a,qp_prc_contexts_b b

1459: UPDATE qp_pte_segments SET used_in_setup='Y'
1460: WHERE nvl(used_in_setup,'N')='N'
1461: AND segment_id IN
1462: (SELECT a.segment_id
1463: FROM qp_segments_b a,qp_prc_contexts_b b
1464: WHERE a.segment_mapping_column=p_QUALIFIERS_rec.qualifier_attribute
1465: AND a.prc_context_id=b.prc_context_id AND b.prc_context_type='QUALIFIER'
1466: AND b.prc_context_code=p_QUALIFIERS_rec.qualifier_context);
1467: END IF;

Line 2003: FROM qp_segments_b a,qp_prc_contexts_b b

1999: UPDATE qp_pte_segments SET used_in_setup='N'
2000: WHERE
2001: segment_id IN
2002: (SELECT a.segment_id
2003: FROM qp_segments_b a,qp_prc_contexts_b b
2004: WHERE a.segment_mapping_column=l_qualifiers_rec.qualifier_attribute
2005: AND a.prc_context_id=b.prc_context_id
2006: AND b.prc_context_type='QUALIFIER'
2007: AND b.prc_context_code=l_qualifiers_rec.qualifier_context);