DBA Data[Home] [Help]

APPS.AMS_DM_MODEL_PVT dependencies on AMS_USER_STATUSES_VL

Line 542: FROM ams_user_statuses_vl

538: WHERE model_id = p_model_id;
539:
540: CURSOR c_pass_status_code (p_user_status_id IN NUMBER) IS
541: SELECT system_status_code
542: FROM ams_user_statuses_vl
543: WHERE user_status_id = p_user_status_id;
544:
545: CURSOR c_custom_setup_id IS
546: SELECT custom_setup_id

Line 852: FROM ams_user_statuses_vl

848: l_wf_itemkey VARCHAR2(240);
849:
850: CURSOR c_pass_status_code (p_user_status_id IN NUMBER) IS
851: SELECT system_status_code
852: FROM ams_user_statuses_vl
853: WHERE user_status_id = p_user_status_id;
854:
855: CURSOR c_ref_model (p_model_id IN NUMBER) IS
856: SELECT *