APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on DUAL

Line 1041: FROM dual) b ) geco;

1037: and eec.change_notice=eec1.change_notice
1038: MINUS
1039: SELECT b.change_id
1040: FROM THE (SELECT CAST(p_change_lst as inv_ebi_change_id_obj_tbl)
1041: FROM dual) b ) geco;
1042:
1043: CURSOR c_get_final_eco_list IS
1044: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
1045: FROM (SELECT b.change_id,b.last_update_status

Line 1047: FROM dual ) b

1043: CURSOR c_get_final_eco_list IS
1044: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
1045: FROM (SELECT b.change_id,b.last_update_status
1046: FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)
1047: FROM dual ) b
1048: UNION
1049: SELECT c.change_id,c.last_update_status
1050: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)
1051: FROM dual ) c ) geco;

Line 1051: FROM dual ) c ) geco;

1047: FROM dual ) b
1048: UNION
1049: SELECT c.change_id,c.last_update_status
1050: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)
1051: FROM dual ) c ) geco;
1052: BEGIN
1053: l_eco_obj_tbl := inv_ebi_eco_out_obj_tbl();
1054: l_name_val_list := p_name_val_list;
1055: /* --BUG 8712091