APPS.AMS_ACTPRODUCT_PVT dependencies on AMS_OFFERS

Line 1151: FROM ams_offers

1147: and accrual_discount_level = 'ORDER' ;
1148:
1149: CURSOR c_offer_type IS
1150: SELECT OFFER_TYPE, custom_setup_id
1151: FROM ams_offers
1152: WHERE qp_list_header_id = p_act_Product_rec.act_product_used_by_id;
1153:
1154: l_budget_flag VARCHAR2(1);
1155: l_offer_type VARCHAR2(30);

Line 1804: FROM ams_offers

1800: l_count2 NUMBER := 0; -- count for item in category
1801:
1802: CURSOR c_offer_type(l_id NUMBER) IS
1803: SELECT offer_type
1804: FROM ams_offers
1805: WHERE qp_list_header_id = l_id;
1806: l_offer_type VARCHAR2(30);
1807:
1808: BEGIN