DBA Data[Home] [Help]

APPS.OZF_FUNDS_PVT dependencies on AMS_USER_STATUSES_VL

Line 141: FROM ams_user_statuses_vl

137:
138: CURSOR c_status_code
139: IS
140: SELECT system_status_code
141: FROM ams_user_statuses_vl
142: WHERE user_status_id = p_user_status_id
143: AND system_status_type = 'OZF_FUND_STATUS'
144: AND enabled_flag = 'Y';
145: BEGIN

Line 179: FROM ams_user_statuses_vl

175:
176: CURSOR c_user_status_id
177: IS
178: SELECT user_status_id
179: FROM ams_user_statuses_vl
180: WHERE UPPER(system_status_code) = UPPER(p_status_code)
181: AND system_status_type = 'OZF_FUND_STATUS'
182: AND enabled_flag = 'Y';
183: BEGIN

Line 3333: 'ams_user_statuses_vl'

3329:
3330: ----------------------- user_status_id ------------------------
3331: IF p_fund_rec.user_status_id <> fnd_api.g_miss_num THEN
3332: IF ozf_utility_pvt.check_fk_exists(
3333: 'ams_user_statuses_vl'
3334: ,'user_status_id'
3335: ,p_fund_rec.user_status_id) =
3336: fnd_api.g_false THEN
3337: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN