DBA Data[Home] [Help]

APPS.AMS_DM_MODEL_PVT dependencies on AMS_STATUS_ORDER_RULES

Line 277: --select important info for the row in ams_status_order_rules

273: x_msg_data OUT NOCOPY VARCHAR2)
274: IS
275: l_api_name CONSTANT VARCHAR2(30) := 'Validate_next_status';
276:
277: --select important info for the row in ams_status_order_rules
278: CURSOR c_status_check IS
279: SELECT show_in_lov_flag,
280: theme_approval_flag, budget_approval_flag
281: FROM ams_status_order_rules

Line 281: FROM ams_status_order_rules

277: --select important info for the row in ams_status_order_rules
278: CURSOR c_status_check IS
279: SELECT show_in_lov_flag,
280: theme_approval_flag, budget_approval_flag
281: FROM ams_status_order_rules
282: WHERE system_status_type = p_system_status_type
283: AND current_status_code = p_curr_status
284: AND next_status_code = p_next_status;
285: