DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on AMS_ACT_PRODUCTS

Line 2008: FROM ams_act_products

2004: l_inv_id_exists NUMBER := NULL;
2005:
2006: CURSOR c_act_prod_exists (p_activity_product_id IN NUMBER) IS
2007: SELECT 1
2008: FROM ams_act_products
2009: WHERE activity_product_id = p_activity_product_id;
2010:
2011: CURSOR c_act_prod_used_by_exists (p_prod_used_by IN NUMBER) IS
2012: SELECT 1

Line 2382: FROM ams_act_products

2378:
2379: CURSOR c_prod_elig_details (p_act_prod_id IN NUMBER) IS
2380: SELECT act_product_used_by_id, inventory_item_id, category_id, category_set_id,
2381: primary_product_flag, excluded_flag, object_version_number
2382: FROM ams_act_products
2383: WHERE activity_product_id = p_act_prod_id;
2384:
2385: BEGIN
2386:

Line 2514: FROM ams_act_products

2510: l_object_version NUMBER := NULL;
2511:
2512: CURSOR c_valid_act_prod_id IS
2513: SELECT object_version_number
2514: FROM ams_act_products
2515: WHERE activity_product_id = p_act_product_id;
2516:
2517: BEGIN
2518: