DBA Data[Home] [Help]

APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_WF_PROCESS_HIERARCHY_VL

Line 1860: from amw_wf_process_hierarchy_vl

1856: cursor c_wf_children (l_name in varchar2, l_item_type in varchar2) is
1857: select activity_item_type, activity_name,
1858: activity_display_name, activity_description,
1859: instance_id
1860: from amw_wf_process_hierarchy_vl
1861: where process_name = l_name and
1862: process_item_type = l_item_type;
1863: type wf_children_tbl is table of c_wf_children%rowtype;
1864:

Line 1870: from amw_wf_process_hierarchy_vl

1866:
1867:
1868: cursor c_wf_minus_icm(l_name in varchar2, l_item_type in varchar2) is
1869: (select activity_name, activity_item_type
1870: from amw_wf_process_hierarchy_vl
1871: where process_name = l_name
1872: and process_item_type = l_item_type
1873: )
1874: MINUS

Line 1892: from amw_wf_process_hierarchy_vl

1888: and parent_item_type = l_item_type
1889: )
1890: MINUS
1891: (select activity_name child_name, activity_item_type child_item_type
1892: from amw_wf_process_hierarchy_vl
1893: where process_name = l_name
1894: and process_item_type = l_item_type
1895: );
1896: