DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_PVT dependencies on AMS_USER_STATUSES_VL

Line 1556: FROM ams_user_statuses_vl

1552: ;
1553:
1554: CURSOR c_pass_status_code (p_user_status_id IN NUMBER) IS
1555: SELECT system_status_code
1556: FROM ams_user_statuses_vl
1557: WHERE user_status_id = p_user_status_id;
1558:
1559: BEGIN
1560: UPDATE ams_dm_targets_b

Line 1734: FROM ams_user_statuses_vl

1730: ;
1731:
1732: CURSOR c_pass_status_code (p_user_status_id IN NUMBER) IS
1733: SELECT system_status_code
1734: FROM ams_user_statuses_vl
1735: WHERE user_status_id = p_user_status_id;
1736:
1737: BEGIN
1738: UPDATE ams_dm_targets_b