DBA Data[Home] [Help]

APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_WF_HIERARCHY_V

Line 334: from amw_wf_hierarchy_v

330: procedure find_hierarchy_children(p_process_name in varchar2)
331: is
332: cursor c1 (l_name varchar2) is
333: select CHILD_PROCESS_NAME
334: from amw_wf_hierarchy_v
335: where PARENT_PROCESS_NAME=l_name;
336:
337: c1_rec c1%rowtype;
338:

Line 357: from amw_wf_hierarchy_v

353: procedure find_hierarchy_parent(p_process_name in varchar2)
354: is
355: cursor c1 (l_name varchar2) is
356: select PARENT_PROCESS_NAME
357: from amw_wf_hierarchy_v
358: where CHILD_PROCESS_NAME=l_name;
359:
360: c1_rec c1%rowtype;
361:

Line 2701: from amw_wf_hierarchy_v a, amw_process b1, amw_process b2

2697: procedure find_amwp_hierarchy_children(p_process_id in number)
2698: is
2699: cursor c1 (l_id number) is
2700: select b2.process_id
2701: from amw_wf_hierarchy_v a, amw_process b1, amw_process b2
2702: where b1.name = a.parent_process_name
2703: and b1.item_type = a.parent_item_type
2704: and b2.name = a.child_process_name
2705: and b2.item_type = a.child_item_type

Line 2728: from amw_wf_hierarchy_v a, amw_process b1, amw_process b2

2724: procedure find_amwp_hierarchy_parent(p_process_id in number)
2725: is
2726: cursor c1 (l_id number) is
2727: select b1.process_id
2728: from amw_wf_hierarchy_v a, amw_process b1, amw_process b2
2729: where b1.name = a.parent_process_name
2730: and b1.item_type = a.parent_item_type
2731: and b2.name = a.child_process_name
2732: and b2.item_type = a.child_item_type