DBA Data[Home] [Help]

APPS.OZF_COPY_OFFER_PVT dependencies on AMS_ACT_PRODUCTS

Line 1648: FROM ams_act_products

1644: l_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;
1645:
1646: CURSOR c_act_products IS
1647: SELECT *
1648: FROM ams_act_products
1649: WHERE arc_act_product_used_by = 'OFFR'
1650: AND act_product_used_by_id = p_source_object_id;
1651: l_act_product_rec ams_actproduct_pvt.act_product_rec_type;
1652:

Line 1655: FROM ams_act_products

1651: l_act_product_rec ams_actproduct_pvt.act_product_rec_type;
1652:
1653: CURSOR c_excluded_products(l_act_prod_id NUMBER) IS
1654: SELECT *
1655: FROM ams_act_products
1656: WHERE arc_act_product_used_by = 'PROD'
1657: AND act_product_used_by_id = l_act_prod_id;
1658:
1659: CURSOR c_offer_lines IS