[Home] [Help]
3597: /*CURSOR c_process(p_certification_id NUMBER) IS
3598: SELECT distinct aa.pk1 organization_id, aa.pk2 process_id, po.revision_number, po.process_org_rev_id
3599: FROM AMW_ACCT_ASSOCIATIONS aa,
3600: AMW_FIN_ITEMS_KEY_ACC fika,
3601: AMW_PROCESS_ORGANIZATION po,
3602: AMW_CERTIFICATION_B cert
3603: WHERE aa.object_type = 'PROCESS_ORG'
3604: AND aa.pk1 = po.organization_id
3605: AND aa.pk2 = po.process_id
3606: AND aa.approval_date is not null
3607: AND aa.approval_date = po.approval_date
3608: AND aa.deletion_approval_date is null
3609: AND po.approval_end_date is null
3610: AND po.revision_number = (select max(revision_number) from amw_process_organization
3611: where organization_id = aa.pk1 and process_id = aa.pk2 and approval_date = aa.approval_date)
3612: AND fika.statement_group_id = cert.statement_group_id
3613: AND fika.financial_statement_id = cert.financial_statement_id
3614: AND cert.certification_id = p_certification_id
3628: /*CURSOR c_process(p_certification_id NUMBER) IS
3629: SELECT distinct aa.pk1 organization_id, aa.pk2 process_id, po.revision_number, po.process_org_rev_id
3630: FROM AMW_ACCT_ASSOCIATIONS aa,
3631: AMW_FIN_ITEMS_KEY_ACC fika,
3632: AMW_PROCESS_ORGANIZATION po,
3633: AMW_CERTIFICATION_B cert
3634: WHERE cert.certification_id = p_certification_id
3635: AND aa.object_type = 'PROCESS_ORG'
3636: AND aa.pk1 = po.organization_id
3669: SELECT PO.ORGANIZATION_ID,
3670: PO.PROCESS_ID,
3671: PO.REVISION_NUMBER,
3672: PO.PROCESS_ORG_REV_ID
3673: FROM AMW_PROCESS_ORGANIZATION PO ,amw_audit_units_v aauv
3674: WHERE /*02.13.07 npanandi: bug 5043879 fix for
3675: including only those orgs that are active */
3676: po.organization_id = aauv.organization_id
3677: and
3715: /*CURSOR c_child_processes(p_proc_id NUMBER, p_org_id NUMBER) IS
3716: SELECT distinct temp.child_process_id, temp.organization_id, orgproc.revision_number,
3717: orgproc.process_org_rev_id
3718: FROM AMW_FIN_PROCESS_FLAT temp,
3719: AMW_PROCESS_ORGANIZATION orgproc
3720: WHERE temp.parent_process_id = p_proc_id
3721: AND temp.organization_id = p_org_id
3722: AND temp.certification_id = p_certification_id
3723: AND orgproc.process_id = temp.child_process_id
3723: AND orgproc.process_id = temp.child_process_id
3724: AND orgproc.organization_id = temp.organization_id
3725: AND orgproc.approval_date is not null
3726: AND orgproc.approval_end_date is null
3727: AND orgproc.revision_number = (select max(revision_number) from AMW_PROCESS_ORGANIZATION orgproc2
3728: where orgproc2.process_id = orgproc.process_id
3729: and orgproc2.organization_id = orgproc.organization_id);
3730: --------------------------------------------------------*/
3731: /*
3741: CURSOR c_child_processes(p_proc_id NUMBER, p_org_id NUMBER) IS
3742: SELECT distinct temp.child_process_id, temp.organization_id, orgproc.revision_number,
3743: orgproc.process_org_rev_id
3744: FROM AMW_FIN_PROCESS_FLAT temp,
3745: AMW_PROCESS_ORGANIZATION orgproc, amw_audit_units_v aauv
3746: WHERE /*02.13.07 npanandi: bug 5043879 fix for
3747: including only those orgs that are active */
3748: orgproc.organization_id = aauv.organization_id
3749: and
3807: select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
3808: where fin_stmt_cert_id = p_cert_id
3809: and end_date is null)
3810: AND aov.pk1_value in (SELECT varproc.process_id
3811: FROM AMW_PROCESS varproc
3812: WHERE varproc.standard_variation = p_process_id
3813: AND varproc.standard_process_flag = 'N'
3814: AND varproc.process_id in (select distinct evalsum.process_id
3815: from amw_fin_process_eval_sum evalsum
3821: (select distinct evalsum.organization_id,evalsum.process_id
3822: from amw_fin_process_eval_sum evalsum
3823: where evalsum.fin_certification_id = p_cert_id
3824: and evalsum.process_id in (select varproc.process_id
3825: FROM AMW_PROCESS varproc
3826: WHERE varproc.standard_variation = p_process_id
3827: AND varproc.standard_process_flag = 'N'));
3828:
3829: -- end variant process