APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_GL_PERIODS_V

Line 928: amw_gl_periods_v period,

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
932: ---05.24.2005 npanandi: changed below reference to creationDate

Line 963: amw_gl_periods_v period,

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
967: ---05.24.2005 npanandi: changed below reference to creationDate

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: