APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 459: FROM ams_custom_setup_attr

455: WHERE qp_list_header_id=p_list_header_id;
456: -- code to get custom setup for approval
457: CURSOR c_attr_available_flag(p_custom_setup_id NUMBER) IS
458: SELECT attr_available_flag
459: FROM ams_custom_setup_attr
460: WHERE custom_setup_id = p_custom_setup_id
461: AND object_attribute = 'ADJA';
462:
463: CURSOR c_backdate_flag(p_list_header_id NUMBER, p_offer_adjustment_id NUMBER, p_effective_date DATE) IS

Line 613: -- from ams_custom_setup_attr

609: END IF;
610:
611: -- Call Approval Work Flow
612: -- Select attr_available_flag
613: -- from ams_custom_setup_attr
614: -- where custom_setup_id = 91
615: -- and object_attribute = 'ADJA';
616:
617: -- have to get the custom setup from offers table from another cursor