APPS.QP_ATTR_MAPPING_PUB dependencies on QP_LIMITS

Line 975: FROM qp_limits a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769

971: BEGIN
972:
973: SELECT 'Y'
974: INTO v_is_used
975: FROM qp_limits a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769
976: WHERE ((a.multival_attr1_context = l_context_name
977: AND a.multival_attribute1 = l_attribute_name)
978: OR (a.multival_attr2_context = l_context_name
979: AND a.multival_attribute2 = l_attribute_name))

Line 990: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769

986: BEGIN
987:
988: SELECT 'Y'
989: INTO v_is_used
990: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769
991: WHERE a.limit_attribute_context = l_context_name
992: AND a.limit_attribute = l_attribute_name
993: AND a.limit_id = b.limit_id
994: AND b.list_header_id = c.list_header_id

Line 1610: FROM qp_limits a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769

1606: BEGIN
1607:
1608: SELECT 'Y'
1609: INTO v_is_used
1610: FROM qp_limits a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769
1611: WHERE ((a.multival_attr1_context = l_context_name
1612: AND a.multival_attribute1 = l_attribute_name)
1613: OR (a.multival_attr2_context = l_context_name
1614: AND a.multival_attribute2 = l_attribute_name))

Line 1625: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769

1621: BEGIN
1622:
1623: SELECT 'Y'
1624: INTO v_is_used
1625: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769
1626: WHERE a.limit_attribute_context = l_context_name
1627: AND a.limit_attribute = l_attribute_name
1628: AND a.limit_id = b.limit_id
1629: AND b.list_header_id = c.list_header_id