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.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_AUDIT_PROJECTS_V

Line 190: select audit_project_id into v_audit_project_id from amw_audit_projects_v

186: fnd_file.put_line (fnd_file.LOG, 'To fetch audit procedure');
187: FOR projid_rec IN c_projid LOOP
188: v_audit_project_id := null;
189:
190: select audit_project_id into v_audit_project_id from amw_audit_projects_v
191: where substr(to_char(start_date),1,11) = substr(to_char(projid_rec.audit_project_startdate),1,11) and project_name = projid_rec.audit_project_name
192: and template_flag = 'N';
193:
194: update amw_audit_procedure_interface set audit_project_id = v_audit_project_id