917: WHERE group_id = l_missSF_id(i);
918: ELSE
919: SELECT resource_name, source_id
920: INTO l_resource_name, l_source_id
921: FROM jtf_rs_resource_extns_vl
922: WHERE resource_id = l_missSF_id(i);
923: END IF;
924: IEX_TERR_WINNERS_PUB.Print_Debug('After selecting Resource_name = '|| l_resource_name );
925:
976: WHERE group_id = l_missSF_id(i);
977: ELSE
978: SELECT resource_name, source_id
979: INTO l_resource_name, l_source_id
980: FROM jtf_rs_resource_extns_vl
981: WHERE resource_id = l_missSF_id(i);
982: END IF;
983:
984: INSERT INTO AR_COLLECTORS