DBA Data[Home] [Help]

APPS.OZF_FUNDS_PVT dependencies on AMS_USER_STATUSES_VL

Line 149: FROM ams_user_statuses_vl

145:
146: CURSOR c_status_code
147: IS
148: SELECT system_status_code
149: FROM ams_user_statuses_vl
150: WHERE user_status_id = p_user_status_id
151: AND system_status_type = 'OZF_FUND_STATUS'
152: AND enabled_flag = 'Y';
153: BEGIN

Line 187: FROM ams_user_statuses_vl

183:
184: CURSOR c_user_status_id
185: IS
186: SELECT user_status_id
187: FROM ams_user_statuses_vl
188: WHERE UPPER(system_status_code) = UPPER(p_status_code)
189: AND system_status_type = 'OZF_FUND_STATUS'
190: AND enabled_flag = 'Y';
191: BEGIN

Line 3732: 'ams_user_statuses_vl'

3728:
3729: ----------------------- user_status_id ------------------------
3730: IF p_fund_rec.user_status_id <> fnd_api.g_miss_num THEN
3731: IF ozf_utility_pvt.check_fk_exists(
3732: 'ams_user_statuses_vl'
3733: ,'user_status_id'
3734: ,p_fund_rec.user_status_id) =
3735: fnd_api.g_false THEN
3736: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN