APPS.PV_PARTNER_PROGRAM_PVT dependencies on AMS_USER_STATUSES_VL

Line 4057: FROM ams_user_statuses_vl

4053: WHERE program_id = cv_program_id;
4054:
4055: CURSOR c_get_user_status_id IS
4056: SELECT user_status_id
4057: FROM ams_user_statuses_vl
4058: WHERE system_status_type = 'PV_PROGRAM_STATUS'
4059: AND system_status_code = 'NEW'
4060: AND enabled_flag = 'Y';
4061: