APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_LATEST_HIERARCHY_RL_V

Line 1144: child_order_number from AMW_LATEST_HIERARCHY_RL_V

1140:
1141: CURSOR c1 is
1142: (select parent_process_id,
1143: child_process_id,
1144: child_order_number from AMW_LATEST_HIERARCHY_RL_V
1145: start with parent_process_id = -1 and
1146: parent_approval_status = 'A'
1147: connect by prior child_process_id = parent_process_id and
1148: child_approval_status = 'A' )

Line 1876: from amw_latest_hierarchy_rl_v

1872: and process_item_type = l_item_type
1873: )
1874: MINUS
1875: (select child_name activity_name, child_item_type activity_item_type
1876: from amw_latest_hierarchy_rl_v
1877: where parent_name = l_name
1878: and parent_item_type = l_item_type
1879: );
1880:

Line 1886: from amw_latest_hierarchy_rl_v

1882: wf_diff_icm wf_minus_icm_tbl;
1883:
1884: cursor c_icm_minus_wf(l_name in varchar2, l_item_type in varchar2) is
1885: (select child_name, child_item_type
1886: from amw_latest_hierarchy_rl_v
1887: where parent_name = l_name
1888: and parent_item_type = l_item_type
1889: )
1890: MINUS

Line 1904: child_order_number from AMW_LATEST_HIERARCHY_RL_V

1900:
1901: CURSOR c1 is
1902: (select parent_process_id,
1903: child_process_id,
1904: child_order_number from AMW_LATEST_HIERARCHY_RL_V
1905: start with parent_process_id = -1 and
1906: parent_approval_status = 'A'
1907: connect by prior child_process_id = parent_process_id and
1908: child_approval_status = 'A' )

Line 2489: child_order_number from AMW_LATEST_HIERARCHY_RL_V

2485:
2486: CURSOR c1 is
2487: (select parent_process_id,
2488: child_process_id,
2489: child_order_number from AMW_LATEST_HIERARCHY_RL_V
2490: start with parent_process_id = -1 and
2491: parent_approval_status = 'A'
2492: connect by prior child_process_id = parent_process_id and
2493: child_approval_status = 'A' )