APPS.AMS_EVTREGS_PVT dependencies on AMS_USER_STATUSES_VL

Line 1459: from ams_user_statuses_vl

1455: WHERE event_registration_id = p_evt_regs_rec.event_registration_id;
1456:
1457: Cursor c_cancel_status_id is
1458: select user_status_id
1459: from ams_user_statuses_vl
1460: where system_status_type = 'AMS_EVENT_REG_STATUS'
1461: and system_status_code = 'CANCELLED'
1462: and default_flag = 'Y';
1463:

Line 1681: ams_user_statuses_vl u

1677: select e.reg_effective_capacity,
1678: e.system_status_code,
1679: u.name
1680: from ams_event_offers_all_b e,
1681: ams_user_statuses_vl u
1682: where e.event_offer_id = p_event_id
1683: and e.user_status_id = u.user_status_id;
1684:
1685: cursor c_get_status_code(p_status_id IN NUMBER) IS

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

2140: offers.EVENT_END_DATE,
2141: offers.EVENT_END_DATE_TIME,
2142: offers.REG_END_DATE,
2143: offers.REG_END_TIME
2144: from ams_event_offers_all_b offers, ams_event_registrations reg, ams_user_statuses_vl usrsts
2145: where offers.EVENT_OFFER_ID = l_event_offer_id
2146: and reg.EVENT_OFFER_ID = l_event_offer_id
2147: and reg.CONFIRMATION_CODE = l_confirmation_code
2148: and nvl(l_registrant_party_id, reg.REGISTRANT_PARTY_ID) = reg.REGISTRANT_PARTY_ID

Line 2170: from AMS_USER_STATUSES_VL

2166: from dual;
2167:
2168: Cursor cur_user_stat_id is
2169: select USER_STATUS_ID
2170: from AMS_USER_STATUSES_VL
2171: where SYSTEM_STATUS_CODE = 'CANCELLED'
2172: and DEFAULT_FLAG = 'Y'
2173: and SYSTEM_STATUS_TYPE = 'AMS_EVENT_REG_STATUS';
2174:

Line 3366: from ams_user_statuses_vl

3362: update ams_event_registrations set
3363: system_status_code = 'REGISTERED',
3364: waitlisted_priority = null,
3365: user_status_id = (select user_status_id
3366: from ams_user_statuses_vl
3367: where system_status_type = 'AMS_EVENT_REG_STATUS'
3368: and system_status_code = 'REGISTERED'
3369: and default_flag = 'Y'
3370: )