APPS.OZF_OFFER_PUB dependencies on AMS_ACT_PRODUCTS

Line 1943: FROM ams_act_products prod, ozf_xref_map map

1939:
1940: CURSOR c_lump_line(p_list_header_id IN NUMBER) IS
1941: SELECT NVL(map.xref_line_id_value,prod.activity_product_id) activity_product_id
1942: ,NVL(map.list_line_number,prod.attribute1) attribute1
1943: FROM ams_act_products prod, ozf_xref_map map
1944: WHERE act_product_used_by_id = p_list_header_id
1945: AND arc_act_product_used_by = 'OFFR'
1946: AND prod.activity_product_id = map.list_line_id(+);
1947: