APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 460: FROM ams_custom_setup_attr

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

Line 614: -- from ams_custom_setup_attr

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