DBA Data[Home] [Help]

APPS.QP_DELAYED_REQUESTS_UTIL dependencies on DUAL

Line 1332: select 1 into l_dummy from dual where

1328: --corresponding to primary price list as qualifier for a secondary PL
1329: -- Replaced the count(*) with exists clause for performance fix of bug 2337578
1330:
1331: Begin
1332: select 1 into l_dummy from dual where
1333: exists ( Select 'Y'
1334: from qp_qualifiers
1335: where list_header_id = p_list_header_id
1336: and NOT (qualifier_context = 'MODLIST' AND

Line 1611: select 1 into l_dummy from dual where

1607:
1608: -- Replaced the count(*) with exists clause for performance fix of bug 2337578
1609:
1610: Begin
1611: select 1 into l_dummy from dual where
1612: exists ( Select 'Y'
1613: from qp_qualifiers
1614: where list_header_id = l_list_header_id
1615: and NOT (qualifier_context = 'MODLIST' AND

Line 2731: from dual

2727: ) (
2728: select line_cursor.pricing_phase_id,
2729: line_cursor.product_attribute,
2730: line_cursor.product_attr_value
2731: from dual
2732: where not exists (
2733: select 'Y' from qp_adv_mod_products
2734: where pricing_phase_id = line_cursor.pricing_phase_id
2735: and product_attribute = line_cursor.product_attribute