APPS.OZF_OFFER_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 3363: FROM ams_custom_setup_attr

3359: l_offers_rec modifier_list_rec_type := p_offer_rec;
3360:
3361: CURSOR cur_attr_avail_flag IS
3362: SELECT attr_available_flag
3363: FROM ams_custom_setup_attr
3364: WHERE custom_setup_id = p_offer_rec.custom_setup_id
3365: AND object_attribute = 'BREQ';
3366:
3367: CURSOR c_committed_amount IS

Line 9261: FROM ams_custom_setup_attr

9257: WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id;
9258:
9259: CURSOR c_budget_required IS
9260: SELECT attr_available_flag
9261: FROM ams_custom_setup_attr
9262: WHERE object_attribute = 'BREQ'
9263: AND custom_setup_id = p_modifier_list_rec.custom_setup_id;
9264:
9265: CURSOR c_prod_line IS

Line 12229: FROM ams_custom_setup_attr

12225: WHERE request_header_id=p_sdr_header_id;
12226:
12227: CURSOR cur_is_theme_appr_req(p_custom_setup_id NUMBER) IS
12228: SELECT attr_available_flag
12229: FROM ams_custom_setup_attr
12230: WHERE custom_setup_id = p_custom_setup_id
12231: AND object_attribute = 'TAPL';
12232:
12233: CURSOR cur_is_budget_appr_req(p_custom_setup_id NUMBER) IS

Line 12235: FROM ams_custom_setup_attr

12231: AND object_attribute = 'TAPL';
12232:
12233: CURSOR cur_is_budget_appr_req(p_custom_setup_id NUMBER) IS
12234: SELECT attr_available_flag
12235: FROM ams_custom_setup_attr
12236: WHERE custom_setup_id = p_custom_setup_id
12237: AND object_attribute = 'BAPL';
12238:
12239: CURSOR c_get_sdr_owner(p_sdr_header_id NUMBER) IS