DBA Data[Home] [Help]

APPS.QP_ATTR_MAPPING_PUB dependencies on QP_LIMITS

Line 908: FROM qp_limits a, qp_list_headers_b b

904: BEGIN
905:
906: SELECT 'Y'
907: INTO v_is_used
908: FROM qp_limits a, qp_list_headers_b b
909: WHERE ((a.multival_attr1_context = l_context_name
910: AND a.multival_attribute1 = l_attribute_name)
911: OR (a.multival_attr2_context = l_context_name
912: AND a.multival_attribute2 = l_attribute_name))

Line 923: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c

919: BEGIN
920:
921: SELECT 'Y'
922: INTO v_is_used
923: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c
924: WHERE a.limit_attribute_context = l_context_name
925: AND a.limit_attribute = l_attribute_name
926: AND a.limit_id = b.limit_id
927: AND b.list_header_id = c.list_header_id

Line 1543: FROM qp_limits a, qp_list_headers_b b

1539: BEGIN
1540:
1541: SELECT 'Y'
1542: INTO v_is_used
1543: FROM qp_limits a, qp_list_headers_b b
1544: WHERE ((a.multival_attr1_context = l_context_name
1545: AND a.multival_attribute1 = l_attribute_name)
1546: OR (a.multival_attr2_context = l_context_name
1547: AND a.multival_attribute2 = l_attribute_name))

Line 1558: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c

1554: BEGIN
1555:
1556: SELECT 'Y'
1557: INTO v_is_used
1558: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c
1559: WHERE a.limit_attribute_context = l_context_name
1560: AND a.limit_attribute = l_attribute_name
1561: AND a.limit_id = b.limit_id
1562: AND b.list_header_id = c.list_header_id