DBA Data[Home] [Help]

APPS.AMS_STATUS_PVT dependencies on AMS_STATUS_ORDER_RULES

Line 161: FROM ams_status_order_rules

157: WHERE user_status_id = p_current_status_id ;
158:
159: CURSOR c_next_statuses(l_stat_code VARCHAR2,l_stat_type VARCHAR2) IS
160: SELECT next_status_code
161: FROM ams_status_order_rules
162: WHERE current_status_code = l_stat_code
163: AND system_status_type = l_stat_type
164: AND show_in_lov_flag = 'Y' ;
165: