DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_PVT dependencies on AMS_USER_STATUSES_B

Line 1547: FROM ams_user_statuses_b

1543: l_status_code VARCHAR2(30);
1544:
1545: CURSOR c_user_status_id (p_status_type IN VARCHAR2, p_status_code IN VARCHAR2) IS
1546: SELECT user_status_id
1547: FROM ams_user_statuses_b
1548: WHERE system_status_type = p_status_type
1549: AND system_status_code = p_status_code
1550: AND default_flag = 'Y'
1551: AND enabled_flag = 'Y'

Line 1725: FROM ams_user_statuses_b

1721: l_status_code VARCHAR2(30);
1722:
1723: CURSOR c_user_status_id (p_status_type IN VARCHAR2, p_status_code IN VARCHAR2) IS
1724: SELECT user_status_id
1725: FROM ams_user_statuses_b
1726: WHERE system_status_type = p_status_type
1727: AND system_status_code = p_status_code
1728: AND default_flag = 'Y'
1729: AND enabled_flag = 'Y'