APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_PROC_HIERARCHY_DENORM

Line 47: from amw_proc_hierarchy_denorm

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
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);

Line 55: type process_tbl is table of amw_proc_hierarchy_denorm.process_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;
56: type parent_child_tbl is table of amw_proc_hierarchy_denorm.parent_child_id%type;
57: type up_down_ind_tbl is table of amw_proc_hierarchy_denorm.up_down_ind%type;
58:
59:

Line 56: type parent_child_tbl is table of amw_proc_hierarchy_denorm.parent_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;
56: type parent_child_tbl is table of amw_proc_hierarchy_denorm.parent_child_id%type;
57: type up_down_ind_tbl is table of amw_proc_hierarchy_denorm.up_down_ind%type;
58:
59:
60:

Line 57: type up_down_ind_tbl is table of amw_proc_hierarchy_denorm.up_down_ind%type;

53:
54: type links_tbl is table of link_rec;
55: type process_tbl is table of amw_proc_hierarchy_denorm.process_id%type;
56: type parent_child_tbl is table of amw_proc_hierarchy_denorm.parent_child_id%type;
57: type up_down_ind_tbl is table of amw_proc_hierarchy_denorm.up_down_ind%type;
58:
59:
60:
61: