APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_GL_PERIODS_V

Line 1492: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

1488: IS
1489: -- select all processes in scope for the certification
1490: CURSOR c_cert IS
1491: SELECT cert.CERTIFICATION_ID, period.start_date
1492: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
1493: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
1494: AND cert.certification_period_set_name = period.period_set_name
1495: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
1496:

Line 1499: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

1495: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
1496:
1497: CURSOR c_start_date IS
1498: SELECT period.start_date
1499: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
1500: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
1501: AND cert.certification_period_set_name = period.period_set_name
1502: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT')
1503: AND cert.certification_id = p_certification_id;

Line 1872: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

1868:
1869: -- select all processes in scope for the certification
1870: CURSOR c_cert IS
1871: SELECT cert.CERTIFICATION_ID, period.start_date
1872: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
1873: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
1874: AND cert.certification_period_set_name = period.period_set_name
1875: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
1876:

Line 1972: AMW_GL_PERIODS_V period

1968:
1969: CURSOR c_cert IS
1970: SELECT cert.certification_id, period.start_date,period.end_date
1971: FROM AMW_CERTIFICATION_B cert,
1972: AMW_GL_PERIODS_V period
1973: WHERE cert.certification_period_name = period.period_name
1974: AND cert.certification_period_set_name = period.period_set_name
1975: AND cert.object_type='FIN_STMT'
1976: AND cert.certification_status in ('ACTIVE','DRAFT');

Line 1981: AMW_GL_PERIODS_V period

1977:
1978: CURSOR c_period_dates IS
1979: SELECT period.start_date,period.end_date
1980: FROM AMW_CERTIFICATION_B cert,
1981: AMW_GL_PERIODS_V period
1982: WHERE cert.certification_period_name = period.period_name
1983: AND cert.certification_period_set_name = period.period_set_name
1984: AND cert.certification_id = p_certification_id;
1985:

Line 3010: AMW_GL_PERIODS_V period

3006:
3007: CURSOR c_cert IS
3008: SELECT cert.certification_id, period.start_date, period.end_date
3009: FROM AMW_CERTIFICATION_B cert,
3010: AMW_GL_PERIODS_V period
3011: WHERE cert.certification_period_name = period.period_name
3012: AND cert.certification_period_set_name = period.period_set_name
3013: AND cert.object_type='FIN_STMT'
3014: AND cert.certification_status in ('ACTIVE','DRAFT');

Line 3020: AMW_GL_PERIODS_V period

3016:
3017: CURSOR c_period_date IS
3018: SELECT period.start_date, period.end_date
3019: FROM AMW_CERTIFICATION_B cert,
3020: AMW_GL_PERIODS_V period
3021: WHERE cert.certification_period_name = period.period_name
3022: AND cert.certification_period_set_name = period.period_set_name
3023: AND cert.certification_id = p_certification_id;
3024:

Line 4715: amw_gl_periods_v GL_PERIODS

4711: GL_PERIODS.END_DATE
4712: into P_start_date, P_end_Date
4713: from
4714: AMW_CERTIFICATION_VL CERTIFICATION,
4715: amw_gl_periods_v GL_PERIODS
4716: WHERE
4717: GL_PERIODS.PERIOD_NAME = CERTIFICATION.CERTIFICATION_PERIOD_NAME
4718: AND GL_PERIODS.PERIOD_SET_NAME = CERTIFICATION.CERTIFICATION_PERIOD_SET_NAME
4719: and CERTIFICATION.OBJECT_TYPE='FIN_STMT'