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_FINSTMT_CERT_BES_PKG dependencies on AMW_GL_PERIODS_V

Line 2480: amw_gl_periods_v GL_PERIODS

2476: GL_PERIODS.END_DATE
2477: into P_start_date, P_end_Date
2478: from
2479: AMW_CERTIFICATION_VL CERTIFICATION,
2480: amw_gl_periods_v GL_PERIODS
2481: WHERE
2482: GL_PERIODS.PERIOD_NAME = CERTIFICATION.CERTIFICATION_PERIOD_NAME
2483: AND GL_PERIODS.PERIOD_SET_NAME = CERTIFICATION.CERTIFICATION_PERIOD_SET_NAME
2484: and CERTIFICATION.OBJECT_TYPE='FIN_STMT'

Line 4821: AMW_GL_PERIODS_V period

4817: )IS
4818: CURSOR c_cert IS
4819: SELECT cert.certification_id, period.start_date,period.end_date
4820: FROM AMW_CERTIFICATION_B cert,
4821: AMW_GL_PERIODS_V period
4822: WHERE cert.certification_period_name = period.period_name
4823: AND cert.certification_period_set_name = period.period_set_name
4824: AND cert.object_type='FIN_STMT'
4825: AND cert.certification_status in ('ACTIVE','DRAFT');

Line 5155: AMW_GL_PERIODS_V period

5151: ) IS
5152: CURSOR c_cert IS
5153: SELECT cert.certification_id, period.start_date,period.end_date
5154: FROM AMW_CERTIFICATION_B cert,
5155: AMW_GL_PERIODS_V period
5156: WHERE cert.certification_period_name = period.period_name
5157: AND cert.certification_period_set_name = period.period_set_name
5158: AND cert.object_type='FIN_STMT'
5159: AND cert.certification_status in ('ACTIVE','DRAFT');

Line 5499: AMW_GL_PERIODS_V period

5495:
5496: CURSOR c_cert IS
5497: SELECT cert.certification_id, period.start_date, period.end_date
5498: FROM AMW_CERTIFICATION_B cert,
5499: AMW_GL_PERIODS_V period
5500: WHERE cert.certification_period_name = period.period_name
5501: AND cert.certification_period_set_name = period.period_set_name
5502: AND cert.object_type='FIN_STMT'
5503: AND cert.certification_status in ('ACTIVE','DRAFT');

Line 6817: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

6813: ) IS
6814: -- select all processes in scope for the certification
6815: CURSOR c_cert IS
6816: SELECT cert.CERTIFICATION_ID, period.start_date
6817: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
6818: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
6819: AND cert.certification_period_set_name = period.period_set_name
6820: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
6821:

Line 6824: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

6820: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
6821:
6822: CURSOR c_start_date IS
6823: SELECT period.start_date
6824: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
6825: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
6826: AND cert.certification_period_set_name = period.period_set_name
6827: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT')
6828: AND cert.certification_id = p_certification_id;

Line 6943: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

6939: CURSOR new_risks_added IS
6940: SELECT count(1)
6941: FROM AMW_RISK_ASSOCIATIONS
6942: WHERE association_creation_date >= (SELECT period.start_date
6943: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
6944: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
6945: AND cert.certification_period_set_name = period.period_set_name
6946: AND cert.certification_id = p_certification_id)
6947: AND object_type = 'PROCESS_FINCERT'

Line 6956: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

6952: CURSOR new_controls_added IS
6953: SELECT count(1)
6954: FROM AMW_CONTROL_ASSOCIATIONS
6955: WHERE association_creation_date >= (SELECT period.start_date
6956: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
6957: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
6958: AND cert.certification_period_set_name = period.period_set_name
6959: AND cert.certification_id = p_certification_id)
6960: and pk1 = p_certification_id