select objlevel, ObjType from tbl_BCRM_Objectives where ownerid = and ownertype = and objectiveid = select objectiveId from tbl_BCRM_Objectives where ownerid = and ownertype = and parentobjectiveid = select territoryId from tbl_BCRM_Objectives where ownerid = and ownertype = and objectiveid = select internalSalesId from tbl_ter_territories where ownerid = and fsl_tablecode = and territoryid =