1580: -- AND p_effective_date BETWEEN pcl.effective_start_date AND
1581: -- pcl.effective_end_date)
1582: UNION
1583: SELECT 0
1584: FROM DUAL;
1585: --
1586: -- Fix for bug 2491566
1587: --
1588: --WHERE NOT EXISTS (SELECT 'X'
1610: -- AND p_effective_date BETWEEN pcl.effective_start_date
1611: -- AND pcl.effective_end_date)
1612: UNION
1613: SELECT 0
1614: FROM DUAL;
1615: --
1616: -- Fix for bug 2491566
1617: --
1618: --WHERE NOT EXISTS (SELECT 'X'