APPS.AMW_PROCESS_CERT_SCOPE_PVT dependencies on AMW_CURR_APP_HIERARCHY_ORG_V

Line 34: FROM AMW_CURR_APP_HIERARCHY_ORG_V apv

30: p_certification_id IN NUMBER
31: ) IS
32: CURSOR c_process IS
33: SELECT apv.child_process_id process_id
34: FROM AMW_CURR_APP_HIERARCHY_ORG_V apv
35: WHERE apv.PARENT_PROCESS_ID = p_parent_process_id
36: and apv.child_organization_id = p_organization_id;
37: BEGIN
38: FOR proc_rec IN c_process LOOP

Line 104: FROM AMW_CURR_APP_HIERARCHY_ORG_V org_v,

100: SELECT org_v.child_process_id as top_process_id,
101: org_v.child_organization_id as organization_id,
102: audit_v.company_code,audit_v.subsidiary_valueset,
103: audit_v.lob_code,audit_v.lob_valueset
104: FROM AMW_CURR_APP_HIERARCHY_ORG_V org_v,
105: amw_audit_units_v audit_v
106: where org_v.parent_process_id = -2
107: and audit_v.organization_id = org_v.child_organization_id;
108: l_api_name VARCHAR2(150) := 'Insert_Audit_Units';

Line 372: FROM AMW_CURR_APP_HIERARCHY_ORG_V org_v,

368: audit_v.company_code,
369: audit_v.subsidiary_valueset,
370: audit_v.lob_code,
371: audit_v.lob_valueset
372: FROM AMW_CURR_APP_HIERARCHY_ORG_V org_v,
373: amw_audit_units_v audit_v
374: WHERE org_v.parent_process_id = -2
375: AND audit_v.organization_id = org_v.child_organization_id
376: AND audit_v.organization_id =';