APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_CERTIFICATION_VL

Line 866: FROM AMW_CERTIFICATION_VL

862:
863: -- select all processes in scope for the certification
864: CURSOR get_all_processes is
865: SELECT distinct CERTIFICATION_ID
866: FROM AMW_CERTIFICATION_VL
867: WHERE OBJECT_TYPE = 'PROCESS'
868: AND certification_status in ('ACTIVE','DRAFT');
869:
870: proc_rec get_all_processes%rowtype;

Line 1716: FROM AMW_CERTIFICATION_VL

1712:
1713: -- select all processes in scope for the certification
1714: CURSOR get_all_processes is
1715: SELECT distinct CERTIFICATION_ID
1716: FROM AMW_CERTIFICATION_VL
1717: WHERE OBJECT_TYPE = 'PROCESS'
1718: AND certification_status in ('ACTIVE','DRAFT');
1719:
1720: proc_rec get_all_processes%rowtype;