APPS.AMS_DM_SCORE_PVT dependencies on AMS_USER_STATUSES_B

Line 119: FROM ams_user_statuses_b

115:
116: -- global cursors
117: CURSOR c_user_status_id (p_status_type IN VARCHAR2, p_status_code IN VARCHAR2) IS
118: SELECT user_status_id
119: FROM ams_user_statuses_b
120: WHERE system_status_type = p_status_type
121: AND system_status_code = p_status_code
122: AND default_flag = 'Y'
123: AND enabled_flag = 'Y'

Line 129: FROM ams_user_statuses_b

125:
126: -- Cursor to get the system_status_code for a specific system_status_type and user_status_id
127: CURSOR c_user_status_code (p_status_type IN VARCHAR2, p_status_id IN NUMBER) IS
128: SELECT system_status_code
129: FROM ams_user_statuses_b
130: WHERE system_status_type = p_status_type
131: AND user_status_id = p_status_id
132: ;
133:

Line 1748: 'AMS_USER_STATUSES_B',

1744:
1745: --------------------- user_status_id ------------------------
1746: IF p_score_rec.user_status_id <> FND_API.g_miss_num THEN
1747: IF AMS_Utility_PVT.check_fk_exists(
1748: 'AMS_USER_STATUSES_B',
1749: 'USER_STATUS_ID',
1750: p_score_rec.user_status_id
1751: ) = FND_API.g_false
1752: THEN