APPS.AMW_UTILITY_PVT dependencies on AMW_LATEST_HIERARCHIES

Line 1393: where exists ( select 1 from amw_latest_hierarchies

1389: is
1390: l_dummy varchar2(1) := 'N';
1391: BEGIN
1392: SELECT 'Y' INTO l_dummy from dual
1393: where exists ( select 1 from amw_latest_hierarchies
1394: where organization_id = p_org_id
1395: and (parent_id = p_proc_id or child_id = p_proc_id));
1396: return l_dummy;
1397: EXCEPTION

Line 1443: from amw_latest_hierarchies

1439: l_dummy NUMBER;
1440: BEGIN
1441:
1442: select 1 INTO l_dummy
1443: from amw_latest_hierarchies
1444: where parent_id = p_proc_id
1445: and organization_id = p_org_id;
1446: return 'N';
1447: EXCEPTION