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.AMS_ACCESS_DENORM_PVT dependencies on DUAL

Line 230: FROM dual

226: , l_user_id
227: , l_sysdate
228: , l_user_id
229: , l_login_id
230: FROM dual
231: WHERE NOT EXISTS ( SELECT 1
232: FROM ams_act_access_denorm
233: WHERE resource_id = p_resource_id
234: AND object_type = p_object_type

Line 515: -- individual owners allready in denorm,

511: AND jgm.resource_id = aacd.resource_id
512: AND aac.delete_flag = 'N' );
513:
514: ELSIF p_edit_metrics = 'N' THEN
515: -- individual owners allready in denorm,
516: -- update entries if the resource is part of the group heirarchy
517: -- AND the resource is not part of a group which has edit metrics as 'Y'
518: -- added by VMODUR 13-MAR-2003
519: -- The Owner may be part of the above groups and should not be updated

Line 1482: FROM dual

1478: , l_user_id
1479: , l_sysdate
1480: , l_user_id
1481: , l_login_id
1482: FROM dual
1483: WHERE NOT EXISTS ( SELECT 1
1484: FROM ams_act_access_denorm
1485: WHERE resource_id = l_tbl_res(i)
1486: AND object_type = l_tbl_object(i)