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.

[Home] [Help]

APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_AUDIT_TASKS_V

Line 1014: from amw_audit_tasks_v src , amw_audit_tasks_v dest

1010: (END_DATE>=SYSDATE or END_DATE is null);
1011: cursor c_tasks
1012: is
1013: select src.task_id src_task_id,dest.task_id dest_task_id
1014: from amw_audit_tasks_v src , amw_audit_tasks_v dest
1015: where dest.audit_project_id =p_dest_project_id
1016: and src.audit_project_id =p_source_project_id and src.task_name=dest.task_name
1017: and src.task_number = dest.task_number;
1018:

Line 1032: from amw_audit_tasks_v src , amw_audit_tasks_v dest

1028: and src.pk2=dest.pk2 and src.pk3=dest.pk3
1029: and src.audit_procedure_id =dest.audit_procedure_id ;
1030:
1031: Cursor c_task_icm is select src.task_id src_task_id,dest.task_id dest_task_id
1032: from amw_audit_tasks_v src , amw_audit_tasks_v dest
1033: where dest.audit_project_id =p_dest_project_id
1034: and src.audit_project_id =p_source_project_id and src.task_name=dest.task_name
1035: and src.task_number = dest.task_number
1036: and src.source_code='ICM';

Line 1205: from amw_audit_tasks_v src , amw_audit_tasks_v dest

1201: -- DBMS_OUTPUT.PUT_LINE(x_number);
1202: END LOOP;
1203: IF(x_number is not null) THEN
1204: select src.task_id,dest.task_id into src_task_id, dest_task_id
1205: from amw_audit_tasks_v src , amw_audit_tasks_v dest
1206: where dest.audit_project_id =p_dest_project_id
1207: and src.audit_project_id =p_source_project_id and src.task_name=dest.task_name
1208: and src.task_number = dest.task_number
1209: and src.task_id=(select distinct pk4 from amw_ap_associations where

Line 1402: from amw_audit_tasks_v src , amw_audit_tasks_v dest

1398: (END_DATE>=SYSDATE or END_DATE is null);
1399: cursor c_tasks
1400: is
1401: select src.task_id src_task_id,dest.task_id dest_task_id
1402: from amw_audit_tasks_v src , amw_audit_tasks_v dest
1403: where dest.audit_project_id =p_dest_project_id
1404: and src.audit_project_id =p_source_project_id and src.task_name=dest.task_name
1405: and src.task_number = dest.task_number;
1406:

Line 1420: from amw_audit_tasks_v src , amw_audit_tasks_v dest

1416: and src.pk2=dest.pk2 and src.pk3=dest.pk3
1417: and src.audit_procedure_id =dest.audit_procedure_id ;
1418:
1419: Cursor c_task_icm is select src.task_id src_task_id,dest.task_id dest_task_id
1420: from amw_audit_tasks_v src , amw_audit_tasks_v dest
1421: where dest.audit_project_id =p_dest_project_id
1422: and src.audit_project_id =p_source_project_id and src.task_name=dest.task_name
1423: and src.task_number = dest.task_number
1424: and src.source_code='ICM';

Line 1582: from amw_audit_tasks_v src , amw_audit_tasks_v dest

1578: AND apa2.pk4 = apa.pk4
1579: AND apa2.AUDIT_PROCEDURE_ID=apa.AUDIT_PROCEDURE_ID);
1580:
1581: select src.task_id,dest.task_id into src_task_id, dest_task_id
1582: from amw_audit_tasks_v src , amw_audit_tasks_v dest
1583: where dest.audit_project_id =p_dest_project_id
1584:
1585: and src.audit_project_id =p_source_project_id and src.task_name=dest.task_name
1586: and src.task_number = dest.task_number