APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on DUAL

Line 1465: FROM dual) b ) geco;

1461: and eec.change_notice=eec1.change_notice
1462: MINUS
1463: SELECT b.change_id
1464: FROM THE (SELECT CAST(p_change_lst as inv_ebi_change_id_obj_tbl)
1465: FROM dual) b ) geco;
1466:
1467: CURSOR c_get_final_eco_list IS
1468: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
1469: FROM (SELECT b.change_id,b.last_update_status

Line 1471: FROM dual ) b

1467: CURSOR c_get_final_eco_list IS
1468: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
1469: FROM (SELECT b.change_id,b.last_update_status
1470: FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)
1471: FROM dual ) b
1472: UNION
1473: SELECT c.change_id,c.last_update_status
1474: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)
1475: FROM dual ) c ) geco;

Line 1475: FROM dual ) c ) geco;

1471: FROM dual ) b
1472: UNION
1473: SELECT c.change_id,c.last_update_status
1474: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)
1475: FROM dual ) c ) geco;
1476: BEGIN
1477: l_eco_obj_tbl := inv_ebi_eco_out_obj_tbl();
1478: l_name_val_list := p_name_val_list;
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;