DBA Data[Home] [Help]

APPS.OZF_COPY_OFFER_PVT dependencies on AMS_ACT_PRODUCTS

Line 1680: FROM ams_act_products

1676: l_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;
1677:
1678: CURSOR c_act_products IS
1679: SELECT *
1680: FROM ams_act_products
1681: WHERE arc_act_product_used_by = 'OFFR'
1682: AND act_product_used_by_id = p_source_object_id;
1683: l_act_product_rec ams_actproduct_pvt.act_product_rec_type;
1684:

Line 1687: FROM ams_act_products

1683: l_act_product_rec ams_actproduct_pvt.act_product_rec_type;
1684:
1685: CURSOR c_excluded_products(l_act_prod_id NUMBER) IS
1686: SELECT *
1687: FROM ams_act_products
1688: WHERE arc_act_product_used_by = 'PROD'
1689: AND act_product_used_by_id = l_act_prod_id;
1690:
1691: CURSOR c_offer_lines IS