APPS.AMS_EVTREGS_PVT dependencies on AMS_USER_STATUSES_B

Line 167: FROM ams_user_statuses_b

163: FROM dual;
164:
165: CURSOR c_evt_reg_status IS
166: SELECT user_status_id
167: FROM ams_user_statuses_b
168: WHERE SYSTEM_STATUS_CODE = p_system_status_code
169: and SYSTEM_STATUS_TYPE = 'AMS_EVENT_REG_STATUS'
170: and default_flag = 'Y'; --anchaudh:fixed bug#3020564 on 24-jun-2003.
171:

Line 1702: from ams_user_statuses_b

1698: and e.user_status_id = u.user_status_id;
1699:
1700: cursor c_get_status_code(p_status_id IN NUMBER) IS
1701: select system_status_code
1702: from ams_user_statuses_b
1703: where user_status_id = p_status_id
1704: and system_status_type = 'AMS_EVENT_REG_STATUS';
1705:
1706: -- soagrawa 18-nov-2002 for bug# 2672928

Line 4311: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'

4307:
4308: --------------user status id------------------------
4309: IF (p_evt_regs_rec.user_status_id <> FND_API.g_miss_num)
4310: THEN
4311: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4312: , 'user_status_id'
4313: , p_evt_regs_rec.user_status_id
4314: ) = FND_API.g_false
4315: )

Line 4374: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'

4370: IF (p_evt_regs_rec.system_status_code <> FND_API.g_miss_char)
4371: THEN
4372: IF (p_validation_mode = JTF_PLSQL_API.g_create)
4373: THEN
4374: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4375: , 'system_status_code'
4376: , p_evt_regs_rec.system_status_code
4377: , AMS_Utility_PVT.g_varchar2
4378: ) = FND_API.g_false