975: WHERE group_id = l_missSF_id(i);
976: ELSE
977: SELECT resource_name, source_id
978: INTO l_resource_name, l_source_id
979: FROM jtf_rs_resource_extns_vl
980: WHERE resource_id = l_missSF_id(i);
981: END IF;
982: IEX_TERR_WINNERS_PUB.Print_Debug('After selecting Resource_name = '|| l_resource_name );
983:
1034: WHERE group_id = l_missSF_id(i);
1035: ELSE
1036: SELECT resource_name, source_id
1037: INTO l_resource_name, l_source_id
1038: FROM jtf_rs_resource_extns_vl
1039: WHERE resource_id = l_missSF_id(i);
1040: END IF;
1041:
1042: INSERT INTO AR_COLLECTORS