APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_CERTIFICATION_VL

Line 532: from AMW_CERTIFICATION_VL

528: -- select all processes in scope for the certification
529:
530: cursor c1 is
531: Select distinct CERTIFICATION_ID
532: from AMW_CERTIFICATION_VL
533: where object_type = 'FIN_STMT' and
534: CERTIFICATION_STATUS in ('ACTIVE','DRAFT');
535:
536: c1_rec c1%rowtype;

Line 3209: AMW_CERTIFICATION_vl certifcationVL

3205: certifcationVL.CERTIFICATION_ID ,
3206: certifcationVL.FINANCIAL_STATEMENT_ID,
3207: certifcationVL.STATEMENT_GROUP_ID
3208: FROM
3209: AMW_CERTIFICATION_vl certifcationVL
3210: where
3211: certifcationVL.OBJECT_TYPE='FIN_STMT'
3212: and certifcationVL.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
3213:

Line 3221: AMW_CERTIFICATION_vl certifcationVL

3217: certifcationVL.CERTIFICATION_ID ,
3218: certifcationVL.FINANCIAL_STATEMENT_ID,
3219: certifcationVL.STATEMENT_GROUP_ID
3220: FROM
3221: AMW_CERTIFICATION_vl certifcationVL
3222: where
3223: certifcationVL.OBJECT_TYPE='FIN_STMT'
3224: and certifcationVL.CERTIFICATION_ID = P_CERTIFICATION_ID;
3225:

Line 3448: FROM AMW_CERTIFICATION_vl certifcationVL

3444: total_number_of_orgs = 0
3445: WHERE fin_certification_id IN
3446: (select
3447: certifcationVL.CERTIFICATION_ID
3448: FROM AMW_CERTIFICATION_vl certifcationVL
3449: where
3450: certifcationVL.OBJECT_TYPE='FIN_STMT'
3451: and certifcationVL.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT'));
3452:

Line 4714: AMW_CERTIFICATION_VL CERTIFICATION,

4710: GL_PERIODS.START_DATE ,
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