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.PV_PRGM_APPROVAL_PVT dependencies on AMS_APPROVAL_DETAILS

Line 735: (select approver_id from ams_approvers appr,ams_approval_details apdt

731: l_temp varchar2(1);
732: isavailable boolean:=false ;
733: cursor app_cur(p_prgm_type_id varchar) is
734: select 'X' from dual where exists
735: (select approver_id from ams_approvers appr,ams_approval_details apdt
736: where nvl(appr.start_date_active,sysdate)<=sysdate
737: and nvl(appr.end_date_active,sysdate)>=sysdate
738: and appr.ams_approval_detail_id =apdt.approval_detail_id
739: and apdt.approval_object_type=p_prgm_type_id