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 1687: from ams_user_statuses_b

1683: and e.user_status_id = u.user_status_id;
1684:
1685: cursor c_get_status_code(p_status_id IN NUMBER) IS
1686: select system_status_code
1687: from ams_user_statuses_b
1688: where user_status_id = p_status_id
1689: and system_status_type = 'AMS_EVENT_REG_STATUS';
1690:
1691: -- soagrawa 18-nov-2002 for bug# 2672928

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

4292:
4293: --------------user status id------------------------
4294: IF (p_evt_regs_rec.user_status_id <> FND_API.g_miss_num)
4295: THEN
4296: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4297: , 'user_status_id'
4298: , p_evt_regs_rec.user_status_id
4299: ) = FND_API.g_false
4300: )

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

4355: IF (p_evt_regs_rec.system_status_code <> FND_API.g_miss_char)
4356: THEN
4357: IF (p_validation_mode = JTF_PLSQL_API.g_create)
4358: THEN
4359: IF (AMS_Utility_PVT.check_fk_exists( 'ams_user_statuses_b'
4360: , 'system_status_code'
4361: , p_evt_regs_rec.system_status_code
4362: , AMS_Utility_PVT.g_varchar2
4363: ) = FND_API.g_false