APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_CURR_APP_HIERARCHY_RL_V

Line 1154: from AMW_CURR_APP_HIERARCHY_RL_V);

1150:
1151: (select parent_process_id,
1152: child_process_id,
1153: child_order_number
1154: from AMW_CURR_APP_HIERARCHY_RL_V);
1155:
1156:
1157: begin
1158: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1394: from AMW_CURR_APP_HIERARCHY_RL_V

1390: l_dummy number;
1391:
1392: CURSOR c3 is
1393: (select parent_process_id, child_process_id
1394: from AMW_CURR_APP_HIERARCHY_RL_V
1395: where parent_process_id is not null)
1396: MINUS
1397: (select parent_process_id, child_process_id
1398: from AMW_CURR_APP_HIERARCHY_RL_V

Line 1398: from AMW_CURR_APP_HIERARCHY_RL_V

1394: from AMW_CURR_APP_HIERARCHY_RL_V
1395: where parent_process_id is not null)
1396: MINUS
1397: (select parent_process_id, child_process_id
1398: from AMW_CURR_APP_HIERARCHY_RL_V
1399: start with parent_process_id = -1
1400: connect by prior child_process_id = parent_process_id);
1401: begin
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1914: from AMW_CURR_APP_HIERARCHY_RL_V);

1910:
1911: (select parent_process_id,
1912: child_process_id,
1913: child_order_number
1914: from AMW_CURR_APP_HIERARCHY_RL_V);
1915:
1916:
1917:
1918:

Line 2499: from AMW_CURR_APP_HIERARCHY_RL_V);

2495:
2496: (select parent_process_id,
2497: child_process_id,
2498: child_order_number
2499: from AMW_CURR_APP_HIERARCHY_RL_V);
2500:
2501:
2502: begin
2503: ---05.23.2005 npanandi: commenting below log message