DBA Data[Home] [Help]

APPS.AMW_PROCESS_CERT_SUMMARY dependencies on STANDARD

Line 324: AND procorg.standard_variation IN

320: FROM (SELECT distinct procorg.organization_id, procorg.process_id
321: FROM amw_execution_scope scp,
322: amw_process_organization procorg
323: WHERE scp.process_org_rev_id = procorg.process_org_rev_id
324: AND procorg.standard_variation IN
325: (select process_rev_id
326: from amw_process
327: where process_id = p_process_id)
328: AND scp.organization_id IN

Line 381: AND procorg.standard_variation in

377: AND opinion.pk3_value = scp.organization_id
378: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'
379: AND scp.entity_id = p_certification_id
380: AND scp.process_org_rev_id = procorg.process_org_rev_id
381: AND procorg.standard_variation in
382: (select process_rev_id
383: from amw_process
384: where process_id = p_process_id)
385: AND scp.organization_id IN

Line 502: AND procorg.standard_variation in

498: AND opinion.pk3_value = scp.organization_id
499: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'
500: AND scp.entity_id = p_certification_id
501: AND scp.process_org_rev_id = procorg.process_org_rev_id
502: AND procorg.standard_variation in
503: (select process_rev_id
504: from amw_process
505: where process_id = p_process_id)
506: AND scp.organization_id IN