APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_LATEST_HIERARCHIES

Line 27: select 1 from amw_latest_hierarchies where

23: * hierarchy?
24: */
25: cursor c_link_exist (l_parent_process_id number,
26: l_child_process_id number) is
27: select 1 from amw_latest_hierarchies where
28: (organization_id is null or organization_id = -1) and
29: parent_id = l_parent_process_id and
30: child_id = l_child_process_id;
31:

Line 37: from amw_latest_hierarchies

33:
34:
35: cursor c_all_latest_links_rl is
36: select parent_id, child_id
37: from amw_latest_hierarchies
38: where (organization_id is null or organization_id = -1);
39:
40: cursor c_all_latest_links_org(l_org_id in number) is
41: select parent_id, child_id

Line 42: from amw_latest_hierarchies

38: where (organization_id is null or organization_id = -1);
39:
40: cursor c_all_latest_links_org(l_org_id in number) is
41: select parent_id, child_id
42: from amw_latest_hierarchies
43: where (organization_id = l_org_id);
44:
45: cursor c_all_latest_relations is
46: select process_id, parent_child_id, up_down_ind

Line 50: type link_rec is record (parent_id amw_latest_hierarchies.parent_id%type,

46: select process_id, parent_child_id, up_down_ind
47: from amw_proc_hierarchy_denorm
48: where hierarchy_type = 'L';
49:
50: type link_rec is record (parent_id amw_latest_hierarchies.parent_id%type,
51: child_id amw_latest_hierarchies.child_id%type);
52:
53:
54: type links_tbl is table of link_rec;

Line 51: child_id amw_latest_hierarchies.child_id%type);

47: from amw_proc_hierarchy_denorm
48: where hierarchy_type = 'L';
49:
50: type link_rec is record (parent_id amw_latest_hierarchies.parent_id%type,
51: child_id amw_latest_hierarchies.child_id%type);
52:
53:
54: type links_tbl is table of link_rec;
55: type process_tbl is table of amw_proc_hierarchy_denorm.process_id%type;