eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_BENFT_STATUS_CHANGE dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 1943: from pv_referrals_b a, pv_referred_products b, eni_prod_den_hrchy_parents_v c

1939: document_type in out nocopy varchar2) IS
1940:
1941: cursor lc_get_products (pc_entity_id number) is
1942: select c.CONCAT_CAT_PARENTAGE, b.amount || ' ' || a.currency_code amount
1943: from pv_referrals_b a, pv_referred_products b, eni_prod_den_hrchy_parents_v c
1944: where a.referral_id = pc_entity_id
1945: and a.referral_id = b.referral_id
1946: and b.product_category_set_id = c.category_set_id
1947: and b.product_category_id = c.category_id;

Line 1951: from pv_referrals_b a, pv_referred_products b, eni_prod_den_hrchy_parents_v c

1947: and b.product_category_id = c.category_id;
1948:
1949: cursor lc_max_products_length (pc_entity_id number) is
1950: select max(length(c.CONCAT_CAT_PARENTAGE)), max(length(to_char(b.amount) || ' ' || a.currency_code))
1951: from pv_referrals_b a, pv_referred_products b, eni_prod_den_hrchy_parents_v c
1952: where a.referral_id = pc_entity_id
1953: and a.referral_id = b.referral_id
1954: and b.product_category_set_id = c.category_set_id
1955: and b.product_category_id = c.category_id;