APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on AMS_USER_STATUSES_VL

Line 1464: 'ams_user_statuses_vl'

1460: IF p_offers_rec.user_status_id <> FND_API.G_MISS_NUM
1461: AND p_offers_rec.user_status_id IS NOT NULL
1462: THEN
1463: IF OZF_Utility_PVT.check_fk_exists(
1464: 'ams_user_statuses_vl'
1465: ,'user_status_id '
1466: ,p_offers_rec.user_status_id) = FND_API.g_false
1467: THEN
1468: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_USER_STATUS_ID');

Line 1941: FROM ams_user_statuses_vl

1937: l_status_code VARCHAR2(30);
1938:
1939: CURSOR c_status_code IS
1940: SELECT system_status_code
1941: FROM ams_user_statuses_vl
1942: WHERE user_status_id = p_user_status_id
1943: AND system_status_type = 'OZF_OFFER_STATUS'
1944: AND enabled_flag = 'Y';
1945:

Line 1973: FROM ams_user_statuses_vl

1969: l_status_id NUMBER;
1970:
1971: CURSOR c_status_id IS
1972: SELECT user_status_id
1973: FROM ams_user_statuses_vl
1974: WHERE system_status_type = 'OZF_OFFER_STATUS'
1975: AND system_status_code = 'DRAFT'
1976: AND default_flag = 'Y'
1977: AND enabled_flag = 'Y';