APPS.AMW_ORG_HIERARCHY_PKG dependencies on AMW_LATEST_HIERARCHY_ORG_V

Line 66: from AMW_LATEST_HIERARCHY_ORG_V

62: -- check in latest hierarchy
63: begin
64: select 1
65: into l_dummy
66: from AMW_LATEST_HIERARCHY_ORG_V
67: where child_process_id = p_process_id
68: and child_organization_id = p_org_id;
69:
70: l_score := 1;

Line 2351: from AMW_LATEST_HIERARCHY_ORG_V

2347: p_process_id in number) is
2348:
2349: cursor c3 (l_pid number, l_org number) is
2350: select child_process_id
2351: from AMW_LATEST_HIERARCHY_ORG_V
2352: where parent_process_id=l_pid
2353: and child_organization_id = l_org;
2354:
2355: c3_rec c3%rowtype;

Line 2429: from AMW_LATEST_HIERARCHY_ORG_V

2425: p_process_id in number) is
2426:
2427: cursor c2 (l_pid number, l_org number) is
2428: select parent_process_id
2429: from AMW_LATEST_HIERARCHY_ORG_V
2430: where child_process_id = l_pid
2431: and child_organization_id = l_org;
2432:
2433: c2_rec c2%rowtype;