APPS.AMS_AGENDAS_PVT dependencies on AMS_USER_STATUSES_B

Line 704: FROM AMS_USER_STATUSES_B

700: UPDATE ams_act_resources
701: SET system_status_code = 'UNCONFIRMED',
702: object_version_number = object_version_number + 1,
703: user_status_id = ( SELECT user_status_id
704: FROM AMS_USER_STATUSES_B
705: WHERE SYSTEM_STATUS_CODE = 'UNCONFIRMED'
706: AND SYSTEM_STATUS_TYPE = 'AMS_EVENT_AGENDA_STATUS'
707: -- added by soagrawa on 25-feb-2003 for bug# 2820297
708: AND DEFAULT_FLAG = 'Y'),

Line 754: FROM AMS_USER_STATUSES_B

750: -- start_date_time = p_agenda_rec.start_date_time,
751: -- end_date_time = p_agenda_rec.end_date_time,
752: system_status_code = 'UNCONFIRMED',
753: user_status_id = ( SELECT user_status_id
754: FROM AMS_USER_STATUSES_B
755: WHERE SYSTEM_STATUS_CODE = 'UNCONFIRMED'
756: AND SYSTEM_STATUS_TYPE = 'AMS_EVENT_AGENDA_STATUS'
757: -- added by soagrawa on 25-feb-2003 for bug# 2820297
758: AND DEFAULT_FLAG = 'Y')

Line 778: FROM AMS_USER_STATUSES_B

774: SET object_version_number = object_version_number + 1,
775: -- end_date_time = p_agenda_rec.end_date_time,
776: system_status_code = 'UNCONFIRMED',
777: user_status_id = ( SELECT user_status_id
778: FROM AMS_USER_STATUSES_B
779: WHERE SYSTEM_STATUS_CODE = 'UNCONFIRMED'
780: AND SYSTEM_STATUS_TYPE = 'AMS_EVENT_AGENDA_STATUS'
781: -- added by soagrawa on 25-feb-2003 for bug# 2820297
782: AND DEFAULT_FLAG = 'Y')

Line 800: FROM AMS_USER_STATUSES_B

796: SET object_version_number = object_version_number + 1,
797: -- start_date_time = p_agenda_rec.start_date_time,
798: system_status_code = 'UNCONFIRMED',
799: user_status_id = ( SELECT user_status_id
800: FROM AMS_USER_STATUSES_B
801: WHERE SYSTEM_STATUS_CODE = 'UNCONFIRMED'
802: AND SYSTEM_STATUS_TYPE = 'AMS_EVENT_AGENDA_STATUS'
803: -- added by soagrawa on 25-feb-2003 for bug# 2820297
804: AND DEFAULT_FLAG = 'Y')