APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_CERTIFICATION_B

Line 927: amw_certification_b acb,

923: FROM AMW_RISK_ASSOCIATIONS ara,
924: amw_execution_scope aes,
925: ---05.24.2005 npanandi: added AmwCertificationB, AmwGlPeriodsV
926: ---in the joins below
927: amw_certification_b acb,
928: amw_gl_periods_v period,
929: amw_audit_units_v aauv --03.28.2007 npanandi: bug 5764832 fix -- added join to
930: --AmwAuditUnitsV to make count consistent with the
931: --'New Risks' added page results

Line 962: amw_certification_b acb,

958: AMW_RISK_ASSOCIATIONS ara,
959: AMW_EXECUTION_SCOPE aes,
960: ---05.24.2005 npanandi: added AmwCertificationB, AmwGlPeriodsV
961: ---in the joins below
962: amw_certification_b acb,
963: amw_gl_periods_v period,
964: amw_audit_units_v aauv --03.28.2007 npanandi: bug 5764832 fix -- added join to
965: --AmwAuditUnitsV to make count consistent with the
966: --'New Controls' added page results

Line 1410: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

1406: IS
1407: -- select all processes in scope for the certification
1408: CURSOR c_cert IS
1409: SELECT cert.CERTIFICATION_ID, period.start_date
1410: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
1411: WHERE cert.certification_period_name = period.period_name
1412: AND cert.certification_period_set_name = period.period_set_name
1413: AND cert.certification_status in ('ACTIVE','DRAFT')
1414: AND cert.OBJECT_TYPE = 'PROCESS';

Line 1418: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

1414: AND cert.OBJECT_TYPE = 'PROCESS';
1415:
1416: CURSOR c_start_date IS
1417: SELECT period.start_date
1418: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
1419: WHERE cert.certification_period_name = period.period_name
1420: AND cert.certification_period_set_name = period.period_set_name
1421: AND cert.certification_id = p_certification_id;
1422:

Line 1492: FROM amw_certification_b cert

1488: lx_msg_data VARCHAR2(2000);
1489:
1490: CURSOR get_all_certifications IS
1491: SELECT cert.certification_id
1492: FROM amw_certification_b cert
1493: WHERE cert.certification_status in ('ACTIVE','DRAFT')
1494: AND cert.object_type = 'PROCESS';
1495:
1496: BEGIN