DBA Data[Home] [Help]

APPS.AMS_SETUP_ATTR_PVT dependencies on AMS_SETUP_TYPES

Line 868: SELECT mandatory_flag FROM AMS_SETUP_TYPES

864: IS
865:
866: CURSOR c_mand_flag1 (obj_attr IN VARCHAR2,l_obj_type IN VARCHAR2,
867: l_act_type IN VARCHAR2) IS
868: SELECT mandatory_flag FROM AMS_SETUP_TYPES
869: WHERE setup_attribute = obj_attr
870: -- Following lines are added by ptendulk on 29th Dec
871: AND object_type = l_obj_type
872: AND activity_type_code = l_act_type ;

Line 875: SELECT mandatory_flag FROM AMS_SETUP_TYPES

871: AND object_type = l_obj_type
872: AND activity_type_code = l_act_type ;
873: -- cursor added by julou 19-OCT-2001
874: CURSOR c_mand_flag2 (obj_attr IN VARCHAR2,l_obj_type IN VARCHAR2) IS
875: SELECT mandatory_flag FROM AMS_SETUP_TYPES
876: WHERE setup_attribute = obj_attr
877: -- Following lines are added by ptendulk on 29th Dec
878: AND object_type = l_obj_type
879: AND activity_type_code IS NULL ;