APPS.PV_CHECK_MATCH_PUB dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 2380: ENI_PROD_DEN_HRCHY_PARENTS_V b

2376: -- ---------------------------------------------------------------------------
2377: CURSOR c IS
2378: SELECT a.parent_id attr_value
2379: FROM eni_prod_denorm_hrchy_v a,
2380: ENI_PROD_DEN_HRCHY_PARENTS_V b
2381: WHERE a.child_id = TO_NUMBER(p_attr_value) AND
2382: a.parent_id = b.category_id AND
2383: b.purchase_interest = 'Y' AND
2384: (b.disable_date IS NULL OR b.disable_date > SYSDATE);