APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on ENI_DENORM_HRCHY_PARENTS

Line 842: select category_parent_id from eni_denorm_hrchy_parents

838: ((b.operator = 'IS_NOT_NULL' AND asll.CATEGORY_ID IS NOT NULL) OR
839: (b.operator = 'EQUALS' AND TO_NUMBER(C.attribute_value) IN
840: (select category_id from eni_prod_den_hrchy_parents_v
841: where category_id in (
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)