DBA Data[Home] [Help]

APPS.QP_DELAYED_REQUESTS_UTIL dependencies on DUAL

Line 1340: select 1 into l_dummy from dual where

1336: --corresponding to primary price list as qualifier for a secondary PL
1337: -- Replaced the count(*) with exists clause for performance fix of bug 2337578
1338:
1339: Begin
1340: select 1 into l_dummy from dual where
1341: exists ( Select 'Y'
1342: from qp_qualifiers
1343: where list_header_id = p_list_header_id
1344: and NOT (qualifier_context = 'MODLIST' AND

Line 1619: select 1 into l_dummy from dual where

1615:
1616: -- Replaced the count(*) with exists clause for performance fix of bug 2337578
1617:
1618: Begin
1619: select 1 into l_dummy from dual where
1620: exists ( Select 'Y'
1621: from qp_qualifiers
1622: where list_header_id = l_list_header_id
1623: and NOT (qualifier_context = 'MODLIST' AND

Line 2742: from dual

2738: ) (
2739: select line_cursor.pricing_phase_id,
2740: line_cursor.product_attribute,
2741: line_cursor.product_attr_value
2742: from dual
2743: where not exists (
2744: select 'Y' from qp_adv_mod_products
2745: where pricing_phase_id = line_cursor.pricing_phase_id
2746: and product_attribute = line_cursor.product_attribute