APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on AMS_USER_STATUSES_VL

Line 1476: 'ams_user_statuses_vl'

1472: IF p_offers_rec.user_status_id <> FND_API.G_MISS_NUM
1473: AND p_offers_rec.user_status_id IS NOT NULL
1474: THEN
1475: IF OZF_Utility_PVT.check_fk_exists(
1476: 'ams_user_statuses_vl'
1477: ,'user_status_id '
1478: ,p_offers_rec.user_status_id) = FND_API.g_false
1479: THEN
1480: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_USER_STATUS_ID');

Line 1953: FROM ams_user_statuses_vl

1949: l_status_code VARCHAR2(30);
1950:
1951: CURSOR c_status_code IS
1952: SELECT system_status_code
1953: FROM ams_user_statuses_vl
1954: WHERE user_status_id = p_user_status_id
1955: AND system_status_type = 'OZF_OFFER_STATUS'
1956: AND enabled_flag = 'Y';
1957:

Line 1985: FROM ams_user_statuses_vl

1981: l_status_id NUMBER;
1982:
1983: CURSOR c_status_id IS
1984: SELECT user_status_id
1985: FROM ams_user_statuses_vl
1986: WHERE system_status_type = 'OZF_OFFER_STATUS'
1987: AND system_status_code = 'DRAFT'
1988: AND default_flag = 'Y'
1989: AND enabled_flag = 'Y';