APPS.AMS_EVTREGS_PVT dependencies on AMS_USER_STATUSES_VL

Line 1474: from ams_user_statuses_vl

1470: WHERE event_registration_id = p_evt_regs_rec.event_registration_id;
1471:
1472: Cursor c_cancel_status_id is
1473: select user_status_id
1474: from ams_user_statuses_vl
1475: where system_status_type = 'AMS_EVENT_REG_STATUS'
1476: and system_status_code = 'CANCELLED'
1477: and default_flag = 'Y';
1478:

Line 1696: ams_user_statuses_vl u

1692: select e.reg_effective_capacity,
1693: e.system_status_code,
1694: u.name
1695: from ams_event_offers_all_b e,
1696: ams_user_statuses_vl u
1697: where e.event_offer_id = p_event_id
1698: and e.user_status_id = u.user_status_id;
1699:
1700: cursor c_get_status_code(p_status_id IN NUMBER) IS

Line 2159: from ams_event_offers_all_b offers, ams_event_registrations reg, ams_user_statuses_vl usrsts

2155: offers.EVENT_END_DATE,
2156: offers.EVENT_END_DATE_TIME,
2157: offers.REG_END_DATE,
2158: offers.REG_END_TIME
2159: from ams_event_offers_all_b offers, ams_event_registrations reg, ams_user_statuses_vl usrsts
2160: where offers.EVENT_OFFER_ID = l_event_offer_id
2161: and reg.EVENT_OFFER_ID = l_event_offer_id
2162: and reg.CONFIRMATION_CODE = l_confirmation_code
2163: and nvl(l_registrant_party_id, reg.REGISTRANT_PARTY_ID) = reg.REGISTRANT_PARTY_ID

Line 2185: from AMS_USER_STATUSES_VL

2181: from dual;
2182:
2183: Cursor cur_user_stat_id is
2184: select USER_STATUS_ID
2185: from AMS_USER_STATUSES_VL
2186: where SYSTEM_STATUS_CODE = 'CANCELLED'
2187: and DEFAULT_FLAG = 'Y'
2188: and SYSTEM_STATUS_TYPE = 'AMS_EVENT_REG_STATUS';
2189:

Line 3381: from ams_user_statuses_vl

3377: update ams_event_registrations set
3378: system_status_code = 'REGISTERED',
3379: waitlisted_priority = null,
3380: user_status_id = (select user_status_id
3381: from ams_user_statuses_vl
3382: where system_status_type = 'AMS_EVENT_REG_STATUS'
3383: and system_status_code = 'REGISTERED'
3384: and default_flag = 'Y'
3385: )