APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on DUAL
Line 846: select ASLL.CATEGORY_ID from dual)
842: select category_parent_id from eni_denorm_hrchy_parents
843: start with category_id = ASLL.CATEGORY_ID
844: connect by prior category_parent_id = category_id
845: union all 846: select ASLL.CATEGORY_ID from dual) 847: and disable_date is null and
848: purchase_interest = 'Y' )))
849:
850: