APPS.OZF_BUDGETAPPROVAL_PVT dependencies on AMS_ACT_PRODUCTS

Line 831: FROM ams_act_products

827: 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
828: SELECT decode(level_type_code, 'PRODUCT', inventory_item_id, category_id)
829: ,excluded_flag
830: ,decode(level_type_code, 'PRODUCT', 'PRICING_ATTRIBUTE1', 'PRICING_ATTRIBUTE2') attribute
831: FROM ams_act_products
832: WHERE act_product_used_by_id = p_act_product_used_by_id
833: AND arc_act_product_used_by = p_arc_act_product_used_by
834: AND excluded_flag = p_excluded_flag;
835:

Line 1215: FROM ams_act_products

1211: 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
1212: SELECT decode(level_type_code, 'PRODUCT', inventory_item_id, category_id)
1213: , excluded_flag
1214: , decode(level_type_code, 'PRODUCT', 'PRICING_ATTRIBUTE1', 'PRICING_ATTRIBUTE2') attribute
1215: FROM ams_act_products
1216: WHERE act_product_used_by_id = p_act_product_used_by_id
1217: AND arc_act_product_used_by = p_arc_act_product_used_by
1218: AND excluded_flag = p_excluded_flag;
1219:

Line 1426: FROM ams_act_products

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

Line 1442: FROM ams_act_products

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