APPS.OZF_OFFER_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 3198: FROM ams_custom_setup_attr

3194: l_offers_rec modifier_list_rec_type := p_offer_rec;
3195:
3196: CURSOR cur_attr_avail_flag IS
3197: SELECT attr_available_flag
3198: FROM ams_custom_setup_attr
3199: WHERE custom_setup_id = p_offer_rec.custom_setup_id
3200: AND object_attribute = 'BREQ';
3201:
3202: CURSOR c_committed_amount IS

Line 8722: FROM ams_custom_setup_attr

8718: WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id;
8719:
8720: CURSOR c_budget_required IS
8721: SELECT attr_available_flag
8722: FROM ams_custom_setup_attr
8723: WHERE object_attribute = 'BREQ'
8724: AND custom_setup_id = p_modifier_list_rec.custom_setup_id;
8725:
8726: CURSOR c_prod_line IS

Line 11421: FROM ams_custom_setup_attr

11417: WHERE request_header_id=p_sdr_header_id;
11418:
11419: CURSOR cur_is_theme_appr_req(p_custom_setup_id NUMBER) IS
11420: SELECT attr_available_flag
11421: FROM ams_custom_setup_attr
11422: WHERE custom_setup_id = p_custom_setup_id
11423: AND object_attribute = 'TAPL';
11424:
11425: CURSOR cur_is_budget_appr_req(p_custom_setup_id NUMBER) IS

Line 11427: FROM ams_custom_setup_attr

11423: AND object_attribute = 'TAPL';
11424:
11425: CURSOR cur_is_budget_appr_req(p_custom_setup_id NUMBER) IS
11426: SELECT attr_available_flag
11427: FROM ams_custom_setup_attr
11428: WHERE custom_setup_id = p_custom_setup_id
11429: AND object_attribute = 'BAPL';
11430:
11431: CURSOR c_get_sdr_owner(p_sdr_header_id NUMBER) IS