APPS.OZF_BUDGETAPPROVAL_PVT dependencies on AMS_ACT_PRODUCTS

Line 827: FROM ams_act_products

823: CURSOR c_get_products(p_act_product_used_by_id IN NUMBER, p_arc_act_product_used_by IN VARCHAR2, p_excluded_flag IN VARCHAR2) IS
824: SELECT decode(level_type_code, 'PRODUCT', inventory_item_id, category_id)
825: ,excluded_flag
826: ,decode(level_type_code, 'PRODUCT', 'PRICING_ATTRIBUTE1', 'PRICING_ATTRIBUTE2') attribute
827: FROM ams_act_products
828: WHERE act_product_used_by_id = p_act_product_used_by_id
829: AND arc_act_product_used_by = p_arc_act_product_used_by
830: AND excluded_flag = p_excluded_flag;
831:

Line 1211: FROM ams_act_products

1207: CURSOR c_get_products(p_act_product_used_by_id IN NUMBER, p_arc_act_product_used_by IN VARCHAR2, p_excluded_flag IN VARCHAR2) IS
1208: SELECT decode(level_type_code, 'PRODUCT', inventory_item_id, category_id)
1209: , excluded_flag
1210: , decode(level_type_code, 'PRODUCT', 'PRICING_ATTRIBUTE1', 'PRICING_ATTRIBUTE2') attribute
1211: FROM ams_act_products
1212: WHERE act_product_used_by_id = p_act_product_used_by_id
1213: AND arc_act_product_used_by = p_arc_act_product_used_by
1214: AND excluded_flag = p_excluded_flag;
1215:

Line 1422: FROM ams_act_products

1418: CURSOR c_get_budget_products(p_excluded_flag IN VARCHAR2) IS
1419: SELECT distinct decode(level_type_code, 'PRODUCT', inventory_item_id, category_id)
1420: ,excluded_flag
1421: ,decode(level_type_code, 'PRODUCT', 'PRICING_ATTRIBUTE1', 'PRICING_ATTRIBUTE2') attribute
1422: FROM ams_act_products
1423: WHERE act_product_used_by_id
1424: IN
1425: (SELECT budget_source_id FROM ozf_act_budgets
1426: WHERE arc_act_budget_used_by = 'OFFR'

Line 1438: FROM ams_act_products

1434: CURSOR c_get_offer_products IS
1435: SELECT decode(level_type_code, 'PRODUCT', inventory_item_id, category_id)
1436: ,excluded_flag
1437: ,decode(level_type_code, 'PRODUCT', 'PRICING_ATTRIBUTE1', 'PRICING_ATTRIBUTE2') attribute
1438: FROM ams_act_products
1439: WHERE act_product_used_by_id = p_object_id
1440: AND arc_act_product_used_by = 'OFFR'
1441: AND excluded_flag = 'N';
1442: BEGIN