eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_PVT dependencies on AMS_USER_STATUSES_VL

Line 114: FROM ams_user_statuses_vl

110: IS
111: CURSOR system_status_csr(p_user_status_id IN NUMBER,
112: p_status_type IN VARCHAR2)IS
113: SELECT system_status_code
114: FROM ams_user_statuses_vl
115: WHERE system_status_type = p_status_type
116: AND user_status_id = p_user_status_id;
117:
118: BEGIN

Line 162: FROM ams_user_statuses_vl

158: x_return_status OUT NOCOPY VARCHAR2)
159: IS
160: CURSOR Get_Status_csr IS
161: SELECT user_status_id
162: FROM ams_user_statuses_vl
163: WHERE system_status_type = p_status_type
164: AND system_status_code = p_status_code
165: AND seeded_flag = 'Y';
166:

Line 8426: FROM ams_user_statuses_vl

8422:
8423: CURSOR status_count_csr(p_status_code in varchar2,
8424: p_user_status_id in number) IS
8425: SELECT count(user_status_id)
8426: FROM ams_user_statuses_vl
8427: WHERE system_status_type = G_CLAIM_STATUS
8428: AND system_status_code = p_status_code
8429: AND user_status_id = p_user_status_id
8430: AND enabled_flag = 'Y';