[Home] [Help]
335: AMW_PROCESS_ORGANIZATION_VL proc,
336: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
337: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,
338: amw_certification_b acb,
339: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,
340: amw_gl_periods_v agpv
341: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID
342: and rel.end_date is null
343: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
535: amw_certification_vl acv,
536: amw_audit_projects_v aapv,
537: amw_certification_vl acv2,
538: AMW_FIN_PROC_CERT_RELAN afpcr,
539: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,
540: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,
541: /** 10.19.2005 npanandi begin ***/
542: amw_gl_periods_v agpv
543: /** 10.19.2005 npanandi end ***/
744: AMW_PROCESS_ORGANIZATION_VL proc,
745: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
746: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,
747: amw_certification_b acb,
748: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,
749: amw_gl_periods_v agpv
750: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID
751: and rel.end_date is null
752: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
929: amw_certification_vl acv,
930: amw_audit_projects_v aapv,
931: amw_certification_vl acv2,
932: AMW_FIN_PROC_CERT_RELAN afpcr,
933: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,
934: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,
935: /** 10.19.2005 npanandi begin ***/
936: amw_gl_periods_v agpv
937: /** 10.19.2005 npanandi end ***/